Solution for syncDNSZoneAdminEmail problem

[toneworks]

I had the following error when I tried to change the Admin email address, but I such error may also occur in other situations. When your error report contains 'DNSManager::syncDNSZoneAdminEmail' this might be the solution.

My complete error report:

0: /usr/local/psa/admin/plib/dns/DNSZone.php:49
DNSZone->DNSZone(string '1')
1: /usr/local/psa/admin/plib/common_func.php3:2875
objectMaker(string 'DNSZone', string '1')
2: /usr/local/psa/admin/plib/dns/DNSManager.php:39
DNSManager::getDNSZone(string '1')
3: /usr/local/psa/admin/plib/dns/DNSManager.php:75
DNSManager::getDefaultDNSZone()
4: /usr/local/psa/admin/plib/dns/DNSManager.php:104
DNSManager::syncDNSZoneAdminEmail(string '[email protected]', string '[email protected]')
5: /usr/local/psa/admin/htdocs/server/admin_ed.php3:88
admin_ed(array, array, array)
6: /usr/local/psa/admin/htdocs/server/admin_ed.php3:171

Solution: Log in as root, execute:

mysql -uadmin -p`cat /etc/psa/.psa.shadow` -Dpsa

In MySQL execute the following command:

INSERT INTO `dns_zone` (`id`, `name`, `displayName`, `status`, `email`, `type`, `ttl`, `ttl_unit`, `refresh`, `refresh_unit`, `retry`, `retry_unit`, `expire`, `expire_unit`, `minimum`, `minimum_unit`) VALUES (1, 'yourserver.domain.com', 'yourserver.domain.com', 1, '[email protected]', 'master', 86400, 1, 10800, 1, 3600, 1, 604800, 1, 10800, 1);

Explanation: I remembered that I did remove an entry from the dns_zone table because some dns record I didn't want kept showing up. The above SQL creates the entry Plesk inserts standard in the dns_zone table, but with status=1 which means 'disabled'.

 

[tiramisu_]

it is highly not recommended to remove any records from Plesk database, especially columns, they may use in different queries, and such errors occurs