Failed Upgrade OJS 3.1.1.2 to 3.3.0.19

[f666dhn]

Hi,

I have problem when upgrade OJS 3.1.1.2 to OJS 3.3.0.19

When upgrade process, it return to 500 error code.

This’s the error log:

Please help me to solve this problem.

Thanks.

[f666dhn]

Additional information:

I’m using PHP 7.4 for this OJS website and running under LiteSpeed Web Server.

I’ve set PHP max_execution_time to 1200

[asmecher]

Hi @f666dhn,

See e.g.:

This page isn’t workingjasrep.org is currently unable to handle this request. HTTP ERROR 500

Hi @Emmanuel_Nnadi, I believe that last message (Duplicate column name 'email_id') is showing up because you’re trying to run an upgrade on a database that’s already experienced a failed upgrade. Make sure to restore from backup before trying an upgrade again. Regards, Alec Smecher Public Knowledge Project Team

Regards,
Alec Smecher
Public Knowledge Project Team

[f666dhn]

Hi @asmecher

I’ve tried rollback the database then run upgrade again. But still experiencing the same issue.
Everytime i click the upgrade button, it always stuck then show response 500 error.

If it’s problem related to php max_execution_time, but i have set max_execution_time to 1200.

Any suggestions?

[asmecher]

Hi @f666dhn,

If you’ve successfully rolled back the database, then you’re probably encountering a different 500 error when you try the upgrade again. I’d suggest checking the log for details.

If you’re using the web-based upgrade tool and it’s an option to run it instead via command line, then I’d recommend doing that. Running a long process via command line is normally more robust and might not be subject to the same time limits as a web-based request. The upgrade process can take quite a while to run.

Regards,
Alec Smecher
Public Knowledge Project Team

[f666dhn]

Hi @asmecher,

Finally i solve this problem. The reason it return 500 error is because duplicate key for some user account on author table, i solve this problem by deleting the user account that causes key duplication in the author table.

Thanks.