Admin-Ahead Community
Linux => Control Panels => Plesk => Topic started 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 :)