Describe the issue or problem
- I made a clone of both the 3.2.1.1 package and the attached mysql database, and confirmed that the clone worked identically to the production server.
- I then substituted the code for 3.3.0.13 in the directory, keeping the original config.inc.php file, setting “installed = Off”
- When I then attempted to access the application and selected “[Click here]” where it says " If you are upgrading an existing installation of OJS, click here to proceed
- On the next page, I then clicked “Open Open Journal Systems” but simply received a white page.
- Reloading the page, two new lines appeared in the previous dialog:
Errors occurred processing this form:
- [The form was not submitted properly.] with this non-working link: (https://teslej-sub.org/ejojs4/index.php/index/install/installUpgrade#dummy)
- Looking at the error-log, I find this:
[07-Feb-2023 03:09:10 America/Chicago] PHP Fatal error: Uncaught PDOException: SQLSTATE[42000]: Syntax error or access violation: 1115 Unknown character set: ‘’ in /home/teslejsu/public_html/ejojs4/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:79
Stack trace:
#0 /home/teslejsu/public_html/ejojs4/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(79): PDO->prepare(‘set names ‘’ co…’, Array)
#1 /home/teslejsu/public_html/ejojs4/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connectors/MySqlConnector.php(76): Doctrine\DBAL\Driver\PDOConnection->prepare(‘set names ‘’ co…’)
#2 /home/teslejsu/public_html/ejojs4/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connectors/MySqlConnector.php(32): Illuminate\Database\Connectors\MySqlConnector->configureEncoding(Object(Doctrine\DBAL\Driver\PDOConnection), Array)
#3 /home/teslejsu/public_html/ejojs4/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connectors/ConnectionFactory.php(184): Illuminate\Database\Connectors\MySqlConnector in /home/teslejsu/public_html/ejojs4/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php on line 672
My character set in the config file looks like this:
; Default locale
locale = en_US
; Client output/input character set
client_charset = utf-8
; Database connection character set
connection_charset = Off
What is the problem? How can I fix it? Any or all help would be appreciated!!