OJS - Archived Submission is loading but the list not coming; Article report error


Last week I have upgraded to OJS It is working fine but having the following error.

  1. Under Submission tab - Archived Submission tries to load but not working. Also, the total number comes for Unassigned, All Active but not to Archive. The error I am getting is : An unexpected error has occurred. Please reload the page and try again. It was working but suddenly it is not working

  2. Article Report - I am getting just one word (ascii word) report.

There is fatal error in the php error log.Article report

Hi @latha_ojs,

What do you see in your PHP error log?

Alec Smecher
Public Knowledge Project Team

[05-Nov-2020 12:48:58 Asia/Kolkata] PHP Fatal error: Uncaught Exception: DB Error: Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation ‘=’ Query: SELECT i.*
FROM issues i,
submissions a
LEFT JOIN publications p ON (p.publication_id = a.current_publication_id)
LEFT JOIN publication_settings ps ON (ps.publication_id = p.publication_id)
WHERE ps.setting_name = ? AND ps.setting_value = CAST(i.issue_id as CHAR) AND
a.submission_id = ? AND
a.context_id = i.journal_id in /home1/jott/public_html/lib/pkp/classes/db/DAO.inc.php:703
Stack trace:
#0 /home1/jott/public_html/lib/pkp/classes/db/DAO.inc.php(103): DAO->handleError(Object(ADODB_mysqli), ‘SELECT\ti.\n\t\t\tF…’)
#1 /home1/jott/public_html/classes/issue/IssueDAO.inc.php(560): DAO->retrieve('SELECT\ti.
\n\t\t\tF…’, Array)
#2 /home1/jott/public_html/plugins/generic/htmlArticleGalley/HtmlArticleGalleyPlugin.inc.php(180): IssueDAO->getBySubmissionId(667)
#3 /home1/jott/public_html/plugins/generic/htmlArticleGalley/HtmlArticleGalleyPlugin.inc.php in /home1/jott/public_html/lib/pkp/classes/db/DAO.inc.php on line 703

This is from the site

Uncaught TypeError: b is undefined
modalOpen http://threatenedtaxa.org/js/pkp.min.js?v=
ajaxErrorCallback http://threatenedtaxa.org/js/build.js?v=
error http://threatenedtaxa.org/js/build.js?v=

1 Like