Hello, I'm receiving the following error when attempting to modify anything in the Options tab for a site: Unknown column 'disable_symlinknotowner' in 'field list' It pops up if I try to save or click the options tab then click any other tab (site, redirect, ssl etc). I tried to force an update but that didn't resolve the issue. Has anyone run into this before? Thanks for your help!
It seems as if the latest SQL update has not been applied to your system. Run the following SQL queries using phpmyadmin in the dbispconfig database. Code: INSERT IGNORE INTO `dns_ssl_ca` (`id`, `sys_userid`, `sys_groupid`, `sys_perm_user`, `sys_perm_group`, `sys_perm_other`, `active`, `ca_name`, `ca_issue`, `ca_wildcard`, `ca_iodef`, `ca_critical`) VALUES (NULL, 1, 1, 'riud', 'riud', '', 'Y', 'Amazon Trust Services', 'amazontrust.com', 'Y', '', 0); -- 5374-mail-last-accessed-frontend ALTER TABLE `mail_user` ADD `last_access` int(11) NULL DEFAULT NULL after `disabledoveadm`; ALTER TABLE `web_domain` ADD `disable_symlinknotowner` enum('n','y') NOT NULL default 'n' AFTER `last_jailkit_hash`; UPDATE `web_domain` SET `backup_format_web` = 'tar_gzip' WHERE `backup_format_web` = 'rar'; UPDATE `web_domain` SET `backup_format_db` = 'zip' WHERE `backup_format_db` = 'rar';
I removed this line Code: -- 5374-mail-last-accessed-frontend ALTER TABLE `mail_user` ADD `last_access` int(11) NULL DEFAULT NULL after `disabledoveadm`; because I was receiving the following error when I ran it as is: Code: #1060 - Duplicate column name 'last_access' Here is what I ran: Code: INSERT IGNORE INTO `dns_ssl_ca` (`id`, `sys_userid`, `sys_groupid`, `sys_perm_user`, `sys_perm_group`, `sys_perm_other`, `active`, `ca_name`, `ca_issue`, `ca_wildcard`, `ca_iodef`, `ca_critical`) VALUES (NULL, 1, 1, 'riud', 'riud', '', 'Y', 'Amazon Trust Services', 'amazontrust.com', 'Y', '', 0); ALTER TABLE `web_domain` ADD `disable_symlinknotowner` enum('n','y') NOT NULL default 'n' AFTER `last_jailkit_hash`; UPDATE `web_domain` SET `backup_format_web` = 'tar_gzip' WHERE `backup_format_web` = 'rar'; UPDATE `web_domain` SET `backup_format_db` = 'zip' WHERE `backup_format_db` = 'rar'; And I received the following error when I ran it like that: Code: #1054 - Unknown column 'last_jailkit_hash' in 'web_domain'
Ok, so there must have been an update issue 10 releases ago, as the column that's missing now was added 10 releases ago. Run this: Code: ALTER TABLE `web_domain` ADD `jailkit_chroot_app_sections` mediumtext NULL DEFAULT NULL; ALTER TABLE `web_domain` ADD `jailkit_chroot_app_programs` mediumtext NULL DEFAULT NULL; ALTER TABLE `web_domain` ADD `delete_unused_jailkit` enum('n','y') NOT NULL DEFAULT 'n'; ALTER TABLE `web_domain` ADD `last_jailkit_update` date NULL DEFAULT NULL; ALTER TABLE `web_domain` ADD `last_jailkit_hash` varchar(255) DEFAULT NULL; and then run the other failed query again.
