Page home not working 🙏 "urgent"

[abadan]

Please paste here only the error that occurs when accessing the home page.

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

Look:

Problem with upgrading to OJS 3.3.0.3

The same problem for me when I use search function. Is there any specific solution?

[OJS 3.2.1.1] Blank, white page ("Search" function)

Hi, i had the same problem and recently solved this i tried the same as @bricas but doesn’t work for me, so i do a php script for alter all tables, maybe can help somebody <?php // your connection $dbHandler = new PDO('mysql:host=localhost;'.'dbname=ojs_test;charset=utf8', 'user', 'password'); // convert code $sqlQuery = "SHOW TABLES;"; $query = $dbHandler->prepare($sqlQuery); $query->execute(); while ($row = $query->fetch(PDO::FETCH_OBJ)){ foreach ($row as $key => $table){ $conve…

DB Error in OJS 3.2.0.0 - illegal mix of collations

Hi @neuroscirn, This is a MySQL error message, not an OJS error message; you might find some helpful guidance e.g. on StackOverflow: mysql - Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '=' - Stack Overflow If you were able to resolve the issue, please post the resolution in case someone else runs into it. Regards, Alec Smecher Public Knowledge Project Team

Regards,
Diego Abadan
Periódicos em Nuvens - Lepidus