[OJS and QuickSubmit] Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT)

Software Support
,
3

Hi @luca.g

This is happening because you either have database tables in your database that do not have a collation of utf8_general_ci, or your connection collation for your sever environment is utf8_unicode_ci.

There are a few database queries in OJS 3.3 that use CAST to convert numbers to strings for comparison, and this CAST carries an implicit collation. It looks like some of your database tables do not match it.

Best,
Jason