Creating a new subscription problem

[EustasioJ]

I upgrade to version 10.4.4 from 10.3.4 version. After that when i try to create a new subscription i get the next error:

MySQL query failed: Unknown column 'syncRecords' in 'field list'

I need to fix this problem urgently. What can i do to resolv this?

 

[IgorG]

Looks like uncompleted upgrade. Fix it with bootstrapper repair procedure (described in KB).

 

[EustasioJ]

I've applied bootstrapper and got the same error.

Error: Unable to update domain data: MySQL query failed: Unknown column 'syncRecords' in 'field list'

When creating new subscription. I need to create new subscriptions for my clients, any sugestion to fix the issue?

 

[EustasioJ]

Please, i need a solution soon!

 

[EustasioJ]

Now i've seen that when i try to view dns entries in a control panel i get this error:

ERROR: PleskMainDBException
MySQL query failed: Unknown column 'syncRecords' in 'field list'

Additionally, an exception has occurred while trying to report this error: PleskMainDBException
MySQL query failed: Unknown column 'syncRecords' in 'field list'

0: common_func.php3:211
db_query(string 'select `id`,`name`,`displayName`,`email`,`status`,`syncRecords`,`syncSoa`,`type`,`ttl`,`ttl_unit`,`refresh`,`refresh_unit`,`retry`,`retry_unit`,`expire`,`expire_unit`,`minimum`,`minimum_unit`,`serial`,`serial_format` from dns_zone where `id`=35')
1: Table.php:154
Table->select()
2: DNSZone.php:70
DNSZone->DNSZone(string '35')
3: common_func.php3:3284
objectMaker(string 'DNSZone', string '35')
4: DNSManager.php:29
DNSManager::getDNSZone(string '35')
5: Domain.php:1372
Domain->getDNSZone()
6: client.domain.dns.php:22
plesk__client__domain__dns->getDNSZone()
7: DNSUIPointer.php:96
DNSUIPointer->getFlavor()
8: UIPointer.php:919
UIPointer->getCaption(string 'done', string '', NULL null, object of type UserAdmin, NULL null, string '')
9: common_func.php3:4341
wizard_get_done_message()
10: plesk.php:29

 

[EustasioJ]

If i try to add a new record in the dns template, i get this error:

ERROR: PleskMainDBException Nivel superior



MySQL query failed: Unknown column 'uid' in 'field list'

--------------------------------------------------------------------------------

0: common_func.php3:211
db_query(string 'replace dns_recs_t set `id`='0', `type`='A', `displayHost`='<domain>.', `host`='<domain>.', `displayVal`='<ip>', `val`='<ip>', `opt`='', `time_stamp`='2011-12-27 13:23:23', `uid`=NULL')
1: Table.php:281
Table->replaceData(array)
2: Table.php:247
Table->update(array)
3: cObject.php:347
cObject->update()
4: DNSZoneRec.php:411
DNSZoneRec->update()
5: DNSZoneTemplate.php:137
DNSZoneTemplate->updateRecords()
6: DNSZoneTemplate.php:125
DNSZoneTemplate->update()
7: DNSTemplateManager.php:174
DNSTemplateManager::updateDNSZone(object of type DNSZoneTemplate)
8: dns_t_rec_edit.php:28

 

[IgorG]

Did you upgrade MySQL? Try to use MySQL shipped with Plesk distribution kit.

 

[EustasioJ]

i could see that the fields referred by the error do not exist in the database. Can i add these fields? What type are they? The fields are 'syncRecords' in table 'dns_zone' and 'uid' in table 'dns_recs_t'.

Or can i back to version 10.3?

 

[RaúlP]

I have same error message in Plesk 10.4.4 #9 on linux server CentOS 5 operative system.
This is information of my server:
Version: Parallels Plesk Panel v10.4.4_build1013111102.18 os_CentOS 5
SO: Linux 2.6.18-194.26.1.el5
I need help to resolve this issue urgently.
Regards.

 

[EustasioJ]

Any answer?

 

[Mike Burn]

Same issue

We have this same problem since upgrading to 10.4.4 - we get the error trying to view DNS in the control panel

ERROR: PleskMainDBException
MySQL query failed: Unknown column 'syncRecords' in 'field list'

We have appplied bootstrapper and no change

Any further suggestions, Igor?

Many thanks
Mike

 

[duno]

This is an Database inconsistency, create the needed fields in table dns_zone

ALTER TABLE dns_zone ADD syncSoa enum('true','false','skip') NOT NULL default 'skip' AFTER status
ALTER TABLE dns_zone ADD syncRecords enum('true','false','skip') NOT NULL default 'skip' AFTER syncSoa
update dns_zone set syncSoa='skip', syncRecords='skip'

This fixed the error for me.