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/u868401214/domains/isvsvegsci.in/public_html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php:419
Stack trace:
#0 /home/u868401214/domains/isvsvegsci.in/public_html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(419): PDOStatement->execute()
#1 /home/u868401214/domains/isvsvegsci.in/public_html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(753): Illuminate\Database\Connection->Illuminate\Database\{closure}()
#2 /home/u868401214/domains/isvsvegsci.in/public_html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(720): Illuminate\Database\Connection->runQueryCallback()
#3 /home/u868401214/domains/isvsvegsci.in/public_html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(405): Illuminate\Database\Connection->run()
#4 /home/u868401214/domains/isvsvegsci.in/public_html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2705): Illuminate\Database\Connection->select()
#5 /home/u868401214/domains/isvsvegsci.in/public_html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2694): Illuminate\Database\Query\Builder->runSelect()
#6 /home/u868401214/domains/isvsvegsci.in/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/u868401214/domains/isvsvegsci.in/public_html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2693): Illuminate\Database\Query\Builder->onceWithColumns()
#8 /home/u868401214/domains/isvsvegsci.in/public_html/lib/pkp/classes/submission/DAO.php(118): Illuminate\Database\Query\Builder->get()
#9 /home/u868401214/domains/isvsvegsci.in/public_html/lib/pkp/classes/submission/Collector.php(100): PKP\submission\DAO->getMany()
#10 /home/u868401214/domains/isvsvegsci.in/public_html/plugins/generic/recommendBySimilarity/RecommendBySimilarityPlugin.php(90): PKP\submission\Collector->getMany()
#11 /home/u868401214/domains/isvsvegsci.in/public_html/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/u868401214/domains/isvsvegsci.in/public_html/lib/pkp/classes/plugins/Hook.php(139): call_user_func_array()
#14 /home/u868401214/domains/isvsvegsci.in/public_html/lib/pkp/classes/plugins/Hook.php(113): PKP\plugins\Hook::run()
#15 /home/u868401214/domains/isvsvegsci.in/public_html/lib/pkp/classes/template/PKPTemplateManager.php(1740): PKP\plugins\Hook::call()
#16 /home/u868401214/domains/isvsvegsci.in/public_html/cache/t_compile/42362804174f266c598cdb32c3208fc745b92101^1c372c95cd85572e0fbc9a53d0323a0b229cfc78_0.app.frontendpagesarticle.tpl.php(43): PKP\template\PKPTemplateManager->smartyCallHook()
#17 /home/u868401214/domains/isvsvegsci.in/public_html/lib/pkp/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php(123): content_6524037f193cb5_68036254()
#18 /home/u868401214/domains/isvsvegsci.in/public_html/lib/pkp/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php(114): Smarty_Template_Resource_Base->getRenderedTemplateCode()
#19 /home/u868401214/domains/isvsvegsci.in/public_html/lib/pkp/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php(217): Smarty_Template_Compiled->render()
#20 /home/u868401214/domains/isvsvegsci.in/public_html/lib/pkp/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php(238): Smarty_Internal_Template->render()
#21 /home/u868401214/domains/isvsvegsci.in/public_html/lib/pkp/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php(134): Smarty_Internal_TemplateBase->_execute()
#22 /home/u868401214/domains/isvsvegsci.in/public_html/lib/pkp/classes/template/PKPTemplateManager.php(1325): Smarty_Internal_TemplateBase->display()
#23 /home/u868401214/domains/isvsvegsci.in/public_html/pages/article/ArticleHandler.php(355): PKP\template\PKPTemplateManager->display()
#24 [internal function]: APP\pages\article\ArticleHandler->view()
#25 /home/u868401214/domains/isvsvegsci.in/public_html/lib/pkp/classes/core/PKPRouter.php(334): call_user_func()
#26 /home/u868401214/domains/isvsvegsci.in/public_html/lib/pkp/classes/core/PKPPageRouter.php(277): PKP\core\PKPRouter->_authorizeInitializeAndCallRequest()
#27 /home/u868401214/domains/isvsvegsci.in/public_html/lib/pkp/classes/core/Dispatcher.php(165): PKP\core\PKPPageRouter->route()
#28 /home/u868401214/domains/isvsvegsci.in/public_html/lib/pkp/classes/core/PKPApplication.php(387): PKP\core\Dispatcher->dispatch()
#29 /home/u868401214/domains/isvsvegsci.in/public_html/index.php(21): PKP\core\PKPApplication->execute()
#30 {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 `s`.* 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(brinjal) 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(brinjal), '%')) 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(brinjal), '%')) 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(palak) 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(palak), '%')) 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(palak), '%')) 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(intercropping) 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(intercropping), '%')) 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(intercropping), '%')) 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(competitive) 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(competitive), '%')) 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(competitive), '%')) 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(indices) 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(indices), '%')) 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(indices), '%'))) and `s`.`submission_id` not in (244) order by (select COUNT(DISTINCT sskl.keyword_id) from `submission_search_objects` as `sso` inner join `submission_search_object_keywords` as `ssok` on `ssok`.`object_id` = `sso`.`object_id` inner join `submission_search_keyword_list` as `sskl` on `sskl`.`keyword_id` = `ssok`.`keyword_id` where (`sskl`.`keyword_text` = LOWER(brinjal) or `sskl`.`keyword_text` = LOWER(palak) or `sskl`.`keyword_text` = LOWER(intercropping) or `sskl`.`keyword_text` = LOWER(competitive) or `sskl`.`keyword_text` = LOWER(indices)) and `s`.`submission_id` = `sso`.`submission_id`) desc, (select COUNT(0) from `submission_search_objects` as `sso` inner join `submission_search_object_keywords` as `ssok` on `ssok`.`object_id` = `sso`.`object_id` inner join `submission_search_keyword_list` as `sskl` on `sskl`.`keyword_id` = `ssok`.`keyword_id` where (`sskl`.`keyword_text` = LOWER(brinjal) or `sskl`.`keyword_text` = LOWER(palak) or `sskl`.`keyword_text` = LOWER(intercropping) or `sskl`.`keyword_text` = LOWER(competitive) or `sskl`.`keyword_text` = LOWER(indices)) and `s`.`submission_id` = `sso`.`submission_id`) desc limit 10 offset 0) in /home/u868401214/domains/isvsvegsci.in/public_html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php:760
Stack trace:
#0 /home/u868401214/domains/isvsvegsci.in/public_html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(720): Illuminate\Database\Connection->runQueryCallback()
#1 /home/u868401214/domains/isvsvegsci.in/public_html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(405): Illuminate\Database\Connection->run()
#2 /home/u868401214/domains/isvsvegsci.in/public_html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2705): Illuminate\Database\Connection->select()
#3 /home/u868401214/domains/isvsvegsci.in/public_html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2694): Illuminate\Database\Query\Builder->runSelect()
#4 /home/u868401214/domains/isvsvegsci.in/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/u868401214/domains/isvsvegsci.in/public_html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2693): Illuminate\Database\Query\Builder->onceWithColumns()
#6 /home/u868401214/domains/isvsvegsci.in/public_html/lib/pkp/classes/submission/DAO.php(118): Illuminate\Database\Query\Builder->get()
#7 /home/u868401214/domains/isvsvegsci.in/public_html/lib/pkp/classes/submission/Collector.php(100): PKP\submission\DAO->getMany()
#8 /home/u868401214/domains/isvsvegsci.in/public_html/plugins/generic/recommendBySimilarity/RecommendBySimilarityPlugin.php(90): PKP\submission\Collector->getMany()
#9 /home/u868401214/domains/isvsvegsci.in/public_html/plugins/generic/recommendBySimilarity/RecommendBySimilarityPlugin.php(46): APP\plugins\generic\recommendBySimilarity\RecommendBySimilarityPlugin->buildTemplate()
#10 [internal function]: APP\plugins\generic\recommendBySimilarity\RecommendBySimilarityPlugin->APP\plugins\generic\recommendBySimilarity\{closure}()
#11 /home/u868401214/domains/isvsvegsci.in/public_html/lib/pkp/classes/plugins/Hook.php(139): call_user_func_array()
#12 /home/u868401214/domains/isvsvegsci.in/public_html/lib/pkp/classes/plugins/Hook.php(113): PKP\plugins\Hook::run()
#13 /home/u868401214/domains/isvsvegsci.in/public_html/lib/pkp/classes/template/PKPTemplateManager.php(1740): PKP\plugins\Hook::call()
#14 /home/u868401214/domains/isvsvegsci.in/public_html/cache/t_compile/42362804174f266c598cdb32c3208fc745b92101^1c372c95cd85572e0fbc9a53d0323a0b229cfc78_0.app.frontendpagesarticle.tpl.php(43): PKP\template\PKPTemplateManager->smartyCallHook()
#15 /home/u868401214/domains/isvsvegsci.in/public_html/lib/pkp/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php(123): content_6524037f193cb5_68036254()
#16 /home/u868401214/domains/isvsvegsci.in/public_html/lib/pkp/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php(114): Smarty_Template_Resource_Base->getRenderedTemplateCode()
#17 /home/u868401214/domains/isvsvegsci.in/public_html/lib/pkp/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php(217): Smarty_Template_Compiled->render()
#18 /home/u868401214/domains/isvsvegsci.in/public_html/lib/pkp/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php(238): Smarty_Internal_Template->render()
#19 /home/u868401214/domains/isvsvegsci.in/public_html/lib/pkp/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php(134): Smarty_Internal_TemplateBase->_execute()
#20 /home/u868401214/domains/isvsvegsci.in/public_html/lib/pkp/classes/template/PKPTemplateManager.php(1325): Smarty_Internal_TemplateBase->display()
#21 /home/u868401214/domains/isvsvegsci.in/public_html/pages/article/ArticleHandler.php(355): PKP\template\PKPTemplateManager->display()
#22 [internal function]: APP\pages\article\ArticleHandler->view()
#23 /home/u868401214/domains/isvsvegsci.in/public_html/lib/pkp/classes/core/PKPRouter.php(334): call_user_func()
#24 /home/u868401214/domains/isvsvegsci.in/public_html/lib/pkp/classes/core/PKPPageRouter.php(277): PKP\core\PKPRouter->_authorizeInitializeAndCallRequest()
#25 /home/u868401214/domains/isvsvegsci.in/public_html/lib/pkp/classes/core/Dispatcher.php(165): PKP\core\PKPPageRouter->route()
#26 /home/u868401214/domains/isvsvegsci.in/public_html/lib/pkp/classes/core/PKPApplication.php(387): PKP\core\Dispatcher->dispatch()
#27 /home/u868401214/domains/isvsvegsci.in/public_html/index.php(21): PKP\core\PKPApplication->execute()
#28 {main}
thrown in /home/u868401214/domains/isvsvegsci.in/public_html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php on line 760