Hi, I’m trying to upgrade from 3.2.1.1 to 3.3.0.11. For that, I followed the video tutorial Upgrading to OJS 3 - YouTube
When I run the upgrade script some warnings and a error are shown. Next I paste the terminal messages.
root@averma:/website/default/site/public_html# php tools/upgrade.php check
Code version: 3.3.0.11
Database version: 3.2.1.1
Latest version: 3.3.0.11
Database version is older than code version
Run “tools/upgrade.php upgrade” to update
root@averma:/website/default/site/public_html# php tools/upgrade.php upgrade
2022-07-13 19:28:37 [pre-install]
2022-07-13 19:28:37 [load: upgrade.xml]
2022-07-13 19:28:37 [version: 3.3.0.11]
2022-07-13 19:28:37 [code: Installer Installer::checkPhpVersion]
2022-07-13 19:28:37 [code: Installer Installer::installDefaultNavigationMenus]
WARNING: The NavigationMenu (ContextId: 1, Title: User Navigation Menu, Area: user) will be skipped because the specified area has already a NavigationMenu attached.
WARNING: The NavigationMenu (ContextId: 1, Title: Primary Navigation Menu, Area: primary) will be skipped because the specified area has already a NavigationMenu attached.
WARNING: The NavigationMenu (ContextId: 0, Title: User Navigation Menu, Area: user) will be skipped because the specified area has already a NavigationMenu attached.
2022-07-13 19:28:37 [code: Installer Installer::migrateStaticPagesToNavigationMenuItems]
2022-07-13 19:28:37 [migration: PKPv3_3_0UpgradeMigration]
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)
I don´t know how to workaround. Any suggestion are welcome.
Do I have upgrade to intermediate versions?
Thanks in advance
That is the errors from my 2nd shot. My 1st upgrade script run had problems related to permissions. So, in my 2nd. try using sudo. Next, the 1st. error messages obtained.
php tools/upgrade.php upgrade
PHP Warning: file_put_contents(/website/default/site/public_html/cache/fc-pluginSettings-0-staticpagesplugin.php): failed to open stream: Permission denied in /website/default/site/public_html/lib/pkp/classes/cache/FileCache.inc.php on line 90
PHP Warning: file_put_contents(/website/default/site/public_html/cache/fc-pluginSettings-0-htmlarticlegalleyplugin.php): failed to open stream: Permission denied in /website/default/site/public_html/lib/pkp/classes/cache/FileCache.inc.php on line 90
PHP Warning: file_put_contents(/website/default/site/public_html/cache/fc-pluginSettings-0-driverplugin.php): failed to open stream: Permission denied in /website/default/site/public_html/lib/pkp/classes/cache/FileCache.inc.php on line 90
PHP Warning: file_put_contents(/website/default/site/public_html/cache/fc-pluginSettings-0-announcementfeedplugin.php): failed to open stream: Permission denied in /website/default/site/public_html/lib/pkp/classes/cache/FileCache.inc.php on line 90
PHP Warning: file_put_contents(/website/default/site/public_html/cache/fc-pluginSettings-0-dublincoremetaplugin.php): failed to open stream: Permission denied in /website/default/site/public_html/lib/pkp/classes/cache/FileCache.inc.php on line 90
PHP Warning: file_put_contents(/website/default/site/public_html/cache/fc-pluginSettings-0-webfeedplugin.php): failed to open stream: Permission denied in /website/default/site/public_html/lib/pkp/classes/cache/FileCache.inc.php on line 90
PHP Warning: file_put_contents(/website/default/site/public_html/cache/fc-pluginSettings-0-lensgalleyplugin.php): failed to open stream: Permission denied in /website/default/site/public_html/lib/pkp/classes/cache/FileCache.inc.php on line 90
PHP Warning: file_put_contents(/website/default/site/public_html/cache/fc-pluginSettings-0-googlescholarplugin.php): failed to open stream: Permission denied in /website/default/site/public_html/lib/pkp/classes/cache/FileCache.inc.php on line 90
PHP Warning: file_put_contents(/website/default/site/public_html/cache/fc-pluginSettings-0-pdfjsviewerplugin.php): failed to open stream: Permission denied in /website/default/site/public_html/lib/pkp/classes/cache/FileCache.inc.php on line 90
PHP Warning: file_put_contents(/website/default/site/public_html/cache/fc-pluginSettings-0-staticpagesplugin.php): failed to open stream: Permission denied in /website/default/site/public_html/lib/pkp/classes/cache/FileCache.inc.php on line 90
PHP Warning: file_put_contents(/website/default/site/public_html/cache/fc-pluginSettings-0-htmlarticlegalleyplugin.php): failed to open stream: Permission denied in /website/default/site/public_html/lib/pkp/classes/cache/FileCache.inc.php on line 90
PHP Warning: file_put_contents(/website/default/site/public_html/cache/fc-pluginSettings-0-driverplugin.php): failed to open stream: Permission denied in /website/default/site/public_html/lib/pkp/classes/cache/FileCache.inc.php on line 90
PHP Warning: file_put_contents(/website/default/site/public_html/cache/fc-pluginSettings-0-announcementfeedplugin.php): failed to open stream: Permission denied in /website/default/site/public_html/lib/pkp/classes/cache/FileCache.inc.php on line 90
PHP Warning: file_put_contents(/website/default/site/public_html/cache/fc-pluginSettings-0-dublincoremetaplugin.php): failed to open stream: Permission denied in /website/default/site/public_html/lib/pkp/classes/cache/FileCache.inc.php on line 90
PHP Warning: file_put_contents(/website/default/site/public_html/cache/fc-pluginSettings-0-webfeedplugin.php): failed to open stream: Permission denied in /website/default/site/public_html/lib/pkp/classes/cache/FileCache.inc.php on line 90
PHP Warning: file_put_contents(/website/default/site/public_html/cache/fc-pluginSettings-0-lensgalleyplugin.php): failed to open stream: Permission denied in /website/default/site/public_html/lib/pkp/classes/cache/FileCache.inc.php on line 90
PHP Warning: file_put_contents(/website/default/site/public_html/cache/fc-pluginSettings-0-googlescholarplugin.php): failed to open stream: Permission denied in /website/default/site/public_html/lib/pkp/classes/cache/FileCache.inc.php on line 90
PHP Warning: file_put_contents(/website/default/site/public_html/cache/fc-pluginSettings-0-pdfjsviewerplugin.php): failed to open stream: Permission denied in /website/default/site/public_html/lib/pkp/classes/cache/FileCache.inc.php on line 90
PHP Warning: file_put_contents(/website/default/site/public_html/cache/fc-pluginSettings-0-urnpubidplugin.php): failed to open stream: Permission denied in /website/default/site/public_html/lib/pkp/classes/cache/FileCache.inc.php on line 90
PHP Warning: file_put_contents(/website/default/site/public_html/cache/fc-pluginSettings-0-doipubidplugin.php): failed to open stream: Permission denied in /website/default/site/public_html/lib/pkp/classes/cache/FileCache.inc.php on line 90
2022-07-13 19:14:23 [pre-install]
2022-07-13 19:14:23 [load: upgrade.xml]
2022-07-13 19:14:23 [version: 3.3.0.11]
2022-07-13 19:14:23 [code: Installer Installer::checkPhpVersion]
2022-07-13 19:14:23 [code: Installer Installer::installDefaultNavigationMenus]
WARNING: The NavigationMenu (ContextId: 1, Title: User Navigation Menu, Area: user) will be skipped because the specified area has already a NavigationMenu attached.
WARNING: The NavigationMenu (ContextId: 1, Title: Primary Navigation Menu, Area: primary) will be skipped because the specified area has already a NavigationMenu attached.
WARNING: The NavigationMenu (ContextId: 0, Title: User Navigation Menu, Area: user) will be skipped because the specified area has already a NavigationMenu attached.
2022-07-13 19:14:23 [code: Installer Installer::migrateStaticPagesToNavigationMenuItems]
2022-07-13 19:14:23 [migration: PKPv3_3_0UpgradeMigration]
Hi @mauritroviano
Did you already try an upgrade at some point before, and have it fail? Each time an upgrade attempt fails you need to restore the database from backup. This message sounds like a previous attempt was made that also failed, and then you tried again.
Best
Jason
Hi, thanks for your help.
I’m just solve the problem. Apparently it was a database format problem. So, I solve the problem with the next sequence.
mysql> DROP DATABASE yourDB;
mysql> CREATE DATABASE yourDB CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
mysql> GRANT ALL PRIVILEGES ON yourDB.* TO 'user'@'localhost' IDENTIFIED BY 'yourpassword';
mysql -u yourDB -p user < yourDB-bak.sql
After that I followed the upgrade process and it was successful.