• Plesk Uservoice will be deprecated by October. Moving forward, all product feature requests and improvement suggestions will be managed through our new platform Plesk Productboard.
    To continue sharing your ideas and feedback, please visit features.plesk.com

can not create and update subdomains after update to 9.5.4

M

Maic2410

Guest
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
 
Last edited by a moderator:
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)
 
Back
Top