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/u502842961/domains/journal.poltekpelaceh.ac.id/public_html/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:119 Stack trace: #0 /home/u502842961/domains/journal.poltekpelaceh.ac.id/public_html/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(119): PDOStatement->execute() #1 /home/u502842961/domains/journal.poltekpelaceh.ac.id/public_html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(370): Doctrine\DBAL\Driver\PDOStatement->execute() #2 /home/u502842961/domains/journal.poltekpelaceh.ac.id/public_html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(664): Illuminate\Database\Connection->Illuminate\Database\{closure}() #3 /home/u502842961/domains/journal.poltekpelaceh.ac.id/public_html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(631): Illuminate\Database\Connection->runQueryCallback() #4 /home/u502842961/domains/journal.poltekpelaceh.ac.id/public_html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(352): Illuminate\Database\Connection->run() #5 /home/u502842961/domains/journal.poltekpelaceh.ac.id/public_html/classes/search/ArticleSearchDAO.inc.php(98): Illuminate\Database\Connection->cursor() #6 /home/u502842961/domains/journal.poltekpelaceh.ac.id/public_html/lib/pkp/classes/search/SubmissionSearch.inc.php(195): ArticleSearchDAO->getPhraseResults() #7 /home/u502842961/domains/journal.poltekpelaceh.ac.id/public_html/lib/pkp/classes/search/SubmissionSearch.inc.php(144): SubmissionSearch->_getMergedPhraseResults() #8 /home/u502842961/domains/journal.poltekpelaceh.ac.id/public_html/lib/pkp/classes/search/SubmissionSearch.inc.php(192): SubmissionSearch->_getMergedKeywordResults() #9 /home/u502842961/domains/journal.poltekpelaceh.ac.id/public_html/lib/pkp/classes/search/SubmissionSearch.inc.php(144): SubmissionSearch->_getMergedPhraseResults() #10 /home/u502842961/domains/journal.poltekpelaceh.ac.id/public_html/lib/pkp/classes/search/SubmissionSearch.inc.php(130): SubmissionSearch->_getMergedKeywordResults() #11 /home/u502842961/domains/journal.poltekpelaceh.ac.id/public_html/lib/pkp/classes/search/SubmissionSearch.inc.php(257): SubmissionSearch->_getMergedArray() #12 /home/u502842961/domains/journal.poltekpelaceh.ac.id/public_html/pages/search/SearchHandler.inc.php(124): SubmissionSearch->retrieveResults() #13 /home/u502842961/domains/journal.poltekpelaceh.ac.id/public_html/lib/pkp/classes/core/PKPRouter.inc.php(397): SearchHandler->search() #14 /home/u502842961/domains/journal.poltekpelaceh.ac.id/public_html/lib/pkp/classes/core/PKPPageRouter.inc.php(246): PKPRouter->_authorizeInitializeAndCallRequest() #15 /home/u502842961/domains/journal.poltekpelaceh.ac.id/public_html/lib/pkp/classes/core/Dispatcher.inc.php(144): PKPPageRouter->route() #16 /home/u502842961/domains/journal.poltekpelaceh.ac.id/public_html/lib/pkp/classes/core/PKPApplication.inc.php(360): Dispatcher->dispatch() #17 /home/u502842961/domains/journal.poltekpelaceh.ac.id/public_html/index.php(68): PKPApplication->execute() #18 {main} Next Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8mb3_general_ci,CAST) and (latin1_swedish_ci,IMPLICIT) for operation '=' in /home/u502842961/domains/journal.poltekpelaceh.ac.id/public_html/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18 Stack trace: #0 /home/u502842961/domains/journal.poltekpelaceh.ac.id/public_html/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(121): Doctrine\DBAL\Driver\PDO\Exception::new() #1 /home/u502842961/domains/journal.poltekpelaceh.ac.id/public_html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(370): Doctrine\DBAL\Driver\PDOStatement->execute() #2 /home/u502842961/domains/journal.poltekpelaceh.ac.id/public_html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(664): Illuminate\Database\Connection->Illuminate\Database\{closure}() #3 /home/u502842961/domains/journal.poltekpelaceh.ac.id/public_html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(631): Illuminate\Database\Connection->runQueryCallback() #4 /home/u502842961/domains/journal.poltekpelaceh.ac.id/public_html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(352): Illuminate\Database\Connection->run() #5 /home/u502842961/domains/journal.poltekpelaceh.ac.id/public_html/classes/search/ArticleSearchDAO.inc.php(98): Illuminate\Database\Connection->cursor() #6 /home/u502842961/domains/journal.poltekpelaceh.ac.id/public_html/lib/pkp/classes/search/SubmissionSearch.inc.php(195): ArticleSearchDAO->getPhraseResults() #7 /home/u502842961/domains/journal.poltekpelaceh.ac.id/public_html/lib/pkp/classes/search/SubmissionSearch.inc.php(144): SubmissionSearch->_getMergedPhraseResults() #8 /home/u502842961/domains/journal.poltekpelaceh.ac.id/public_html/lib/pkp/classes/search/SubmissionSearch.inc.php(192): SubmissionSearch->_getMergedKeywordResults() #9 /home/u502842961/domains/journal.poltekpelaceh.ac.id/public_html/lib/pkp/classes/search/SubmissionSearch.inc.php(144): SubmissionSearch->_getMergedPhraseResults() #10 /home/u502842961/domains/journal.poltekpelaceh.ac.id/public_html/lib/pkp/classes/search/SubmissionSearch.inc.php(130): SubmissionSearch->_getMergedKeywordResults() #11 /home/u502842961/domains/journal.poltekpelaceh.ac.id/public_html/lib/pkp/classes/search/SubmissionSearch.inc.php(257): SubmissionSearch->_getMergedArray() #12 /home/u502842961/domains/journal.poltekpelaceh.ac.id/public_html/pages/search/SearchHandler.inc.php(124): SubmissionSearch->retrieveResults() #13 /home/u502842961/domains/journal.poltekpelaceh.ac.id/public_html/lib/pkp/classes/core/PKPRouter.inc.php(397): SearchHandler->search() #14 /home/u502842961/domains/journal.poltekpelaceh.ac.id/public_html/lib/pkp/classes/core/PKPPageRouter.inc.php(246): PKPRouter->_authorizeInitializeAndCallRequest() #15 /home/u502842961/domains/journal.poltekpelaceh.ac.id/public_html/lib/pkp/classes/core/Dispatcher.inc.php(144): PKPPageRouter->route() #16 /home/u502842961/domains/journal.poltekpelaceh.ac.id/public_html/lib/pkp/classes/core/PKPApplication.inc.php(360): Dispatcher->dispatch() #17 /home/u502842961/domains/journal.poltekpelaceh.ac.id/public_html/index.php(68): 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 = energi AND i.journal_id = 1 GROUP BY o.submission_id ORDER BY count DESC LIMIT 500) in /home/u502842961/domains/journal.poltekpelaceh.ac.id/public_html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php:671 Stack trace: #0 /home/u502842961/domains/journal.poltekpelaceh.ac.id/public_html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(631): Illuminate\Database\Connection->runQueryCallback() #1 /home/u502842961/domains/journal.poltekpelaceh.ac.id/public_html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(352): Illuminate\Database\Connection->run() #2 /home/u502842961/domains/journal.poltekpelaceh.ac.id/public_html/classes/search/ArticleSearchDAO.inc.php(98): Illuminate\Database\Connection->cursor() #3 /home/u502842961/domains/journal.poltekpelaceh.ac.id/public_html/lib/pkp/classes/search/SubmissionSearch.inc.php(195): ArticleSearchDAO->getPhraseResults() #4 /home/u502842961/domains/journal.poltekpelaceh.ac.id/public_html/lib/pkp/classes/search/SubmissionSearch.inc.php(144): SubmissionSearch->_getMergedPhraseResults() #5 /home/u502842961/domains/journal.poltekpelaceh.ac.id/public_html/lib/pkp/classes/search/SubmissionSearch.inc.php(192): SubmissionSearch->_getMergedKeywordResults() #6 /home/u502842961/domains/journal.poltekpelaceh.ac.id/public_html/lib/pkp/classes/search/SubmissionSearch.inc.php(144): SubmissionSearch->_getMergedPhraseResults() #7 /home/u502842961/domains/journal.poltekpelaceh.ac.id/public_html/lib/pkp/classes/search/SubmissionSearch.inc.php(130): SubmissionSearch->_getMergedKeywordResults() #8 /home/u502842961/domains/journal.poltekpelaceh.ac.id/public_html/lib/pkp/classes/search/SubmissionSearch.inc.php(257): SubmissionSearch->_getMergedArray() #9 /home/u502842961/domains/journal.poltekpelaceh.ac.id/public_html/pages/search/SearchHandler.inc.php(124): SubmissionSearch->retrieveResults() #10 /home/u502842961/domains/journal.poltekpelaceh.ac.id/public_html/lib/pkp/classes/core/PKPRouter.inc.php(397): SearchHandler->search() #11 /home/u502842961/domains/journal.poltekpelaceh.ac.id/public_html/lib/pkp/classes/core/PKPPageRouter.inc.php(246): PKPRouter->_authorizeInitializeAndCallRequest() #12 /home/u502842961/domains/journal.poltekpelaceh.ac.id/public_html/lib/pkp/classes/core/Dispatcher.inc.php(144): PKPPageRouter->route() #13 /home/u502842961/domains/journal.poltekpelaceh.ac.id/public_html/lib/pkp/classes/core/PKPApplication.inc.php(360): Dispatcher->dispatch() #14 /home/u502842961/domains/journal.poltekpelaceh.ac.id/public_html/index.php(68): PKPApplication->execute() #15 {main} thrown in /home/u502842961/domains/journal.poltekpelaceh.ac.id/public_html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php on line 671