Comment to 'I need help to upgrade to 14.0.0'

Comment to I need help to upgrade to 14.0.0

· Senthur

· 2025-05-28T05:50:15+0000
so this is have in upgrade.modules. below
"08-23 16:20:45:Operation failed:
Memorials: Changing database: There are errors in the following MySQL queries:<br />Error: Unknown column 'collapsed' in 'field list'<br /><pre>UPDATE `sys_menu_items` SET `collapsed`='0' WHERE `set_name`='sys_profile_followings' AND `name`='memorials';</pre>
03-11 15:45:01:
Cannot get a list of modules which require to be updated.
03-11 16:15:02:
Cannot get a list of modules which require to be updated.
How to fix this problem. Can you please me to fix this. my site is down 2 days now. I am losing my visitors everyday for this.
"
- · LeonidS
  
  · In reply to
  
  Senthur
  
  · 2025-05-28T08:20:05+0000
  By default, UNA had the `collapsed` field in this table since 13.0 version. It seems it hasn't been added before. So now you need to run the following query in your UNA database (backup the `sys_menu_items` table first):
  ALTER TABLE `sys_menu_items` ADD COLUMN `collapsed` tinyint(4) NOT NULL DEFAULT '0' AFTER `primary`;