Page home not working 🙏 "urgent"

[anass_ojs]

Hi, @jnugent

I have a problem with the homepage not working.

But the rest of the pages are working normally.

This is an “error_log” file : https://we.tl/t-Sa2w0XSxoZ

Help me please

[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

[anass_ojs]

hi @abadan @asmecher

I found some “table collations” mixes of arrangement. I fixed them.
But now I want to run “REGISTER” in the main page without problems.
Can you help me?

[abadan]

Look at the error log which occurs exactly when you try to access the registration page. Then, search the forum for the error found. You will usually find the solution.

If you still can’t find the solution, tell us what the error is, so we can help.

Regards,
Diego Abadan
Periódicos em Nuvens - Lepidus

[anass_ojs]

hi @abadan

Error 1 :
PHP Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation ‘=’ in /home1/boutiorg/public_html/example.com/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:78

Error 2 :
PHP Fatal error: Uncaught Error: Call to a member function getId() on null in /home1/boutiorg/public_html/example.com/plugins/generic/orcidProfile/OrcidProfilePlugin.inc.php:304