Hi,
I upgraded the system from OJS 3.2 to 3.3.0-14
The database has the collation of all tables and database set to latin2_general_ci
After successful upgrade I have wrong character encoding.
In config.inc.php entered :
collation = latin2_general_ci
; Client output/input character set
client_charset = latin2_general_ci
; Database connection character set
connection_charset = latin2_general_ci
I get 500
2023-03-23 15:13:28.056085 [NOTICE] [1069940] [T0] [188.47.119.63:63810#APVH_…] [STDERR] PHP Fatal error: Uncaught PDOException: SQLSTATE[42000]: Syntax error or access violation: 1115 Unknown character set: ‘latin2_general_ci’ in /…/public_html/plock/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:80\nStack trace:\n#0 /…/public_html/plock/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(80): PDO->prepare('set names ‘lati…’, Array)\n#1 /…/public_html/plock/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connectors/MySqlConnector.php(76): Doctrine\DBAL\Driver\PDOConnection->prepare('set names ‘lati…’)\n#2 /…/public_html/plock/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connectors/MySqlConnector.php(32): Illuminate\Database\Connectors\MySqlConnector->configureEncoding(Object(Doctrine\DBAL\Driver\PDOConnection), Array)\n#3 /…/public_html/plock/lib/pkp/lib/vendor/lara in /…/public_html/plock/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php on line 671\n
how should I set it up correctly…
Is it necessary for me to change to utf8?
Regards
Xavi