Knowledgebase
Plesk Windows Error Some fields are empty or contain an improper value. ('home' = '')
Posted by Premium Reseller on 15 March 2015 07:07 AM

C:\Users\Administrator>cd %plesk_dir%\Mysql\bin

C:\Program Files (x86)\Parallels\Plesk\MySQL\bin> mysql -uadmin -p -P 8306 psa
Enter password: *********

mysql> select id, name from domains where name = 'your-domain.com';

+------+-------------+
| id   | name        |
+------+-------------+
| 1164 | your-domain.com |
+------+-------------+
1 row in set (0.00 sec)

mysql> select id, object_id from Subscriptions where object_id = 1164;
+-----+-----------+
| id  | object_id |
+-----+-----------+
| 861 |      1164 |
+-----+-----------+
1 row in set (0.00 sec)

mysql> select id from ServiceInstances where servicePackageId = '861' AND serviceInstallationId = (select id from ServiceInstallations where name = 'PleskFileSystem');
+-----+
| id  |
+-----+
| 555 |
+-----+
1 row in set (0.06 sec)

mysql> select * from ServiceInstanceProperties where serviceInstanceId = 555;
Empty set (0.00 sec)

mysql> insert into ServiceInstanceProperties (`serviceInstanceId`, `name`, `value`) values (555, 'root', 'C:\\Websites\\your-domain.com');
Query OK, 1 row affected (0.17 sec)

mysql> select * from serviceinstanceproperties where serviceinstanceid = 555;
+-------------------+------+-------------------------+
| serviceInstanceId | name | value                   |
+-------------------+------+-------------------------+
|               555 | root | C:\Websites\your-domain.com |
+-------------------+------+-------------------------+
1 row in set (0.00 sec)

(1 vote(s))
This article was helpful
This article was not helpful