Upgrade Failed: DB: Duplicate entry '759-606-2984-1' for key 'review_round_files_pkey'

VirtualBox_Revista_06_04_2018_18_01_56
How to proceed? Thank you very much in advance.

Hi @Suporte,

See Upgrade to 3.0.0: pkey violation on review_rounds · Issue #1921 · pkp/pkp-lib · GitHub for some suggestions.

These queries would need to be run on your OJS 2.x database, before running the upgrade script.

Make sure to take a backup before you run the upgrade script or work directly with the database.

Regards,
Alec Smecher
Public Knowledge Project Team

Hi I have also error on upgrade
“A database error has occurred: Duplicate entry ‘3-2-7-1’ for key ‘review_round_files_pkey’”
see here screenshot-rascee.net-2020.05.07-22_09_09 - Nimbus Capture
I follow you suggested Upgrade to 3.0.0: pkey violation on review_rounds · Issue #1921 · pkp/pkp-lib · GitHub
but don’t know did I make it wright

  1. Restore from backup v2.4
  2. I opened phpMyAdmin
  3. Opened my database
  4. In Query add

CREATE TABLE review_rounds_old SELECT * FROM review_rounds;
DELETE FROM review_rounds WHERE review_round_id NOT IN (SELECT MIN(review_round_id) >>FROM review_rounds_old GROUP BY submission_id, round);
DROP TABLE review_rounds_old;
like this here screenshot-cp011.mydataknox.com_2083-2020.05.07-22_13_38 - Nimbus Capture

  1. and run it
  2. After that run upgrade but still have an error

Hi @komir,

I’ve responded to your other post – let’s keep the conversation there, so it doesn’t divide into two places.

Regards,
Alec Smecher
Public Knowledge Project Team