Resume failed upgrade Ojs2 to Ojs3

Hi, i tried to upgrade OJS to OJS 3x, but i got some fatal error. When i fixed it, i must restart the upgrade from the beginning. The upgrade process can take 2-3 days before i get another error. Can i start upgrading just from the error that occurs?

Hi @resika_arthana,

That might depend on the nature of the error - are you able to provide more details on what exactly the error is that you’re encountering? Are you upgrading to 3.2.1 as an intermediate step: How to Upgrade?

PKP Team

Hi @rcgillis

Thank you for your response, this my version

Code version:
Database version:
Latest version:
Database version is older than code version

Now i got new error :

Fatal error: Uncaught Exception: DB Error: Field ‘file_id’ doesn’t have a default value Query: INSERT INTO submission_galleys (locale, submission_id, remote_url, label) VALUES (?, ?, ?, ?) in /home/ubuntu/www/ejournal/ojs3/lib/pkp/classes/db/
Stack trace:
#0 /home/ubuntu/www/ejournal/ojs3/lib/pkp/classes/db/ DAO->handleError()
#1 /home/ubuntu/www/ejournal/ojs3/classes/install/ DAO->update()
#2 /home/ubuntu/www/ejournal/ojs3/lib/pkp/classes/install/ Upgrade->convertSupplementaryFiles()
#3 /home/ubuntu/www/ejournal/ojs3/lib/pkp/classes/install/ Installer->executeAction()
#4 /home/ubuntu/www/ejournal/ojs3/lib/pkp/classes/install/ Installer->executeInstaller()
#5 /home/ubuntu/www/ejournal/ojs3/lib/pkp/classes/cliTool/ Installer->execute()
#6 /home/ubuntu/www/ejournal/ojs3/lib/pkp/classes/cliTool/ UpgradeTool->upgrade()
#7 /home/ubuntu/www/ejournal/ojs3/tools in /home/ubuntu/www/ejournal/ojs3/lib/pkp/classes/db/ on line 703

I think the solution is or

But if i try to fix it and start the upgrade again, i must restore the database,source code, data file and waiting for a long time.
Any idea? thank you

Hi @resika_arthana,

Thanks for providing this further information. I’m not sure what to suggest at this point - but I will see if some of my other team members can look at this when they are available.

Best regards,

PKP Team

1 Like