can not create and update subdomains after update to 9.5.4

[Maic2410]

hi, after the update to version 9.5.4 i became following errormassage, when i want update and create a subdomain.

MySQL query failed: Unknown column 'sys_user_type' in 'field list'

0: common_func.php3:206
db_query(string 'select `id`,`dom_id`,`name`,`displayName`,`sys_user_type`,`sys_user_id`,`ssl`,`same_ssl`,`ssi`,`cgi`,`php_handler_type`,`asp`,`php`,`perl`,`python`,`fastcgi`,`miva`,`coldfusion` from subdomains where `id`=38')
1: class.Table.php:183
Table->select()
2: class.cObject.php:479
cObject->fetchAttrsFromTable_()
3: class.SubDomain.php:36
SubDomain->SubDomain(integer '38')
4: common_func.php3:3148
objectMaker(string 'SubDomain', integer '38')
5: class.SubDomainManager.php:350
SubDomainManager->getSubDomain(integer '38')
6: class.SubDomainManager.php:30
SubDomainManager->SubDomainManager(integer '66', integer '38')
7: subdom_edit.php:29

has anybody an idea? Im frustratet. Please give me a help. Thanks - sorry for my bad english.

Greetings, Andreas

 

[IgorG]

It looks like plesk database was not correctly upgraded. There is missing field in table 'subdomains'. It should be like:

mysql> show create table subdomains\G
*************************** 1. row ***************************
Table: subdomains
Create Table: CREATE TABLE `subdomains` (
`id` int(10) unsigned NOT NULL auto_increment,
`dom_id` int(10) unsigned NOT NULL,
`name` varchar(255) character set ascii NOT NULL,
`displayName` varchar(255) character set utf8 NOT NULL,
`sys_user_type` enum('main','native') NOT NULL default 'main',
`sys_user_id` int(10) unsigned NOT NULL,
`ssi` enum('false','true') NOT NULL default 'false',
`php` enum('false','true') NOT NULL default 'false',
`cgi` enum('false','true') NOT NULL default 'false',
`perl` enum('false','true') NOT NULL default 'false',
`python` enum('false','true') NOT NULL default 'false',
`fastcgi` enum('false','true') NOT NULL default 'false',
`miva` enum('false','true') NOT NULL default 'false',
`coldfusion` enum('false','true') NOT NULL default 'false',
`asp` enum('false','true') NOT NULL default 'false',
`asp_dot_net` enum('false','true') NOT NULL default 'false',
`ssl` enum('false','true') NOT NULL default 'false',
`same_ssl` enum('false','true') NOT NULL default 'false',
`php_handler_type` enum('cgi','fastcgi','module') NOT NULL default 'module',
PRIMARY KEY (`id`),
UNIQUE KEY `dom_id` (`dom_id`,`name`),
KEY `dom_id_displayName` (`dom_id`,`displayName`),
KEY `sys_user_id` (`sys_user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1
1 row in set (0.00 sec)