Error when upgrading from OJS 3.3.0-21 to 3.4.0-9: Duplicate entry in user_settings

[asmecher]

Hi @Unce,

Here is a similar thread you might review:

Error upgrading from ojs-3.3.0-20 to ojs-3.4.0-9

Describe the issue or problem — If you see missing text in my post that is data sanitization. — I am running upgrade from ojs-3.3.0-20 to ojs-3.4.0-9, After running upgrade command “php tools/upgrade.php upgrade” I got the following errors: Example of error: A row with “author_id”=“111111” and “setting_name”=“biography” found in table “author_settings” which will conflict with other rows specific to the locale key “en” after the migration. Please review this row before upgrading. [root@ma…

In short, OJS 3.3.0-x used en_US as a locale code for English, and starting with 3.4.0-x, we use en instead. However, your database seems to already contain some data with the en locale code. Did you attempt an upgrade that failed? If so, you’ll need to restore from backup to a “clean” 3.3.0-x database.

Regards,
Alec Smecher
Public Knowledge Project Team