Hello,
Recently upgraded OJS version 3.2.1.4 to 3.3.0.11 and ffter the upgrade, I have found one problem in search option, it’s showing
This page isn’t working
mydomain.com is currently unable to handle this request.
HTTP ERROR 500
Please help me
ERROR LOG
[06-Feb-2023 05:46:57 UTC] PHP Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation ‘=’ in /home/mssubmis/public_html/mydomain.com/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:78
Stack trace:
#0 /home/mssubmis/public_html/mydomain.com/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(78): PDO->prepare(‘SELECT\n\t\t\t\to.su…’, Array)
#1 /home/mssubmis/public_html/mydomain.com/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(361): Doctrine\DBAL\Driver\PDOConnection->prepare(Object(Illuminate\Database\Query\Expression))
#2 /home/mssubmis/public_html/mydomain.com/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(664): Illuminate\Database\Connection->Illuminate\Database{closure}(Object(Illuminate\Database\Query\Expression), Array)
#3 /home/mssubmis in /home/mssubmis/public_html/mydomain.com/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php on line 671
Please, check in this forum about “Illegal mix of collations” issues.
If nothing fits your case, try removing the content of your search tables and re-index your site.
Cheers,
m.
@adityab2
Please change mysql table collation types to utf8_general_ci
Process: Open PhpMyAdmin - open your database- please click on Operations Tab- then end of the page under collection, please select utf8_general_ci
Please tick Change all tables collations and Change all tables columns collations and click on go button.
I hope your problem will be solved.
Regards
Surojit Bera
1 Like