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.
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):
Hello @Senthur !
You may check the latest lines in the log/upgrade.log and upgrade_modules.log files in your UNA directory.
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.
"
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`;My website down for 4 th days now. I couldn’t fix this. UNA support taking longer.