An attempt to manage domain DNS settings fails: 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 '))'

Created:

2016-11-16 12:42:14 UTC

Modified:

2017-08-16 16:14:38 UTC

0

Was this article helpful?


Have more questions?

Submit a request

An attempt to manage domain DNS settings fails: 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 '))'

Applicable to:

  • Plesk 11.x for Windows
  • Plesk 12.0 for Windows
  • Plesk 12.0 for Linux
  • Plesk 12.5 for Windows

Symptoms

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[42000]: 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

Resolution

Run the following command to re-generate DNS records:

"%plesk_cli%\\dns.exe" --reset <DOMAIN-NAME> -ip <IP_address>

Example:

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.
Have more questions? Submit a request
Please sign in to leave a comment.