M
M_From_H
Guest
After upgrading from Plesk 8.4 to Plesk 9.3 (on openSUSE 10.0), I am not able to add domain aliases anymore. When I try to do so, the error message mentioned above occurs. Adding domains is no problem.
I turned on MySQL-logging and found
I turned on MySQL-logging and found
100303 9:13:31 11 Connect admin@localhost on
11 Init DB psa
11 Query SHOW VARIABLES LIKE 'version'
11 Query select param, val from misc
11 Query SET NAMES utf8
11 Init DB psa
11 Query SHOW VARIABLES LIKE 'version'
11 Query SET NAMES utf8
11 Query SHOW VARIABLES LIKE 'version'
11 Query SELECT * FROM misc
WHERE param = 'mysql41_compatible'
AND val <> RTRIM(TRIM('\0' FROM val))
11 Query set foreign_key_checks=0
11 Query SELECT login, type, ip_address FROM sessions WHERE sess_id="9677c5e09b8320a7645c1b0467ec531a"
11 Query select * from sessions where sess_id="9677c5e09b8320a7645c1b0467ec531a" and click_time >= NOW() - INTERVAL 1800 SECOND
11 Query update sessions set click_time=NOW() where sess_id='9677c5e09b8320a7645c1b0467ec531a'
11 Query select `id`,`name`,`displayName`,`cr_date`,`status`,`dns_zone_id`,`htype`,`cl_id`,`limits_id`,`params_id`,`cert_rep_id`,`real_size`,`guid`,`overuse` from domains where `id`=3
11 Query SELECT * FROM clients WHERE type = 'admin'
11 Query SELECT `sb_client_login`, `sb_reseller_id` FROM `SBResellers` WHERE `client_id` =1
11 Query select `id`,`name`,`place` from Skins where `id`=18
11 Query SELECT `key`, `uid` FROM PersistentCache WHERE `expire` < '2010-03-03 09:13:31'
11 Query select `id`,`limit_name`,`value` from Limits where `id`=2
11 Query SELECT `param`, `val` FROM dom_param WHERE dom_id = 3
11 Query select `id`,`parent_id`,`type`,`cr_date`,`cname`,`pname`,`login`,`account_id`,`status`,`phone`,`fax`,`email`,`address`,`city`,`state`,`pcode`,`country`,`locale`,`limits_id`,`params_id`,`perm_id`,`pool_id`,`logo_id`,`tmpl_id`,`sapp_pool_id`,`guid`,`overuse` from clients where `id`=3
11 Query SELECT `sb_client_login`, `sb_reseller_id` FROM `SBResellers` WHERE `client_id` =3
11 Query select `id`,`type`,`password` from accounts where `id`=2
11 Query SELECT `param`, `val` FROM cl_param WHERE cl_id = 3
11 Query SELECT `param`, `val` FROM cl_param WHERE cl_id = 1
11 Query select id as `id`, displayName as `name`, cl_id as `parent_id` from domains where id in (3)
11 Query select id as `id`, displayName as `name`, cl_id as `parent_id` from domains where id in (3)
11 Query select id as `id`, login as `name`, NULL as `parent_id` from clients where id in (3)
11 Query select `id`,`name`,`type`,`uri` from DashboardPreset where `id`=5
11 Query SELECT `id`, `ord`, `uri`, `parent_id`, `enabled`, `type`, `title`, `description` FROM `DashboardPresetConfig` WHERE `preset_id`=5 ORDER BY `parent_id`, `ord` DESC
11 Query SELECT COUNT(*) AS n FROM PersistentCache WHERE `key` = 'plesk/client@3/domain@3/domain-alias@new/properties-domains#formPageCache' AND `uid` = '1-0'
11 Query select count(*) from DashboardPresetConfig where id=439
11 Query update DashboardPresetConfig SET `preset_id`=5, `ord`=119, `uri`="/plesk/client@3/domain@3/domain-alias@new/properties/", `parent_id`=419, `enabled`="true", `type`="shortcut", `title`= "Neuen Domain-Alias für mydomain.tld erstellen", `description`= "Neuen Domain-Alias für Domain mydomain.tld erstellen" where `id`=439
11 Quit
100303 9:13:32 12 Connect admin@localhost on
12 Init DB psa
12 Query SHOW VARIABLES LIKE 'version'
12 Query select param, val from misc
12 Query SET NAMES utf8
12 Init DB psa
12 Query SHOW VARIABLES LIKE 'version'
12 Query SET NAMES utf8
12 Query SHOW VARIABLES LIKE 'version'
12 Query SELECT * FROM misc
WHERE param = 'mysql41_compatible'
AND val <> RTRIM(TRIM('\0' FROM val))
12 Query set foreign_key_checks=0
12 Query select `id`,`name`,`place` from Skins where `id`=18
12 Quit
100303 9:13:56 13 Connect admin@localhost on
13 Init DB psa
13 Query SHOW VARIABLES LIKE 'version'
13 Query select param, val from misc
13 Query SET NAMES utf8
13 Init DB psa
13 Query SHOW VARIABLES LIKE 'version'
13 Query SET NAMES utf8
13 Query SHOW VARIABLES LIKE 'version'
13 Query SELECT * FROM misc
WHERE param = 'mysql41_compatible'
AND val <> RTRIM(TRIM('\0' FROM val))
13 Query set foreign_key_checks=0
13 Query SELECT login, type, ip_address FROM sessions WHERE sess_id="9677c5e09b8320a7645c1b0467ec531a"
13 Query select * from sessions where sess_id="9677c5e09b8320a7645c1b0467ec531a" and click_time >= NOW() - INTERVAL 1800 SECOND
13 Query update sessions set click_time=NOW() where sess_id='9677c5e09b8320a7645c1b0467ec531a'
13 Query select `id`,`name`,`displayName`,`cr_date`,`status`,`dns_zone_id`,`htype`,`cl_id`,`limits_id`,`params_id`,`cert_rep_id`,`real_size`,`guid`,`overuse` from domains where `id`=3
13 Query SELECT * FROM clients WHERE type = 'admin'
13 Query SELECT `sb_client_login`, `sb_reseller_id` FROM `SBResellers` WHERE `client_id` =1
13 Query select `id`,`name`,`place` from Skins where `id`=18
13 Query SELECT `key`, `uid` FROM PersistentCache WHERE `expire` < '2010-03-03 09:13:56'
13 Query SELECT `key`, `uid` FROM PersistentCache WHERE `events` LIKE '%ui_update%'
13 Query DELETE FROM PersistentCache WHERE `events` LIKE '%ui_update%'
13 Query select `id`,`limit_name`,`value` from Limits where `id`=2
13 Query SELECT `param`, `val` FROM dom_param WHERE dom_id = 3
13 Query select `id`,`parent_id`,`type`,`cr_date`,`cname`,`pname`,`login`,`account_id`,`status`,`phone`,`fax`,`email`,`address`,`city`,`state`,`pcode`,`country`,`locale`,`limits_id`,`params_id`,`perm_id`,`pool_id`,`logo_id`,`tmpl_id`,`sapp_pool_id`,`guid`,`overuse` from clients where `id`=3
13 Query SELECT `sb_client_login`, `sb_reseller_id` FROM `SBResellers` WHERE `client_id` =3
13 Query select `id`,`type`,`password` from accounts where `id`=2
13 Query SELECT `param`, `val` FROM cl_param WHERE cl_id = 3
13 Query SELECT `param`, `val` FROM cl_param WHERE cl_id = 1
13 Query SELECT count(*) FROM domainaliases WHERE name ="newalias.tld" AND id !="0"
13 Query SELECT id FROM domains WHERE name = "newalias.tld"
13 Query SELECT count(*) FROM subdomains sd, domains d WHERE d.id = sd.dom_id AND CONCAT(sd.name, ".", d.name)="newalias.tld" AND sd.id !="0"
13 Query SELECT COUNT(*) FROM dns_recs WHERE type in ("CNAME", "A", "MX", "NS", "TXT") AND host="newalias.tld."
13 Query SELECT id, name, descr, enabled FROM actions
13 Query select `id`,`name`,`displayName`,`email`,`status`,`type`,`ttl`,`ttl_unit`,`refresh`,`refresh_unit`,`retry`,`retry_unit`,`expire`,`expire_unit`,`minimum`,`minimum_unit`,`serial`,`serial_format` from dns_zone where `id`=4
13 Query SELECT id FROM dns_recs WHERE dns_zone_id="0"
13 Query SELECT id FROM dns_recs WHERE dns_zone_id="4"
13 Query select `id`,`dns_zone_id`,`type`,`displayHost`,`host`,`displayVal`,`val`,`opt`,`time_stamp` from dns_recs where `id`=477
... same line for ~180 other subdomains ...
For rest of posting see Part #2 ...