OAI in OJS 3.3.0.5 is not working

[israel.cefrin]

@loveleentak

General error: 1267 Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT)

According to this post, you have the same issue than the thread author:

[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)

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

Please, review you database and tables charset collation and your config.inc.php Database collation parameter. They should be using all the same collation.

Best,
Israel