OJS upgrade 2.8.4 to 3.1 error

Software Support
14

Hi @Ptran,

Just to check your process – you should be doing something like this…

  • Drop and re-create your OJS database

  • Restore your database contents from a 2.8.4 backup

  • Execute the queries from the link above:

    CREATE TABLE review_round_files_old SELECT * FROM review_round_files;
DELETE FROM review_round_files WHERE review_round_id NOT IN(SELECT MIN(review_round_id) FROM review_round_files_old GROUP BY submission_id, review_round_id, stage_id, file_id, revision);
DROP TABLE review_round_files_old;

  • Try running the upgrade script again.

Regards,
Alec Smecher
Public Knowledge Project Team