Description of issue or problem I’m having:
HTTP 500 error occasionally when logging in to OJS after upgrading from 188.8.131.52 to 184.108.40.206
Steps I took leading up to the issue:
Upgrading to 220.127.116.11, I did have some issues with not only character encoding (database was latin1), but differing database engines across tables. I had to manually set some tables to MyISAM to get the upgrade to complete without foreign key errors. Everything except for this so far seems good post-all these issues though.
What I tried to resolve the issue:
Nothing yet, if you refresh the page it logs in fine.
Application Version - e.g., OJS 3.1.2:
Additional information, such as screenshots and error log messages if applicable:
From the Apache error log when the 500 error happens:
[php7:error] [pid 23983:tid 139654652159744] [client 18.104.22.168:54311] PHP Fatal error: Uncaught PDOException: SQLSTATE: Integrity constraint violation: 1062 Duplicate entry ‘1’ for key ‘user_settings_user_id’ in /var/www/html/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:115