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

Software Support
27

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){
        $convert = "ALTER TABLE " . $table . " CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci";
        $queryTable = $dbHandler->prepare($convert);
        $queryTable->execute();
        echo $key . " =&gt; " . $table . " CONVERTED \n";
    }
}
?>
2 Likes