Dublicate entry error in OMP upgrade

Software Support Open Monograph Press
1

Hi,

when upgrading from OMP 1.1.1.1 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?

best,
Carola

2

Hi @carola,

I suspect this is while running the dbscripts/xml/upgrade/1.2.0.0_update.xml 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 1.1.1.1 database shouldn’t have any reference to coverThumbnailsMaxWidth in its code/database.

Regards,
Alec Smecher
Public Knowledge Project Team

3

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.

best,
Carola