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
- Restore from backup v2.4
- I opened phpMyAdmin
- Opened my database
- 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
- and run it
- 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