Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8mb3_general_ci,IMPLICIT) and (utf8mb3_unicode_ci,IMPLICIT) for operation '=' in /var/www/html/prod/ojs3_rcu/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:80 Stack trace: #0 /var/www/html/prod/ojs3_rcu/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(80): PDO->prepare() #1 /var/www/html/prod/ojs3_rcu/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(361): Doctrine\DBAL\Driver\PDOConnection->prepare() #2 /var/www/html/prod/ojs3_rcu/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(664): Illuminate\Database\Connection->Illuminate\Database\{closure}() #3 /var/www/html/prod/ojs3_rcu/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(631): Illuminate\Database\Connection->runQueryCallback() #4 /var/www/html/prod/ojs3_rcu/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(373): Illuminate\Database\Connection->run() #5 [internal function]: Illuminate\Database\Connection->cursor() #6 /var/www/html/prod/ojs3_rcu/lib/pkp/classes/db/DAOResultFactory.inc.php(94): Generator->current() #7 /var/www/html/prod/ojs3_rcu/lib/pkp/classes/db/DAOResultIterator.inc.php(33): DAOResultFactory->next() #8 /var/www/html/prod/ojs3_rcu/lib/pkp/classes/db/DAOResultFactory.inc.php(182): DAOResultIterator->__construct() #9 /var/www/html/prod/ojs3_rcu/lib/pkp/classes/services/PKPSubmissionService.inc.php(108): DAOResultFactory->toIterator() #10 /var/www/html/prod/ojs3_rcu/lib/pkp/pages/catalog/PKPCatalogHandler.inc.php(75): PKP\Services\PKPSubmissionService->getMany() #11 /var/www/html/prod/ojs3_rcu/lib/pkp/classes/core/PKPRouter.inc.php(397): PKPCatalogHandler->category() #12 /var/www/html/prod/ojs3_rcu/lib/pkp/classes/core/PKPPageRouter.inc.php(246): PKPRouter->_authorizeInitializeAndCallRequest() #13 /var/www/html/prod/ojs3_rcu/lib/pkp/classes/core/Dispatcher.inc.php(144): PKPPageRouter->route() #14 /var/www/html/prod/ojs3_rcu/lib/pkp/classes/core/PKPApplication.inc.php(360): Dispatcher->dispatch() #15 /var/www/html/prod/ojs3_rcu/index.php(68): PKPApplication->execute() #16 {main} Next Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8mb3_general_ci,IMPLICIT) and (utf8mb3_unicode_ci,IMPLICIT) for operation '=' in /var/www/html/prod/ojs3_rcu/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18 Stack trace: #0 /var/www/html/prod/ojs3_rcu/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(85): Doctrine\DBAL\Driver\PDO\Exception::new() #1 /var/www/html/prod/ojs3_rcu/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(361): Doctrine\DBAL\Driver\PDOConnection->prepare() #2 /var/www/html/prod/ojs3_rcu/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(664): Illuminate\Database\Connection->Illuminate\Database\{closure}() #3 /var/www/html/prod/ojs3_rcu/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(631): Illuminate\Database\Connection->runQueryCallback() #4 /var/www/html/prod/ojs3_rcu/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(373): Illuminate\Database\Connection->run() #5 [internal function]: Illuminate\Database\Connection->cursor() #6 /var/www/html/prod/ojs3_rcu/lib/pkp/classes/db/DAOResultFactory.inc.php(94): Generator->current() #7 /var/www/html/prod/ojs3_rcu/lib/pkp/classes/db/DAOResultIterator.inc.php(33): DAOResultFactory->next() #8 /var/www/html/prod/ojs3_rcu/lib/pkp/classes/db/DAOResultFactory.inc.php(182): DAOResultIterator->__construct() #9 /var/www/html/prod/ojs3_rcu/lib/pkp/classes/services/PKPSubmissionService.inc.php(108): DAOResultFactory->toIterator() #10 /var/www/html/prod/ojs3_rcu/lib/pkp/pages/catalog/PKPCatalogHandler.inc.php(75): PKP\Services\PKPSubmissionService->getMany() #11 /var/www/html/prod/ojs3_rcu/lib/pkp/classes/core/PKPRouter.inc.php(397): PKPCatalogHandler->category() #12 /var/www/html/prod/ojs3_rcu/lib/pkp/classes/core/PKPPageRouter.inc.php(246): PKPRouter->_authorizeInitializeAndCallRequest() #13 /var/www/html/prod/ojs3_rcu/lib/pkp/classes/core/Dispatcher.inc.php(144): PKPPageRouter->route() #14 /var/www/html/prod/ojs3_rcu/lib/pkp/classes/core/PKPApplication.inc.php(360): Dispatcher->dispatch() #15 /var/www/html/prod/ojs3_rcu/index.php(68): PKPApplication->execute() #16 {main} Next Illuminate\Database\QueryException: SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8mb3_general_ci,IMPLICIT) and (utf8mb3_unicode_ci,IMPLICIT) for operation '=' (SQL: select `s`.*, COALESCE(publication_tlps.setting_value, publication_tlpsl.setting_value) from `submissions` as `s` left join `publications` as `publication_tlp` on `s`.`current_publication_id` = `publication_tlp`.`publication_id` left join `publication_settings` as `publication_tlps` on `publication_tlp`.`publication_id` = `publication_tlps`.`publication_id` and `publication_tlps`.`setting_name` = title and `publication_tlps`.`setting_value` != and `publication_tlps`.`locale` = es_ES left join `publications` as `publication_tlpl` on `s`.`current_publication_id` = `publication_tlpl`.`publication_id` left join `publication_settings` as `publication_tlpsl` on `publication_tlp`.`publication_id` = `publication_tlpsl`.`publication_id` and `publication_tlpsl`.`locale` = `s`.`locale` and `publication_tlpsl`.`setting_name` = title left join `publication_categories` as `pc` on `s`.`current_publication_id` = `pc`.`publication_id` where `s`.`context_id` = 24 and `s`.`status` in (3) and `pc`.`category_id` in (16) group by `s`.`submission_id`, COALESCE(publication_tlps.setting_value, publication_tlpsl.setting_value) order by COALESCE(publication_tlps.setting_value, publication_tlpsl.setting_value) asc LIMIT 25 OFFSET 0) in /var/www/html/prod/ojs3_rcu/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php:671 Stack trace: #0 /var/www/html/prod/ojs3_rcu/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(631): Illuminate\Database\Connection->runQueryCallback() #1 /var/www/html/prod/ojs3_rcu/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(373): Illuminate\Database\Connection->run() #2 [internal function]: Illuminate\Database\Connection->cursor() #3 /var/www/html/prod/ojs3_rcu/lib/pkp/classes/db/DAOResultFactory.inc.php(94): Generator->current() #4 /var/www/html/prod/ojs3_rcu/lib/pkp/classes/db/DAOResultIterator.inc.php(33): DAOResultFactory->next() #5 /var/www/html/prod/ojs3_rcu/lib/pkp/classes/db/DAOResultFactory.inc.php(182): DAOResultIterator->__construct() #6 /var/www/html/prod/ojs3_rcu/lib/pkp/classes/services/PKPSubmissionService.inc.php(108): DAOResultFactory->toIterator() #7 /var/www/html/prod/ojs3_rcu/lib/pkp/pages/catalog/PKPCatalogHandler.inc.php(75): PKP\Services\PKPSubmissionService->getMany() #8 /var/www/html/prod/ojs3_rcu/lib/pkp/classes/core/PKPRouter.inc.php(397): PKPCatalogHandler->category() #9 /var/www/html/prod/ojs3_rcu/lib/pkp/classes/core/PKPPageRouter.inc.php(246): PKPRouter->_authorizeInitializeAndCallRequest() #10 /var/www/html/prod/ojs3_rcu/lib/pkp/classes/core/Dispatcher.inc.php(144): PKPPageRouter->route() #11 /var/www/html/prod/ojs3_rcu/lib/pkp/classes/core/PKPApplication.inc.php(360): Dispatcher->dispatch() #12 /var/www/html/prod/ojs3_rcu/index.php(68): PKPApplication->execute() #13 {main} thrown in /var/www/html/prod/ojs3_rcu/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php on line 671