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

Software Support
1

Hi,

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

2

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

anyone have solve this?

3

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.

Regards,
Alec Smecher
Public Knowledge Project Team

1 Like