Linux > Plesk
Error: Unable to update domain data: MySQL query failed: Unknown column 'syncRec
(1/1)
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 :)
Navigation
[0] Message Index
Go to full version