Error: Some fields are empty or contain an improper value. ('home' = '')

Refers to:

  • Plesk 11.5 for Linux
  • Plesk 12.0 for Windows
  • Plesk 12.0 for Linux

Created:

2016-11-16 13:16:56 UTC

Modified:

2017-02-07 12:33:54 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Error: Some fields are empty or contain an improper value. ('home' = '')

Symptoms

An attempt to switch the domain hosting type from Forwarding to Physical fails with the following error:

Error: Some fields are empty or contain an improper value. ('home' = '')

Cause

Database inconsistency: the psa.ServiceInstanceProperties table does not have a record related to the affected domain.

Resolution

Perform the following steps:

  1. Create a backup of the psa database:

    # MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -u admin psa > /root/psa.`date +%F_%H.%M`.sql
  2. Find the missing record (replace domain.tld with the domain in question):

    # MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -u admin psa

    mysql> select id, name from domains where name = 'domain.tld';
    +-----+----------------+
    | id | name |
    +-----+----------------+
    | 652 | domain.tld |
    +-----+----------------+

    mysql> select id, object_id from Subscriptions where object_id = 652;
    +-----+-----------+
    | id | object_id |
    +-----+-----------+
    | 390 | 652 |
    +-----+-----------+

    mysql> select id from ServiceInstances where servicePackageId = '390' AND serviceInstallationId = (select id from ServiceInstallations where name = 'PleskFileSystem');
    +-----+
    | id |
    +-----+
    | 540 |
    +-----+

    mysql> select * from ServiceInstanceProperties where serviceInstanceId = 540;
    Empty set (0.00 sec)
  3. Insert a corresponding record to the psa.ServiceInstanceProperties table (replacing /var/www/vhosts/domain.tld with the correct www_root path):

    mysql> insert into ServiceInstanceProperties (`serviceInstanceId`, `name`, `value`) values (540, 'root', '/var/www/vhosts/domain.tld');
Have more questions? Submit a request
Please sign in to leave a comment.