Sorry for tagging you again. I know you are much busy. But now we need to upgrade the journal. Ther version is 3.3…0.3
- I copied all the files and databases to another server for testing.
- During database making, I made a database and apply the character set of utf8_unicode_ci on a blank DB
- then I uploaded the old database.
- The website was working before the upgrade and the titles were fine
- I ran the upgrade with 3.3.0.11
- The upgrade was successful and all titles were in place and there was no font issue.
- I tried to make a new submission.
- Files were uploaded during submission
- I got this error when I clicked schedule for publication.
An unexpected error has occurred. Please reload the page and try again.
The log was this
[06-Jul-2022 08:17:03 UTC] PHP Fatal error: Uncaught Exception: DB Error: Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation ‘=’ Query: SELECT v.*
FROM versions v LEFT JOIN plugin_settings ps ON
lower(v.product_class_name) = ps.plugin_name
AND ps.setting_name = ‘enabled’ AND (context_id = ? OR v.sitewide = 1)
WHERE v.current = 1 AND (ps.setting_value = ‘1’ OR v.lazy_load <> 1) in /home/hamdardis/public_html/joqs/new/lib/pkp/classes/db/DAO.inc.php:703
From the above log, i checked the database
The db collation (from the Operations tab in phpmyadmin) was utf8_unicode_ci
The tables collation (from the structure tab) was utf8_general_ci
Please guide what should I do.
Thankyou