After upgrade OJS 3.2.1.4 to 3.3.0.11 Search option not working

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

@Surojit_Bera

Thank you. It’s working for me & solved my problem.

Thank you very much