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):
I am running into problems as well, clicked update to 14 and it says, it updates it in a minute... cronjob is running, no upgrade.log or anything in logs. Any idea?
Edit: Three hours later now it claims it has been updated but still runs 13.1.0
To continue your upgrade, you need to choose the "beta" value of the Update channel field in the Studio->Developer area (the Developer app can be installed for free) and save changes. The Upgrade button will appear, press it and upgrade the core and all installed modules step by step. As usual - backup your UNA files and database before the upgrade start. Requested your UNA studio details too because it's enough to have the stable upgrade channel between 13.1 and 14.
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.
T
I am running into problems as well, clicked update to 14 and it says, it updates it in a minute... cronjob is running, no upgrade.log or anything in logs. Any idea?
Edit: Three hours later now it claims it has been updated but still runs 13.1.0
Hello @trunky !
To continue your upgrade, you need to choose the "beta" value of the Update channel field in the Studio->Developer area (the Developer app can be installed for free) and save changes. The Upgrade button will appear, press it and upgrade the core and all installed modules step by step. As usual - backup your UNA files and database before the upgrade start. Requested your UNA studio details too because it's enough to have the stable upgrade channel between 13.1 and 14.
T
Hello @LeonidS , thank you for the answer. May I ask why beta? I understand Una 14 is stable?