ERROR: Upgrade failed: DB: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'url' in 'field list'

Hello Sir
During upgrading of ojs 3.3.0.2 from 3.2.1.3 i am getting following error:
ERROR: Upgrade failed: DB: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘url’ in ‘field list’ (SQL: select url, navigation menu item id from navigation menu items where context_id = 1) [canadia8@nyc007 tools]$ ERROR: Upgrade failed: DB: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘url’ in ‘field list’ (SQL: select url, navigation_menu_item_id from navigation menu_items where context_id = 1)
Please help to solve the issue…
Thanks
Regards
Faisal Khan

Hi @cosmosscholars,

This is probably caused by a second attempt to run the upgrade script after a first attempt has failed. If an upgrade attempt fails, you’ll need to restore your database from backup before trying again. Note that OJS 3.3.0-3 has just been released, so I’d recommend working with that when you re-run your upgrade.

Regards,
Alec Smecher
Public Knowledge Project Team

1 Like

Hi
Thanks really sir for your reply, i have at last upgraded my version of OJS from 3.2.1-3 to 3.3.0.3. As firstly i was getting “Upgrade failed: DB: SQLSTATE[42S22]:” error and i was attempting to upgrade it from CLI. As i was searching the forum regarding to this threat, i found a very useful post

Serious issue with Database upgrade (failed from 3.2.1.3 to 3.3.0.2) ", it helped me a lot to resolve this issue, i applied the this patch pkp/pkp-lib#6710 Unserialize journal settings depending on a value data type by Vitaliy-1 · Pull Request #6715 · pkp/pkp-lib · GitHub. from the mentioned post…

after applying the patch, i re-run the command of upgrading from my CLI Client that is Putty. and i successfully upgraded to new version.
After upgrading to 3.3.0.2 , i once again repeated the upgrading procedure as per pkp.sfu.ca instruction and also “Asmecher” helped me regarding to the upgrade process by recommending me the re-upgrading by 3.3.0.3.
And by whole one day activity at last but not least , i saw in my command line program, that…
Successfully upgraded to version 3.3.0.3.
Thanks for every one, who helped me…
Regards
Faisal