Dublicate entry error in OMP upgrade


when upgrading from OMP to 3.1 I’ve got two errors:

ERROR: Upgrade failed: DB: Duplicate entry ‘1–coverThumbnailsMaxWidth’ for key ‘press_settings_pkey’

ERROR: Upgrade failed: DB: Duplicate entry ‘1–coverThumbnailsMaxHeight’ for key ‘press_settings_pkey’

I upgrade via command line.

We have a git installation and I got the latest code for OMP 3.1.

Any idea what the reason might be?


Hi @carola,

I suspect this is while running the dbscripts/xml/upgrade/ script, right? It tries to introduce a default setting where versions of OMP previous to 1.2.0 didn’t have anything. Is it possible that your database was previously partially upgraded to OMP 1.2.0 or later and wasn’t restored from backup afterward? An OMP database shouldn’t have any reference to coverThumbnailsMaxWidth in its code/database.

Alec Smecher
Public Knowledge Project Team

Hi @asmecher,

Thanks, Alec! You are right, the commit possibility to define the size of cover thumbnails · asmecher/pkp-lib@ff1be65 · GitHub was added to the installation, and I guess also changes to the database.

I will try to work my way around it.