An attempt to open or edit DNS settings fails, the following page is displayed:
Operation failed The operation you were performing failed. You can retry the operation with or without changing its parameters. You may also want to report this problem to our support so that we could help you as soon as possible.
The following error is shown upon clicking on the 'Show details' tab:
SQLSTATE: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '))' at line 1 ---------------------- Debug Info ------------------------------- 0: Pdo.php:234 Zend_Db_Statement_Pdo->_execute(array) 1: Statement.php:300 Zend_Db_Statement->execute(array) 2: Abstract.php:479 Zend_Db_Adapter_Abstract->query(object of type Zend_Db_Table_Select, array) 3: Abstract.php:238 Zend_Db_Adapter_Pdo_Abstract->query(object of type Zend_Db_Table_Select, array) 4: Mysql.php:24 Db_Adapter_Pdo_Mysql->query(object of type Zend_Db_Table_Select) 5: Abstract.php:1534 Zend_Db_Table_Abstract->_fetch(object of type Zend_Db_Table_Select) 6: Abstract.php:1349 Zend_Db_Table_Abstract->fetchAll(object of type Zend_Db_Table_Select) 7: ApsResources.php:52 Db_Table_Broker_ApsResources->getLinkedIds(string 'dns-record', array) 8: DNSZoneList.php:111 DNSZoneList->loadRecords(array) 9: DNSZoneList.php:123 DNSZoneList->fetchDNSZoneList() 10: cList.php:91 cList->fetchList() 11: cList.php:110 cList->init() 12: DNSUIPointer.php:73 DNSUIPointer->accessItem(string 'GET', NULL null) 13: UIPointer.php:600 UIPointer->access(string 'GET') 14: plesk.php:50
Run the following command to re-generate DNS records:
"%plesk_cli%\dns.exe" --reset <DOMAIN-NAME> -ip <IP_address>
C:\> "%plesk_cli%\dns.exe" --reset example.com -ip 10.39.39.39 SUCCESS: Restoring the DNS zone by the template for Domain 'example.com' complete.