ADOConnection._Execute(SELECT o.submission_id, MAX(s.context_id) AS journal_id, MAX(i.date_published) AS i_pub, MAX(p.date_published) A...) % line 1217, file: adodb.inc.php
ADOConnection.Execute(SELECT o.submission_id, MAX(s.context_id) AS journal_id, MAX(i.date_published) AS i_pub, MAX(p.date_published) A..., Array[1]) % line 2075, file: adodb.inc.php
ADOConnection.CacheExecute(3600, SELECT o.submission_id, MAX(s.context_id) AS journal_id, MAX(i.date_published) AS i_pub, MAX(p.date_published) A..., Array[2]) % line 132, file: DAO.inc.php
DAO.retrieveCached(SELECT o.submission_id, MAX(s.context_id) AS journal_id, MAX(i.date_published) AS i_pub, MAX(p.date_published) A..., Array[2], 3600) % line 91, file: ArticleSearchDAO.inc.php
ArticleSearchDAO.getPhraseResults(Object:Journal, Array[1], null, null, , 500, 1) % line 201, file: SubmissionSearch.inc.php
Fatal error: Uncaught Exception: DB Error: Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and (utf8mb4_unicode_ci,IMPLICIT) for operation '=' Query: 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')
JOIN issues i ON (CAST(i.issue_id AS CHAR(20)) = ps.setting_value)
JOIN submission_search_objects o ON (s.submission_id = o.submission_id)
NATURAL JOIN submission_search_object_keywords o0 NATURAL JOIN submission_search_keyword_list k0
WHERE
s.status = 3 AND
i.published = 1 AND k0.keyword_text = ? AND i.journal_id = ?
GROUP BY o.submission_id
ORDER BY count DESC
LIMIT 500 in /home/stebisig/ejournal.stebisigm.ac.id/lib/pkp/classes/db/DAO.inc.php:703
Stack trace:
#0 /home/stebisig/ in /home/stebisig/ejournal.stebisigm.ac.id/lib/pkp/classes/db/DAO.inc.php on line 703