Problem upgrade OJS 3.4 to 3.5

Software Support
1

Describe the issue or problem
During the upgrade process of OJS from version 3.4 to version 3.5.1 in my local environment (localhost), I encountered a database error that prevents the installation from completing successfully. As a result, the upgrade fails with the following error message: “SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘redirect’ in ‘site’ (Connection: mysql, SQL: alter table site modify redirect bigint null)”. Could you please advise me on how to resolve this issue so that the upgrade can be completed without errors? You will find a screenshot of the returned error attached for reference.

Additional information
Environment (where applicable)

  • OJS version: 3.4 (upgrade target 3.5.1)

  • Database: MySQL

  • PHP version: 8.1

  • Server: Localhost (XAMPP)

222
2221365×671 68.5 KB

2

Hi @Mourad_SOUISSI,

The upgrade process renames the redirect column on the site table to redirect_context_id. You’re probably trying to re-run an upgrade after the column has already been renamed. Make sure you restore from backup before re-trying an upgrade, or else you’ll encounter failures like this.

Regards,
Alec Smecher
Public Knowledge Project Team

4

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