Cannot enable subscription: Unable to load object of type PhDomain ('dns_zone_id' = '0')

Refers to:

  • Plesk 12.5 for Linux
  • Plesk 12.5 for Windows

Created:

2016-11-16 13:05:51 UTC

Modified:

2016-12-21 19:56:48 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Cannot enable subscription: Unable to load object of type PhDomain ('dns_zone_id' = '0')

Symptoms

  • It is not possible to activate reseller, customer or just subscription, activation fails with error:

    Error: Some of the selected resellers were not activated.
    Unable to load object of type PhDomain with id=43: Unable to update domain data: Domain::update failed: Some fields are empty or contain an improper value. ('dns_zone_id' = '0')
  • Domain example.com with id 43 does not have corresponding record in dns_zone table:

    Checking for dns_zone id:

    mysql> select dns_zone_id from domains where id=43;
    +-------------+
    | dns_zone_id |
    +-------------+
    | 18 |
    +-------------+

    Checking if we have such record:

    mysql> select * from dns_zone where id=18;
    Empty set (0.00 sec)

Cause

Database inconsistency.

Resolution

  1. Backup Plesk databases before any changes:

    mysqldump -uadmin -p`cat /etc/psa/.psa.shadow ` psa > ~/psa_`date +%F_%H.%M`.sql
  2. Access to Plesk database and add dns_zone for domain in dns_zone table:

    mysql> INSERT INTO `dns_zone` VALUES (18,'example.com','example.com',0,'true','true','fake@example.com','master',86400,86400,10800,3600,3600,3600,604800,86400,10800,3600,'UNIXTIMESTAMP','1389108685','')
  3. Try to activate subscription.

Have more questions? Submit a request
Please sign in to leave a comment.