Sorry for posting yet another one of these 3.3 upgrade problems, but I haven’t seen this one come up and thought maybe it’s a bug PKP should be aware of.
I’m trying to upgrade from 3.1.2 to 18.104.22.168 and keep hitting this error:
ERROR: Upgrade failed: DB: SQLSTATE: Integrity constraint violation: 1062 Duplicate entry '1738-fr_CA-remoteUrl' for key 'navigation_menu_item_settings_pkey' (SQL: insert into navigation_menu_item_settings
) values (1738, fr_CA, remoteUrl, http://www.bsc-sbc.ca, string))
I noticed that if I delete the offending remote URL from the navigation_menu_items table then it just fails on the next remote URL in the table when I rerun the upgrade. This particular journal is bilingual in case that helps.