Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8mb3_general_ci,CAST) and (latin1_swedish_ci,IMPLICIT) for operation '=' in /home/u890900728/domains/journals.ukitoraja.ac.id/public_html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php:453 Stack trace: #0 /home/u890900728/domains/journals.ukitoraja.ac.id/public_html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(453): PDOStatement->execute() #1 /home/u890900728/domains/journals.ukitoraja.ac.id/public_html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(753): Illuminate\Database\Connection->Illuminate\Database\{closure}() #2 /home/u890900728/domains/journals.ukitoraja.ac.id/public_html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(720): Illuminate\Database\Connection->runQueryCallback() #3 /home/u890900728/domains/journals.ukitoraja.ac.id/public_html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(456): Illuminate\Database\Connection->run() #4 /home/u890900728/domains/journals.ukitoraja.ac.id/public_html/classes/search/ArticleSearchDAO.php(113): Illuminate\Database\Connection->cursor() #5 /home/u890900728/domains/journals.ukitoraja.ac.id/public_html/lib/pkp/classes/search/SubmissionSearch.php(224): APP\search\ArticleSearchDAO->getPhraseResults() #6 /home/u890900728/domains/journals.ukitoraja.ac.id/public_html/lib/pkp/classes/search/SubmissionSearch.php(171): PKP\search\SubmissionSearch->_getMergedPhraseResults() #7 /home/u890900728/domains/journals.ukitoraja.ac.id/public_html/lib/pkp/classes/search/SubmissionSearch.php(220): PKP\search\SubmissionSearch->_getMergedKeywordResults() #8 /home/u890900728/domains/journals.ukitoraja.ac.id/public_html/lib/pkp/classes/search/SubmissionSearch.php(171): PKP\search\SubmissionSearch->_getMergedPhraseResults() #9 /home/u890900728/domains/journals.ukitoraja.ac.id/public_html/lib/pkp/classes/search/SubmissionSearch.php(156): PKP\search\SubmissionSearch->_getMergedKeywordResults() #10 /home/u890900728/domains/journals.ukitoraja.ac.id/public_html/lib/pkp/classes/search/SubmissionSearch.php(289): PKP\search\SubmissionSearch->_getMergedArray() #11 /home/u890900728/domains/journals.ukitoraja.ac.id/public_html/pages/search/SearchHandler.php(150): PKP\search\SubmissionSearch->retrieveResults() #12 [internal function]: APP\pages\search\SearchHandler->search() #13 /home/u890900728/domains/journals.ukitoraja.ac.id/public_html/lib/pkp/classes/core/PKPRouter.php(334): call_user_func() #14 /home/u890900728/domains/journals.ukitoraja.ac.id/public_html/lib/pkp/classes/core/PKPPageRouter.php(277): PKP\core\PKPRouter->_authorizeInitializeAndCallRequest() #15 /home/u890900728/domains/journals.ukitoraja.ac.id/public_html/lib/pkp/classes/core/Dispatcher.php(165): PKP\core\PKPPageRouter->route() #16 /home/u890900728/domains/journals.ukitoraja.ac.id/public_html/lib/pkp/classes/core/PKPApplication.php(388): PKP\core\Dispatcher->dispatch() #17 /home/u890900728/domains/journals.ukitoraja.ac.id/public_html/index.php(21): PKP\core\PKPApplication->execute() #18 {main} Next Illuminate\Database\QueryException: SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8mb3_general_ci,CAST) and (latin1_swedish_ci,IMPLICIT) for operation '=' (SQL: SELECT o.submission_id, MAX(s.context_id) AS journal_id, MAX(i.date_published) AS i_pub, MAX(p.date_published) AS s_pub, COUNT(*) AS count FROM submissions s JOIN publications p ON (p.publication_id = s.current_publication_id) JOIN publication_settings ps ON (ps.publication_id = p.publication_id AND ps.setting_name='issueId' AND ps.locale='') JOIN issues i ON (CAST(i.issue_id AS CHAR(20)) = ps.setting_value AND i.journal_id = s.context_id) JOIN submission_search_objects o ON (s.submission_id = o.submission_id) JOIN journals j ON j.journal_id = s.context_id LEFT JOIN journal_settings js ON j.journal_id = js.journal_id AND js.setting_name = 'publishingMode' NATURAL JOIN submission_search_object_keywords o0 NATURAL JOIN submission_search_keyword_list k0 WHERE (js.setting_value <> '2' OR js.setting_value IS NULL) AND j.enabled = 1 AND s.status = 3 AND i.published = 1 AND k0.keyword_text = cow AND i.journal_id = 22 GROUP BY o.submission_id ORDER BY count DESC LIMIT 500) in /home/u890900728/domains/journals.ukitoraja.ac.id/public_html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php:760 Stack trace: #0 /home/u890900728/domains/journals.ukitoraja.ac.id/public_html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(720): Illuminate\Database\Connection->runQueryCallback() #1 /home/u890900728/domains/journals.ukitoraja.ac.id/public_html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(456): Illuminate\Database\Connection->run() #2 /home/u890900728/domains/journals.ukitoraja.ac.id/public_html/classes/search/ArticleSearchDAO.php(113): Illuminate\Database\Connection->cursor() #3 /home/u890900728/domains/journals.ukitoraja.ac.id/public_html/lib/pkp/classes/search/SubmissionSearch.php(224): APP\search\ArticleSearchDAO->getPhraseResults() #4 /home/u890900728/domains/journals.ukitoraja.ac.id/public_html/lib/pkp/classes/search/SubmissionSearch.php(171): PKP\search\SubmissionSearch->_getMergedPhraseResults() #5 /home/u890900728/domains/journals.ukitoraja.ac.id/public_html/lib/pkp/classes/search/SubmissionSearch.php(220): PKP\search\SubmissionSearch->_getMergedKeywordResults() #6 /home/u890900728/domains/journals.ukitoraja.ac.id/public_html/lib/pkp/classes/search/SubmissionSearch.php(171): PKP\search\SubmissionSearch->_getMergedPhraseResults() #7 /home/u890900728/domains/journals.ukitoraja.ac.id/public_html/lib/pkp/classes/search/SubmissionSearch.php(156): PKP\search\SubmissionSearch->_getMergedKeywordResults() #8 /home/u890900728/domains/journals.ukitoraja.ac.id/public_html/lib/pkp/classes/search/SubmissionSearch.php(289): PKP\search\SubmissionSearch->_getMergedArray() #9 /home/u890900728/domains/journals.ukitoraja.ac.id/public_html/pages/search/SearchHandler.php(150): PKP\search\SubmissionSearch->retrieveResults() #10 [internal function]: APP\pages\search\SearchHandler->search() #11 /home/u890900728/domains/journals.ukitoraja.ac.id/public_html/lib/pkp/classes/core/PKPRouter.php(334): call_user_func() #12 /home/u890900728/domains/journals.ukitoraja.ac.id/public_html/lib/pkp/classes/core/PKPPageRouter.php(277): PKP\core\PKPRouter->_authorizeInitializeAndCallRequest() #13 /home/u890900728/domains/journals.ukitoraja.ac.id/public_html/lib/pkp/classes/core/Dispatcher.php(165): PKP\core\PKPPageRouter->route() #14 /home/u890900728/domains/journals.ukitoraja.ac.id/public_html/lib/pkp/classes/core/PKPApplication.php(388): PKP\core\Dispatcher->dispatch() #15 /home/u890900728/domains/journals.ukitoraja.ac.id/public_html/index.php(21): PKP\core\PKPApplication->execute() #16 {main} thrown in /home/u890900728/domains/journals.ukitoraja.ac.id/public_html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php on line 760