Upgrade to 3.2.1-4 to 3.3.0

Software Support
1

Describe the issue or problem
“I am upgrading OJS from 3.2.1-4 to 3.3.0-x on a local Laragon (Windows) environment. I keep getting SQLSTATE[42S01] Table temp_citations already exists and Fatal error: submission_id not found on citations. It seems the upgrade fails during the publication/citation migration and the automated rollback leaves the database in an inconsistent state. My MySQL version does not support IF EXISTS.”.

thanks

2

Hi @dtryant,

Did you take a backup before the first upgrade attempt? Partial upgrade attempts will leave the database in an indeterminate state. It’s best to restore from backup before trying again.

Regards,
Alec Smecher
Public Knowledge Project Team

3

Hi @asmecher
“Thank you for the advice. I have followed your instructions and restarted the process using the 3.2.1.4 backup. However, I am seeing many messages appearing in my terminal, so I have attached a screenshot for your review. Could you please help me identify what needs to be fixed? I am currently upgrading from 3.2.1-4 to 3.3.0-14, and once this upgrade is complete, I plan to proceed to the next version.”

image
image1366×768 139 KB

4

Hi @dtryant,

This looks like the same issue others have encountered in these threads:

I’d suggest trying the solutions recommended there.

Regards,
Alec Smecher
Public Knowledge Project Team

6

Hi @asmecher

Thank you for the solution. It helped me successfully upgrade to version 3.3.0, and now I can move on to the next version I want. Best wishes to you.

1 Like
7

This topic was automatically closed after 12 days. New replies are no longer allowed.