Error: Unable to update domain data: MySQL query failed: Unknown column 'syncRec

[arunlalpr]

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