You get different types of errors while using the Plesk control panel, but the most common error is \u201cerror on DNS page\u201d. You can solve this error with some simple steps. You get the error \u201cERROR: PleskException\u201d, when you are on Plesk. In that situation, if you make any changes within the DNS page, then you get the following Error :<\/p>\r\n\r\n\r\n\r\n
\r\nTable::select() failed: no such row in the table<\/p>\r\n<\/blockquote>\r\n\r\n\r\n\r\n
Or<\/p>\r\n\r\n\r\n\r\n
\r\nERROR: PleskException
Table::select() failed: no such row in the table
0: \/usr\/local\/psa\/admin\/plib\/dns\/DNSZone.php:52
DNSZone->DNSZone(string \u2018100\u2032)
1: \/usr\/local\/psa\/admin\/plib\/common_func.php3:2610
objectMaker(string \u2018DNSZone\u2019, string \u2018100\u2032)
2: \/usr\/local\/psa\/admin\/plib\/dns\/DNSManager.php:39
DNSManager::getDNSZone(string \u2018100\u2032)
3: \/usr\/local\/psa\/admin\/htdocs\/domains\/dns.php:21<\/p>\r\n<\/blockquote>\r\n\r\n\r\n\r\nThe cause of the error is that in psa.domains Plesk mysql table dns_zone_id record points to nonexistent id record in psa.dns_zone table for one or different domains. It may occur because of Plesk internal problems, a broken database, or incomplete domain deletion.<\/p>\r\n\r\n\r\n\r\n
The users have to login into MySQL server console to make some important changes.<\/p>\r\n\r\n\r\n\r\n
\r\n# mysql -uadmin -p`cat \/etc\/psa\/.psa.shadow` -Dpsa<\/p>\r\n<\/blockquote>\r\n\r\n\r\n\r\n
and discover domains that have missed ID:<\/p>\r\n\r\n\r\n\r\n
\r\nmysql> SELECT d.name FROM domains d LEFT JOIN dns_zone z ON d.dns_zone_id=z.id WHERE z.id IS NULL;<\/p>\r\n<\/blockquote>\r\n\r\n\r\n\r\n
For every reported domain, ensure the following procedure :
The user has to create an appropriate id within the records with the commands mentioned below. Make a note that you will have to replace \u2018Domain Name<\/a>\u2019 with the actual domain URL and you will also have to change the admin email with the correct email.<\/p>\r\n\r\n\r\n\r\n\r\n
- The users have to make proper id records with the following commands. You have to keep in mind to replace \u201cDOMAIN-NAME\u201d with an original domain name and also \u201cADMIN-EMAIL\u201d with the correct email:\r\n
mysql> INSERT INTO dns_zone SET name=\u2019DOMAIN-NAME\u2019, displayName=\u2019DOMAIN-NAME\u2019, email=\u2019ADMIN-EMAIL\u2019;<\/blockquote>\r\n<\/li>\r\n- Way to find out new zone ID:\r\n
mysql> SELECT id, name FROM dns_zone ORDER BY id DESC LIMIT 1;<\/blockquote>\r\n<\/li>\r\n- Substitute the correct ID into psa.domains table. You have to keep in mind to replace \u201cDOMAIN-ID\u201d and also \u201cDOMAIN-NAME\u201d with the correct values:\r\n
mysql> UPDATE domains SET dns_zone_id=\u2019DOMAIN-ID\u2019 WHERE name=\u2019DOMAIN-NAME\u2019;<\/blockquote>\r\n<\/li>\r\n<\/ol>\r\n\r\n\r\n\r\n<\/blockquote>\r\n\r\n\r\n\r\n\r\n\r\n<\/blockquote>\r\n\r\n\r\n\r\n\r\n\r\n<\/blockquote>\r\n\r\n\r\n\r\nAfter that you have to login into Plesk, for each corrected domain go to domain.com > DNS and utilize the Default option to re-generate DNS records. It would have solved the error in Plesk.<\/p>\r\n","protected":false},"excerpt":{"rendered":"
You get different types of errors while using the Plesk control panel, but the most common error is \u201cerror on DNS page\u201d. You can solve this error with some simple…<\/p>\n