Upgrade Error from OJS 3.2.1-4 to 3.3.0-11

Software Support
,
1

i did upgrade my ojs to version 3.3.0-11 from 3.2.1-4. and i face error like this :

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’ve done a few things before, such as:

  1. change database engine to InnoDB;
  2. change database collation to utf8_general_ci:
  3. restore my database twice and reupgrade it again;
  4. ensure config.inc.php is correct

Additional information
this is my error log:

[Sun Aug 07 04:59:15.250891 2022] [negotiation:error] [pid 30540] [client 103.147.9.45:18152] AH00687: Negotiation: discovered file(s) matching request: /var/www/html/join/index (None could be negotiated).

[Sun Aug 07 04:59:15.356377 2022] [negotiation:error] [pid 30540] [client 103.147.9.45:18152] AH00687: Negotiation: discovered file(s) matching request: /var/www/html/join/index (None could be negotiated)., referer: http://mysite/index.php/index/install

[Sun Aug 07 04:59:17.350327 2022] [negotiation:error] [pid 30543] [client 103.147.9.45:1384] AH00687: Negotiation: discovered file(s) matching request: /var/www/html/join/index (None could be negotiated)., referer: http://mysite/index.php/index/install

[Sun Aug 07 04:59:18.798558 2022] [negotiation:error] [pid 30543] [client 103.147.9.45:1384] AH00687: Negotiation: discovered file(s) matching request: /var/www/html/join/index (None could be negotiated)., referer: http://mysite/index.php/index/install/upgrade

[Sun Aug 07 04:59:18.840032 2022] [php7:notice] [pid 30543] [client 103.147.9.45:1384] PHP Notice: unserialize(): Error at offset 88 of 1072 bytes in /var/www/html/join/lib/pkp/classes/db/DAO.inc.php on line 252, referer: http://mysite/index.php/index/install/upgrade

[Sun Aug 07 04:59:18.841093 2022] [php7:notice] [pid 30543] [client 103.147.9.45:1384] WARNING: The NavigationMenu (ContextId: 1, Title: User Navigation Menu, Area: user) will be skipped because the specified area has already a NavigationMenu attached., referer: http://mysite/index.php/index/install/upgrade

[Sun Aug 07 04:59:18.841537 2022] [php7:notice] [pid 30543] [client 103.147.9.45:1384] WARNING: The NavigationMenu (ContextId: 1, Title: Primary Navigation Menu, Area: primary) will be skipped because the specified area has already a NavigationMenu attached., referer: http://mysite/index.php/index/install/upgrade

[Sun Aug 07 04:59:18.845614 2022] [php7:notice] [pid 30543] [client 103.147.9.45:1384] WARNING: The NavigationMenu (ContextId: 0, Title: User Navigation Menu, Area: user) will be skipped because the specified area has already a NavigationMenu attached., referer: http://mysite/index.php/index/install/upgrade

[Sun Aug 07 04:59:18.853500 2022] [php7:notice] [pid 30543] [client 103.147.9.45:1384] PHP Notice: unserialize(): Error at offset 88 of 1072 bytes in /var/www/html/join/lib/pkp/classes/db/DAO.inc.php on line 252, referer: http://mysite/index.php/index/install/upgrade

[Sun Aug 07 04:59:19.097764 2022] [php7:notice] [pid 30543] [client 103.147.9.45:1384] PHP Notice: unserialize(): Error at offset 88 of 1072 bytes in /var/www/html/join/lib/pkp/classes/db/DAO.inc.php on line 252, referer: http://mysite/index.php/index/install/upgrade

[Sun Aug 07 04:59:19.098516 2022] [php7:notice] [pid 30543] [client 103.147.9.45:1384] 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), referer: http://mysite/index.php/index/install/upgrade

2

Hi @Bagus_Enggartiasto

I think this previous thread may have the solution to this issue you have reported:

Best,
Israel