Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8mb4_unicode_ci,IMPLICIT) and (utf8mb4_general_ci,IMPLICIT) for operation '=' in /var/www/html/ojs34/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php:414 Stack trace: #0 /var/www/html/ojs34/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(414): PDO->prepare() #1 /var/www/html/ojs34/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(753): Illuminate\Database\Connection->Illuminate\Database\{closure}() #2 /var/www/html/ojs34/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(720): Illuminate\Database\Connection->runQueryCallback() #3 /var/www/html/ojs34/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(405): Illuminate\Database\Connection->run() #4 /var/www/html/ojs34/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2705): Illuminate\Database\Connection->select() #5 /var/www/html/ojs34/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2694): Illuminate\Database\Query\Builder->runSelect() #6 /var/www/html/ojs34/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3230): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}() #7 /var/www/html/ojs34/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2693): Illuminate\Database\Query\Builder->onceWithColumns() #8 /var/www/html/ojs34/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2844): Illuminate\Database\Query\Builder->get() #9 /var/www/html/ojs34/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2803): Illuminate\Database\Query\Builder->runPaginationCountQuery() #10 /var/www/html/ojs34/lib/pkp/classes/submission/DAO.php(94): Illuminate\Database\Query\Builder->getCountForPagination() #11 /var/www/html/ojs34/lib/pkp/classes/submission/Collector.php(83): PKP\submission\DAO->getCount() #12 /var/www/html/ojs34/lib/pkp/pages/catalog/PKPCatalogHandler.php(92): PKP\submission\Collector->getCount() #13 [internal function]: PKP\pages\catalog\PKPCatalogHandler->category() #14 /var/www/html/ojs34/lib/pkp/classes/core/PKPRouter.php(334): call_user_func() #15 /var/www/html/ojs34/lib/pkp/classes/core/PKPPageRouter.php(278): PKP\core\PKPRouter->_authorizeInitializeAndCallRequest() #16 /var/www/html/ojs34/lib/pkp/classes/core/Dispatcher.php(165): PKP\core\PKPPageRouter->route() #17 /var/www/html/ojs34/lib/pkp/classes/core/PKPApplication.php(395): PKP\core\Dispatcher->dispatch() #18 /var/www/html/ojs34/index.php(21): PKP\core\PKPApplication->execute() #19 {main} Next Illuminate\Database\QueryException: SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8mb4_unicode_ci,IMPLICIT) and (utf8mb4_general_ci,IMPLICIT) for operation '=' (SQL: select count(*) as aggregate from `submissions` as `s` left join `publications` as `po` on `s`.`current_publication_id` = `po`.`publication_id` 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` = en 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 inner join `publication_categories` as `pc` on `s`.`current_publication_id` = `pc`.`publication_id` where `s`.`context_id` in (1) and `s`.`status` in (3) and `pc`.`category_id` in (5)) in /var/www/html/ojs34/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php:760 Stack trace: #0 /var/www/html/ojs34/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(720): Illuminate\Database\Connection->runQueryCallback() #1 /var/www/html/ojs34/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(405): Illuminate\Database\Connection->run() #2 /var/www/html/ojs34/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2705): Illuminate\Database\Connection->select() #3 /var/www/html/ojs34/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2694): Illuminate\Database\Query\Builder->runSelect() #4 /var/www/html/ojs34/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3230): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}() #5 /var/www/html/ojs34/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2693): Illuminate\Database\Query\Builder->onceWithColumns() #6 /var/www/html/ojs34/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2844): Illuminate\Database\Query\Builder->get() #7 /var/www/html/ojs34/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2803): Illuminate\Database\Query\Builder->runPaginationCountQuery() #8 /var/www/html/ojs34/lib/pkp/classes/submission/DAO.php(94): Illuminate\Database\Query\Builder->getCountForPagination() #9 /var/www/html/ojs34/lib/pkp/classes/submission/Collector.php(83): PKP\submission\DAO->getCount() #10 /var/www/html/ojs34/lib/pkp/pages/catalog/PKPCatalogHandler.php(92): PKP\submission\Collector->getCount() #11 [internal function]: PKP\pages\catalog\PKPCatalogHandler->category() #12 /var/www/html/ojs34/lib/pkp/classes/core/PKPRouter.php(334): call_user_func() #13 /var/www/html/ojs34/lib/pkp/classes/core/PKPPageRouter.php(278): PKP\core\PKPRouter->_authorizeInitializeAndCallRequest() #14 /var/www/html/ojs34/lib/pkp/classes/core/Dispatcher.php(165): PKP\core\PKPPageRouter->route() #15 /var/www/html/ojs34/lib/pkp/classes/core/PKPApplication.php(395): PKP\core\Dispatcher->dispatch() #16 /var/www/html/ojs34/index.php(21): PKP\core\PKPApplication->execute() #17 {main} thrown in /var/www/html/ojs34/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php on line 760