Admin-Ahead Community

Linux => Control Panels => Plesk => Topic started by: arunlalpr on December 13, 2018, 02:32:09 pm

Title: Error: Unable to update domain data: MySQL query failed: Unknown column 'syncRec
Post by: arunlalpr on December 13, 2018, 02:32:09 pm
Error: Unable to update domain data: MySQL query failed: Unknown column 'syncRecords' in 'field list'

This error is due to the missing of column "syncRecords" in the table "dns_zone" of the database "psa" which mainly occur during Plesk updates.

In order to solve the issue, we need to add the missing columns. In our case, we added " " and "syncSoa".


Kindly follow the below steps.


1) Access Mysql

MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -u admin psa

2) Access database psa.

mysql> use psa;

3) Then we need to alter the table "dns_zone"

ALTER TABLE dns_zone

ADD COLUMN syncRecords enum('true','false','skip');


ALTER TABLE dns_zone


ADD COLUMN syncSoa enum('true','false','skip');


Please try the same from your end and let us know the results :)