Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8mb3_general_ci,IMPLICIT) and (utf8mb4_bin,NONE) for operation 'like' in /home/u509201790/domains/irjaeh.com/public_html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php:419 Stack trace: #0 /home/u509201790/domains/irjaeh.com/public_html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(419): PDOStatement->execute() #1 /home/u509201790/domains/irjaeh.com/public_html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(753): Illuminate\Database\Connection->Illuminate\Database\{closure}() #2 /home/u509201790/domains/irjaeh.com/public_html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(720): Illuminate\Database\Connection->runQueryCallback() #3 /home/u509201790/domains/irjaeh.com/public_html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(422): Illuminate\Database\Connection->run() #4 /home/u509201790/domains/irjaeh.com/public_html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2706): Illuminate\Database\Connection->select() #5 /home/u509201790/domains/irjaeh.com/public_html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2694): Illuminate\Database\Query\Builder->runSelect() #6 /home/u509201790/domains/irjaeh.com/public_html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3230): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}() #7 /home/u509201790/domains/irjaeh.com/public_html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2695): Illuminate\Database\Query\Builder->onceWithColumns() #8 /home/u509201790/domains/irjaeh.com/public_html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3157): Illuminate\Database\Query\Builder->get() #9 /home/u509201790/domains/irjaeh.com/public_html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3085): Illuminate\Database\Query\Builder->aggregate() #10 /home/u509201790/domains/irjaeh.com/public_html/lib/pkp/classes/submission/DAO.php(94): Illuminate\Database\Query\Builder->count() #11 /home/u509201790/domains/irjaeh.com/public_html/lib/pkp/classes/submission/Collector.php(83): PKP\submission\DAO->getCount() #12 /home/u509201790/domains/irjaeh.com/public_html/plugins/generic/recommendBySimilarity/RecommendBySimilarityPlugin.php(85): PKP\submission\Collector->getCount() #13 /home/u509201790/domains/irjaeh.com/public_html/plugins/generic/recommendBySimilarity/RecommendBySimilarityPlugin.php(47): APP\plugins\generic\recommendBySimilarity\RecommendBySimilarityPlugin->buildTemplate() #14 [internal function]: APP\plugins\generic\recommendBySimilarity\RecommendBySimilarityPlugin->APP\plugins\generic\recommendBySimilarity\{closure}() #15 /home/u509201790/domains/irjaeh.com/public_html/lib/pkp/classes/plugins/Hook.php(139): call_user_func_array() #16 /home/u509201790/domains/irjaeh.com/public_html/lib/pkp/classes/plugins/Hook.php(113): PKP\plugins\Hook::run() #17 /home/u509201790/domains/irjaeh.com/public_html/lib/pkp/classes/template/PKPTemplateManager.php(1740): PKP\plugins\Hook::call() #18 /home/u509201790/domains/irjaeh.com/public_html/cache/t_compile/42362804174f266c598cdb32c3208fc745b92101^1c372c95cd85572e0fbc9a53d0323a0b229cfc78_0.app.frontendpagesarticle.tpl.php(43): PKP\template\PKPTemplateManager->smartyCallHook() #19 /home/u509201790/domains/irjaeh.com/public_html/lib/pkp/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php(123): content_674873597c7315_35005204() #20 /home/u509201790/domains/irjaeh.com/public_html/lib/pkp/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php(114): Smarty_Template_Resource_Base->getRenderedTemplateCode() #21 /home/u509201790/domains/irjaeh.com/public_html/lib/pkp/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php(217): Smarty_Template_Compiled->render() #22 /home/u509201790/domains/irjaeh.com/public_html/lib/pkp/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php(238): Smarty_Internal_Template->render() #23 /home/u509201790/domains/irjaeh.com/public_html/lib/pkp/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php(134): Smarty_Internal_TemplateBase->_execute() #24 /home/u509201790/domains/irjaeh.com/public_html/lib/pkp/classes/template/PKPTemplateManager.php(1325): Smarty_Internal_TemplateBase->display() #25 /home/u509201790/domains/irjaeh.com/public_html/pages/article/ArticleHandler.php(355): PKP\template\PKPTemplateManager->display() #26 [internal function]: APP\pages\article\ArticleHandler->view() #27 /home/u509201790/domains/irjaeh.com/public_html/lib/pkp/classes/core/PKPRouter.php(334): call_user_func() #28 /home/u509201790/domains/irjaeh.com/public_html/lib/pkp/classes/core/PKPPageRouter.php(277): PKP\core\PKPRouter->_authorizeInitializeAndCallRequest() #29 /home/u509201790/domains/irjaeh.com/public_html/lib/pkp/classes/core/Dispatcher.php(165): PKP\core\PKPPageRouter->route() #30 /home/u509201790/domains/irjaeh.com/public_html/lib/pkp/classes/core/PKPApplication.php(388): PKP\core\Dispatcher->dispatch() #31 /home/u509201790/domains/irjaeh.com/public_html/index.php(21): PKP\core\PKPApplication->execute() #32 {main} Next Illuminate\Database\QueryException: SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8mb3_general_ci,IMPLICIT) and (utf8mb4_bin,NONE) for operation 'like' (SQL: select count(*) as aggregate from `submissions` as `s` left join `publications` as `po` on `s`.`current_publication_id` = `po`.`publication_id` where `s`.`context_id` in (1) and `s`.`status` in (3) and (exists (select * from `submission_search_objects` as `sso` inner join `submission_search_object_keywords` as `ssok` on `sso`.`object_id` = `ssok`.`object_id` inner join `submission_search_keyword_list` as `sskl` on `sskl`.`keyword_id` = `ssok`.`keyword_id` where `sskl`.`keyword_text` = LOWER(breast) and `s`.`submission_id` = `sso`.`submission_id`) or `s`.`submission_id` in (select `p`.`submission_id` from `publications` as `p` inner join `publication_settings` as `ps` on `p`.`publication_id` = `ps`.`publication_id` where `ps`.`setting_name` = title and LOWER(ps.setting_value) LIKE CONCAT('%', LOWER(breast), '%')) or `s`.`submission_id` in (select `p`.`submission_id` from `publications` as `p` inner join `authors` as `au` on `au`.`publication_id` = `p`.`publication_id` inner join `author_settings` as `aus` on `aus`.`author_id` = `au`.`author_id` where `aus`.`setting_name` in (givenName, familyName, orcid) and LOWER(aus.setting_value) LIKE CONCAT('%', LOWER(breast), '%')) or exists (select * from `submission_search_objects` as `sso` inner join `submission_search_object_keywords` as `ssok` on `sso`.`object_id` = `ssok`.`object_id` inner join `submission_search_keyword_list` as `sskl` on `sskl`.`keyword_id` = `ssok`.`keyword_id` where `sskl`.`keyword_text` = LOWER(cancer) and `s`.`submission_id` = `sso`.`submission_id`) or `s`.`submission_id` in (select `p`.`submission_id` from `publications` as `p` inner join `publication_settings` as `ps` on `p`.`publication_id` = `ps`.`publication_id` where `ps`.`setting_name` = title and LOWER(ps.setting_value) LIKE CONCAT('%', LOWER(cancer), '%')) or `s`.`submission_id` in (select `p`.`submission_id` from `publications` as `p` inner join `authors` as `au` on `au`.`publication_id` = `p`.`publication_id` inner join `author_settings` as `aus` on `aus`.`author_id` = `au`.`author_id` where `aus`.`setting_name` in (givenName, familyName, orcid) and LOWER(aus.setting_value) LIKE CONCAT('%', LOWER(cancer), '%')) or exists (select * from `submission_search_objects` as `sso` inner join `submission_search_object_keywords` as `ssok` on `sso`.`object_id` = `ssok`.`object_id` inner join `submission_search_keyword_list` as `sskl` on `sskl`.`keyword_id` = `ssok`.`keyword_id` where `sskl`.`keyword_text` = LOWER(diabetes) and `s`.`submission_id` = `sso`.`submission_id`) or `s`.`submission_id` in (select `p`.`submission_id` from `publications` as `p` inner join `publication_settings` as `ps` on `p`.`publication_id` = `ps`.`publication_id` where `ps`.`setting_name` = title and LOWER(ps.setting_value) LIKE CONCAT('%', LOWER(diabetes), '%')) or `s`.`submission_id` in (select `p`.`submission_id` from `publications` as `p` inner join `authors` as `au` on `au`.`publication_id` = `p`.`publication_id` inner join `author_settings` as `aus` on `aus`.`author_id` = `au`.`author_id` where `aus`.`setting_name` in (givenName, familyName, orcid) and LOWER(aus.setting_value) LIKE CONCAT('%', LOWER(diabetes), '%')) or exists (select * from `submission_search_objects` as `sso` inner join `submission_search_object_keywords` as `ssok` on `sso`.`object_id` = `ssok`.`object_id` inner join `submission_search_keyword_list` as `sskl` on `sskl`.`keyword_id` = `ssok`.`keyword_id` where `sskl`.`keyword_text` = LOWER(heart) and `s`.`submission_id` = `sso`.`submission_id`) or `s`.`submission_id` in (select `p`.`submission_id` from `publications` as `p` inner join `publication_settings` as `ps` on `p`.`publication_id` = `ps`.`publication_id` where `ps`.`setting_name` = title and LOWER(ps.setting_value) LIKE CONCAT('%', LOWER(heart), '%')) or `s`.`submission_id` in (select `p`.`submission_id` from `publications` as `p` inner join `authors` as `au` on `au`.`publication_id` = `p`.`publication_id` inner join `author_settings` as `aus` on `aus`.`author_id` = `au`.`author_id` where `aus`.`setting_name` in (givenName, familyName, orcid) and LOWER(aus.setting_value) LIKE CONCAT('%', LOWER(heart), '%')) or exists (select * from `submission_search_objects` as `sso` inner join `submission_search_object_keywords` as `ssok` on `sso`.`object_id` = `ssok`.`object_id` inner join `submission_search_keyword_list` as `sskl` on `sskl`.`keyword_id` = `ssok`.`keyword_id` where `sskl`.`keyword_text` = LOWER(disease) and `s`.`submission_id` = `sso`.`submission_id`) or `s`.`submission_id` in (select `p`.`submission_id` from `publications` as `p` inner join `publication_settings` as `ps` on `p`.`publication_id` = `ps`.`publication_id` where `ps`.`setting_name` = title and LOWER(ps.setting_value) LIKE CONCAT('%', LOWER(disease), '%')) or `s`.`submission_id` in (select `p`.`submission_id` from `publications` as `p` inner join `authors` as `au` on `au`.`publication_id` = `p`.`publication_id` inner join `author_settings` as `aus` on `aus`.`author_id` = `au`.`author_id` where `aus`.`setting_name` in (givenName, familyName, orcid) and LOWER(aus.setting_value) LIKE CONCAT('%', LOWER(disease), '%')) or exists (select * from `submission_search_objects` as `sso` inner join `submission_search_object_keywords` as `ssok` on `sso`.`object_id` = `ssok`.`object_id` inner join `submission_search_keyword_list` as `sskl` on `sskl`.`keyword_id` = `ssok`.`keyword_id` where `sskl`.`keyword_text` = LOWER(support) and `s`.`submission_id` = `sso`.`submission_id`) or `s`.`submission_id` in (select `p`.`submission_id` from `publications` as `p` inner join `publication_settings` as `ps` on `p`.`publication_id` = `ps`.`publication_id` where `ps`.`setting_name` = title and LOWER(ps.setting_value) LIKE CONCAT('%', LOWER(support), '%')) or `s`.`submission_id` in (select `p`.`submission_id` from `publications` as `p` inner join `authors` as `au` on `au`.`publication_id` = `p`.`publication_id` inner join `author_settings` as `aus` on `aus`.`author_id` = `au`.`author_id` where `aus`.`setting_name` in (givenName, familyName, orcid) and LOWER(aus.setting_value) LIKE CONCAT('%', LOWER(support), '%')) or exists (select * from `submission_search_objects` as `sso` inner join `submission_search_object_keywords` as `ssok` on `sso`.`object_id` = `ssok`.`object_id` inner join `submission_search_keyword_list` as `sskl` on `sskl`.`keyword_id` = `ssok`.`keyword_id` where `sskl`.`keyword_text` = LOWER(vector) and `s`.`submission_id` = `sso`.`submission_id`) or `s`.`submission_id` in (select `p`.`submission_id` from `publications` as `p` inner join `publication_settings` as `ps` on `p`.`publication_id` = `ps`.`publication_id` where `ps`.`setting_name` = title and LOWER(ps.setting_value) LIKE CONCAT('%', LOWER(vector), '%')) or `s`.`submission_id` in (select `p`.`submission_id` from `publications` as `p` inner join `authors` as `au` on `au`.`publication_id` = `p`.`publication_id` inner join `author_settings` as `aus` on `aus`.`author_id` = `au`.`author_id` where `aus`.`setting_name` in (givenName, familyName, orcid) and LOWER(aus.setting_value) LIKE CONCAT('%', LOWER(vector), '%')) or exists (select * from `submission_search_objects` as `sso` inner join `submission_search_object_keywords` as `ssok` on `sso`.`object_id` = `ssok`.`object_id` inner join `submission_search_keyword_list` as `sskl` on `sskl`.`keyword_id` = `ssok`.`keyword_id` where `sskl`.`keyword_text` = LOWER(machine) and `s`.`submission_id` = `sso`.`submission_id`) or `s`.`submission_id` in (select `p`.`submission_id` from `publications` as `p` inner join `publication_settings` as `ps` on `p`.`publication_id` = `ps`.`publication_id` where `ps`.`setting_name` = title and LOWER(ps.setting_value) LIKE CONCAT('%', LOWER(machine), '%')) or `s`.`submission_id` in (select `p`.`submission_id` from `publications` as `p` inner join `authors` as `au` on `au`.`publication_id` = `p`.`publication_id` inner join `author_settings` as `aus` on `aus`.`author_id` = `au`.`author_id` where `aus`.`setting_name` in (givenName, familyName, orcid) and LOWER(aus.setting_value) LIKE CONCAT('%', LOWER(machine), '%')) or exists (select * from `submission_search_objects` as `sso` inner join `submission_search_object_keywords` as `ssok` on `sso`.`object_id` = `ssok`.`object_id` inner join `submission_search_keyword_list` as `sskl` on `sskl`.`keyword_id` = `ssok`.`keyword_id` where `sskl`.`keyword_text` = LOWER(prediction) and `s`.`submission_id` = `sso`.`submission_id`) or `s`.`submission_id` in (select `p`.`submission_id` from `publications` as `p` inner join `publication_settings` as `ps` on `p`.`publication_id` = `ps`.`publication_id` where `ps`.`setting_name` = title and LOWER(ps.setting_value) LIKE CONCAT('%', LOWER(prediction), '%')) or `s`.`submission_id` in (select `p`.`submission_id` from `publications` as `p` inner join `authors` as `au` on `au`.`publication_id` = `p`.`publication_id` inner join `author_settings` as `aus` on `aus`.`author_id` = `au`.`author_id` where `aus`.`setting_name` in (givenName, familyName, orcid) and LOWER(aus.setting_value) LIKE CONCAT('%', LOWER(prediction), '%')) or exists (select * from `submission_search_objects` as `sso` inner join `submission_search_object_keywords` as `ssok` on `sso`.`object_id` = `ssok`.`object_id` inner join `submission_search_keyword_list` as `sskl` on `sskl`.`keyword_id` = `ssok`.`keyword_id` where `sskl`.`keyword_text` = LOWER(learning) and `s`.`submission_id` = `sso`.`submission_id`) or `s`.`submission_id` in (select `p`.`submission_id` from `publications` as `p` inner join `publication_settings` as `ps` on `p`.`publication_id` = `ps`.`publication_id` where `ps`.`setting_name` = title and LOWER(ps.setting_value) LIKE CONCAT('%', LOWER(learning), '%')) or `s`.`submission_id` in (select `p`.`submission_id` from `publications` as `p` inner join `authors` as `au` on `au`.`publication_id` = `p`.`publication_id` inner join `author_settings` as `aus` on `aus`.`author_id` = `au`.`author_id` where `aus`.`setting_name` in (givenName, familyName, orcid) and LOWER(aus.setting_value) LIKE CONCAT('%', LOWER(learning), '%'))) and `s`.`submission_id` not in (659)) in /home/u509201790/domains/irjaeh.com/public_html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php:760 Stack trace: #0 /home/u509201790/domains/irjaeh.com/public_html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(720): Illuminate\Database\Connection->runQueryCallback() #1 /home/u509201790/domains/irjaeh.com/public_html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(422): Illuminate\Database\Connection->run() #2 /home/u509201790/domains/irjaeh.com/public_html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2706): Illuminate\Database\Connection->select() #3 /home/u509201790/domains/irjaeh.com/public_html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2694): Illuminate\Database\Query\Builder->runSelect() #4 /home/u509201790/domains/irjaeh.com/public_html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3230): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}() #5 /home/u509201790/domains/irjaeh.com/public_html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2695): Illuminate\Database\Query\Builder->onceWithColumns() #6 /home/u509201790/domains/irjaeh.com/public_html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3157): Illuminate\Database\Query\Builder->get() #7 /home/u509201790/domains/irjaeh.com/public_html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3085): Illuminate\Database\Query\Builder->aggregate() #8 /home/u509201790/domains/irjaeh.com/public_html/lib/pkp/classes/submission/DAO.php(94): Illuminate\Database\Query\Builder->count() #9 /home/u509201790/domains/irjaeh.com/public_html/lib/pkp/classes/submission/Collector.php(83): PKP\submission\DAO->getCount() #10 /home/u509201790/domains/irjaeh.com/public_html/plugins/generic/recommendBySimilarity/RecommendBySimilarityPlugin.php(85): PKP\submission\Collector->getCount() #11 /home/u509201790/domains/irjaeh.com/public_html/plugins/generic/recommendBySimilarity/RecommendBySimilarityPlugin.php(47): APP\plugins\generic\recommendBySimilarity\RecommendBySimilarityPlugin->buildTemplate() #12 [internal function]: APP\plugins\generic\recommendBySimilarity\RecommendBySimilarityPlugin->APP\plugins\generic\recommendBySimilarity\{closure}() #13 /home/u509201790/domains/irjaeh.com/public_html/lib/pkp/classes/plugins/Hook.php(139): call_user_func_array() #14 /home/u509201790/domains/irjaeh.com/public_html/lib/pkp/classes/plugins/Hook.php(113): PKP\plugins\Hook::run() #15 /home/u509201790/domains/irjaeh.com/public_html/lib/pkp/classes/template/PKPTemplateManager.php(1740): PKP\plugins\Hook::call() #16 /home/u509201790/domains/irjaeh.com/public_html/cache/t_compile/42362804174f266c598cdb32c3208fc745b92101^1c372c95cd85572e0fbc9a53d0323a0b229cfc78_0.app.frontendpagesarticle.tpl.php(43): PKP\template\PKPTemplateManager->smartyCallHook() #17 /home/u509201790/domains/irjaeh.com/public_html/lib/pkp/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php(123): content_674873597c7315_35005204() #18 /home/u509201790/domains/irjaeh.com/public_html/lib/pkp/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php(114): Smarty_Template_Resource_Base->getRenderedTemplateCode() #19 /home/u509201790/domains/irjaeh.com/public_html/lib/pkp/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php(217): Smarty_Template_Compiled->render() #20 /home/u509201790/domains/irjaeh.com/public_html/lib/pkp/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php(238): Smarty_Internal_Template->render() #21 /home/u509201790/domains/irjaeh.com/public_html/lib/pkp/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php(134): Smarty_Internal_TemplateBase->_execute() #22 /home/u509201790/domains/irjaeh.com/public_html/lib/pkp/classes/template/PKPTemplateManager.php(1325): Smarty_Internal_TemplateBase->display() #23 /home/u509201790/domains/irjaeh.com/public_html/pages/article/ArticleHandler.php(355): PKP\template\PKPTemplateManager->display() #24 [internal function]: APP\pages\article\ArticleHandler->view() #25 /home/u509201790/domains/irjaeh.com/public_html/lib/pkp/classes/core/PKPRouter.php(334): call_user_func() #26 /home/u509201790/domains/irjaeh.com/public_html/lib/pkp/classes/core/PKPPageRouter.php(277): PKP\core\PKPRouter->_authorizeInitializeAndCallRequest() #27 /home/u509201790/domains/irjaeh.com/public_html/lib/pkp/classes/core/Dispatcher.php(165): PKP\core\PKPPageRouter->route() #28 /home/u509201790/domains/irjaeh.com/public_html/lib/pkp/classes/core/PKPApplication.php(388): PKP\core\Dispatcher->dispatch() #29 /home/u509201790/domains/irjaeh.com/public_html/index.php(21): PKP\core\PKPApplication->execute() #30 {main} thrown in /home/u509201790/domains/irjaeh.com/public_html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php on line 760