Hi,
Last week I have upgraded to OJS 3.2.1.1. It is working fine but having the following error.
-
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
-
Article Report - I am getting just one word (ascii word) report.
There is fatal error in the php error log.
Hi @latha_ojs,
What do you see in your PHP error log?
Regards,
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