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/u280303192/domains/sijss.com/public_html/journal/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php:419 Stack trace: #0 /home/u280303192/domains/sijss.com/public_html/journal/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(419): PDOStatement->execute() #1 /home/u280303192/domains/sijss.com/public_html/journal/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(753): Illuminate\Database\Connection->Illuminate\Database\{closure}() #2 /home/u280303192/domains/sijss.com/public_html/journal/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(720): Illuminate\Database\Connection->runQueryCallback() #3 /home/u280303192/domains/sijss.com/public_html/journal/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(422): Illuminate\Database\Connection->run() #4 /home/u280303192/domains/sijss.com/public_html/journal/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2706): Illuminate\Database\Connection->select() #5 /home/u280303192/domains/sijss.com/public_html/journal/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2694): Illuminate\Database\Query\Builder->runSelect() #6 /home/u280303192/domains/sijss.com/public_html/journal/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3230): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}() #7 /home/u280303192/domains/sijss.com/public_html/journal/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2695): Illuminate\Database\Query\Builder->onceWithColumns() #8 /home/u280303192/domains/sijss.com/public_html/journal/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2844): Illuminate\Database\Query\Builder->get() #9 /home/u280303192/domains/sijss.com/public_html/journal/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2803): Illuminate\Database\Query\Builder->runPaginationCountQuery() #10 /home/u280303192/domains/sijss.com/public_html/journal/lib/pkp/classes/submission/DAO.php(94): Illuminate\Database\Query\Builder->getCountForPagination() #11 /home/u280303192/domains/sijss.com/public_html/journal/lib/pkp/classes/submission/Collector.php(83): PKP\submission\DAO->getCount() #12 /home/u280303192/domains/sijss.com/public_html/journal/plugins/generic/recommendBySimilarity/RecommendBySimilarityPlugin.php(84): PKP\submission\Collector->getCount() #13 /home/u280303192/domains/sijss.com/public_html/journal/plugins/generic/recommendBySimilarity/RecommendBySimilarityPlugin.php(46): APP\plugins\generic\recommendBySimilarity\RecommendBySimilarityPlugin->buildTemplate() #14 [internal function]: APP\plugins\generic\recommendBySimilarity\RecommendBySimilarityPlugin->APP\plugins\generic\recommendBySimilarity\{closure}() #15 /home/u280303192/domains/sijss.com/public_html/journal/lib/pkp/classes/plugins/Hook.php(139): call_user_func_array() #16 /home/u280303192/domains/sijss.com/public_html/journal/lib/pkp/classes/plugins/Hook.php(113): PKP\plugins\Hook::run() #17 /home/u280303192/domains/sijss.com/public_html/journal/lib/pkp/classes/template/PKPTemplateManager.php(1787): PKP\plugins\Hook::call() #18 /home/u280303192/domains/sijss.com/public_html/journal/cache/t_compile/93b4f13326abf2c920de729fdcdace1580d9bcb7^addd65021fadf964339ab08cd1aa93ba59b14e9c_0.app.frontendobjectsarticle_details.tpl.php(560): PKP\template\PKPTemplateManager->smartyCallHook() #19 /home/u280303192/domains/sijss.com/public_html/journal/lib/pkp/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php(123): content_68064d248b7878_73995194() #20 /home/u280303192/domains/sijss.com/public_html/journal/lib/pkp/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php(114): Smarty_Template_Resource_Base->getRenderedTemplateCode() #21 /home/u280303192/domains/sijss.com/public_html/journal/lib/pkp/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php(217): Smarty_Template_Compiled->render() #22 /home/u280303192/domains/sijss.com/public_html/journal/lib/pkp/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php(386): Smarty_Internal_Template->render() #23 /home/u280303192/domains/sijss.com/public_html/journal/cache/t_compile/93b4f13326abf2c920de729fdcdace1580d9bcb7^1c372c95cd85572e0fbc9a53d0323a0b229cfc78_0.app.frontendpagesarticle.tpl.php(31): Smarty_Internal_Template->_subTemplateRender() #24 /home/u280303192/domains/sijss.com/public_html/journal/lib/pkp/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php(123): content_68064d24807003_70791294() #25 /home/u280303192/domains/sijss.com/public_html/journal/lib/pkp/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php(114): Smarty_Template_Resource_Base->getRenderedTemplateCode() #26 /home/u280303192/domains/sijss.com/public_html/journal/lib/pkp/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php(217): Smarty_Template_Compiled->render() #27 /home/u280303192/domains/sijss.com/public_html/journal/lib/pkp/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php(238): Smarty_Internal_Template->render() #28 /home/u280303192/domains/sijss.com/public_html/journal/lib/pkp/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php(134): Smarty_Internal_TemplateBase->_execute() #29 /home/u280303192/domains/sijss.com/public_html/journal/lib/pkp/classes/template/PKPTemplateManager.php(1372): Smarty_Internal_TemplateBase->display() #30 /home/u280303192/domains/sijss.com/public_html/journal/pages/article/ArticleHandler.php(355): PKP\template\PKPTemplateManager->display() #31 [internal function]: APP\pages\article\ArticleHandler->view() #32 /home/u280303192/domains/sijss.com/public_html/journal/lib/pkp/classes/core/PKPRouter.php(334): call_user_func() #33 /home/u280303192/domains/sijss.com/public_html/journal/lib/pkp/classes/core/PKPPageRouter.php(278): PKP\core\PKPRouter->_authorizeInitializeAndCallRequest() #34 /home/u280303192/domains/sijss.com/public_html/journal/lib/pkp/classes/core/Dispatcher.php(165): PKP\core\PKPPageRouter->route() #35 /home/u280303192/domains/sijss.com/public_html/journal/lib/pkp/classes/core/PKPApplication.php(395): PKP\core\Dispatcher->dispatch() #36 /home/u280303192/domains/sijss.com/public_html/journal/index.php(21): PKP\core\PKPApplication->execute() #37 {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(profitability) 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(profitability), '%')) 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(profitability), '%')) 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(structure) 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(structure), '%')) 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(structure), '%')) 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(csr) 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(csr), '%')) 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(csr), '%')) 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(indian) 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(indian), '%')) 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(indian), '%')) 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(companies) 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(companies), '%')) 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(companies), '%')) 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(core) 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(core), '%')) 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(core), '%')) 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(competencies) 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(competencies), '%')) 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(competencies), '%'))) and `s`.`submission_id` not in (1600)) in /home/u280303192/domains/sijss.com/public_html/journal/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php:760 Stack trace: #0 /home/u280303192/domains/sijss.com/public_html/journal/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(720): Illuminate\Database\Connection->runQueryCallback() #1 /home/u280303192/domains/sijss.com/public_html/journal/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(422): Illuminate\Database\Connection->run() #2 /home/u280303192/domains/sijss.com/public_html/journal/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2706): Illuminate\Database\Connection->select() #3 /home/u280303192/domains/sijss.com/public_html/journal/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2694): Illuminate\Database\Query\Builder->runSelect() #4 /home/u280303192/domains/sijss.com/public_html/journal/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3230): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}() #5 /home/u280303192/domains/sijss.com/public_html/journal/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2695): Illuminate\Database\Query\Builder->onceWithColumns() #6 /home/u280303192/domains/sijss.com/public_html/journal/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2844): Illuminate\Database\Query\Builder->get() #7 /home/u280303192/domains/sijss.com/public_html/journal/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2803): Illuminate\Database\Query\Builder->runPaginationCountQuery() #8 /home/u280303192/domains/sijss.com/public_html/journal/lib/pkp/classes/submission/DAO.php(94): Illuminate\Database\Query\Builder->getCountForPagination() #9 /home/u280303192/domains/sijss.com/public_html/journal/lib/pkp/classes/submission/Collector.php(83): PKP\submission\DAO->getCount() #10 /home/u280303192/domains/sijss.com/public_html/journal/plugins/generic/recommendBySimilarity/RecommendBySimilarityPlugin.php(84): PKP\submission\Collector->getCount() #11 /home/u280303192/domains/sijss.com/public_html/journal/plugins/generic/recommendBySimilarity/RecommendBySimilarityPlugin.php(46): APP\plugins\generic\recommendBySimilarity\RecommendBySimilarityPlugin->buildTemplate() #12 [internal function]: APP\plugins\generic\recommendBySimilarity\RecommendBySimilarityPlugin->APP\plugins\generic\recommendBySimilarity\{closure}() #13 /home/u280303192/domains/sijss.com/public_html/journal/lib/pkp/classes/plugins/Hook.php(139): call_user_func_array() #14 /home/u280303192/domains/sijss.com/public_html/journal/lib/pkp/classes/plugins/Hook.php(113): PKP\plugins\Hook::run() #15 /home/u280303192/domains/sijss.com/public_html/journal/lib/pkp/classes/template/PKPTemplateManager.php(1787): PKP\plugins\Hook::call() #16 /home/u280303192/domains/sijss.com/public_html/journal/cache/t_compile/93b4f13326abf2c920de729fdcdace1580d9bcb7^addd65021fadf964339ab08cd1aa93ba59b14e9c_0.app.frontendobjectsarticle_details.tpl.php(560): PKP\template\PKPTemplateManager->smartyCallHook() #17 /home/u280303192/domains/sijss.com/public_html/journal/lib/pkp/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php(123): content_68064d248b7878_73995194() #18 /home/u280303192/domains/sijss.com/public_html/journal/lib/pkp/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php(114): Smarty_Template_Resource_Base->getRenderedTemplateCode() #19 /home/u280303192/domains/sijss.com/public_html/journal/lib/pkp/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php(217): Smarty_Template_Compiled->render() #20 /home/u280303192/domains/sijss.com/public_html/journal/lib/pkp/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php(386): Smarty_Internal_Template->render() #21 /home/u280303192/domains/sijss.com/public_html/journal/cache/t_compile/93b4f13326abf2c920de729fdcdace1580d9bcb7^1c372c95cd85572e0fbc9a53d0323a0b229cfc78_0.app.frontendpagesarticle.tpl.php(31): Smarty_Internal_Template->_subTemplateRender() #22 /home/u280303192/domains/sijss.com/public_html/journal/lib/pkp/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php(123): content_68064d24807003_70791294() #23 /home/u280303192/domains/sijss.com/public_html/journal/lib/pkp/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php(114): Smarty_Template_Resource_Base->getRenderedTemplateCode() #24 /home/u280303192/domains/sijss.com/public_html/journal/lib/pkp/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php(217): Smarty_Template_Compiled->render() #25 /home/u280303192/domains/sijss.com/public_html/journal/lib/pkp/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php(238): Smarty_Internal_Template->render() #26 /home/u280303192/domains/sijss.com/public_html/journal/lib/pkp/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php(134): Smarty_Internal_TemplateBase->_execute() #27 /home/u280303192/domains/sijss.com/public_html/journal/lib/pkp/classes/template/PKPTemplateManager.php(1372): Smarty_Internal_TemplateBase->display() #28 /home/u280303192/domains/sijss.com/public_html/journal/pages/article/ArticleHandler.php(355): PKP\template\PKPTemplateManager->display() #29 [internal function]: APP\pages\article\ArticleHandler->view() #30 /home/u280303192/domains/sijss.com/public_html/journal/lib/pkp/classes/core/PKPRouter.php(334): call_user_func() #31 /home/u280303192/domains/sijss.com/public_html/journal/lib/pkp/classes/core/PKPPageRouter.php(278): PKP\core\PKPRouter->_authorizeInitializeAndCallRequest() #32 /home/u280303192/domains/sijss.com/public_html/journal/lib/pkp/classes/core/Dispatcher.php(165): PKP\core\PKPPageRouter->route() #33 /home/u280303192/domains/sijss.com/public_html/journal/lib/pkp/classes/core/PKPApplication.php(395): PKP\core\Dispatcher->dispatch() #34 /home/u280303192/domains/sijss.com/public_html/journal/index.php(21): PKP\core\PKPApplication->execute() #35 {main} thrown in /home/u280303192/domains/sijss.com/public_html/journal/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php on line 760