Upgrade pkp from 3.2.0.2 to 3.3.0.13

I facing this problem during upgrade of my pkp ojs 3.2.0.2 to 3.3.0.13

plz help me to solve this issue

Hi @aamunim

If you’re getting errors about tables already existing, I suspect that you tried to run this upgrade before and it failed. If that happens you need to restore your database from a backup taken from before you ran the upgrade. You cannot just try to run the upgrade again.

Best
Jason

i have restored my sql database, public folder and config.php file. but still, I am facing this issue

Hi @aamunim

I’ve searched through my own 3.2.0.2 code here and the subeditor_submission_group table does not exist in that OJS version. How are you restoring your database? Are you just mysql importing over top of what is there? If so, that will not work - you need to delete all of the tables in the mysql database before restoring it.

If you are deleting all of the tables, I suggest looking in your database dump (you can open these in a text editor) and check and see if that table exists there. If it does, I think that you’ve made a backup after a failed upgrade attempt.

Best
Jason