Get your server issues fixed by our experts for a price starting at just 25 USD/Hour. Click here to register and open a ticket with us now!

Author Topic: Error: Unable to update domain data: MySQL query failed: Unknown column 'syncRec  (Read 9202 times)

0 Members and 1 Guest are viewing this topic.

arunlalpr

  • Newbie
  • *
  • Posts: 14
  • Karma: +0/-0
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 :)