OJS 3.2 : Upgrade failed: DB: Duplicate entry '7258--language' for key 'publication_settings_pkey'


I’m trying to upgrade my OJS installation from 3.1.2 to 3.2 and I’m encountering a problem with the DB upgrade :

PKP-Database-Logger 1584606708.8962: Query:
INSERT INTO publication_settings(publication_id, setting_name, setting_value)
SELECT s.current_publication_id, ‘language’, ts.language
FROM submissions as s
LEFT JOIN temp_submissions as ts
ON s.submission_id = ts.submission_id
WHERE ts.language != ‘’
ERROR: Upgrade failed: DB: Duplicate entry ‘7258–language’ for key ‘publication_settings_pkey’

Do you have any idea of what the problem is ?

Thank’s for you help

i face this to when upgrading from 3.1.1-4 to 3.2.0

anyone have solve this?

Hi all,

I would recommend trying an update to the latest release, rather than 3.2.0. There have been improvements to the upgrade process that might resolve this.

Alec Smecher
Public Knowledge Project Team

1 Like