Hi
After upgrading from OJS 2.4.8 to 3.2.1-1 searches simply return a blank page.
The error log shows entries like this:
PHP Fatal error: Uncaught Exception: DB Error: Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation ‘=’ Query:
Both our old databases and the migrated ones all have utf8_unicode_ci as the collation set everywhere (database, tables, and columns)
I found this issue on github :
which seems germane, but I have added a parameter
collation = utf8_unicode_ci
to config.inc.php and I can confirm that
lib/pkp/classes/services/queryBuilders/BaseQueryBuilder.inc.php
in our code base contains the fix which is documented in the issue.
Can anyone suggest where utf8_general_ci might be coming from?