Article ID: 128352, created on Feb 16, 2016, last review on Feb 16, 2016

  • Applies to:
  • Plesk 12.5 for Linux


  • 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 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)


Database inconsistency.


  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,'','',0,'true','true','','master',86400,86400,10800,3600,3600,3600,604800,86400,10800,3600,'UNIXTIMESTAMP','1389108685','')
  3. Try to activate subscription.

742559b1631652fadd74764ae8be475e 56797cefb1efc9130f7c48a7d1db0f0c a914db3fdc7a53ddcfd1b2db8f5a1b9c 29d1e90fd304f01e6420fbe60f66f838 e335d9adf7edffca6a8af8039031a4c7

Email subscription for changes to this article
Save as PDF