1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

Creating a new subscription problem

Discussion in 'Plesk 10.x for Linux Issues, Fixes, How-To' started by EustasioJ, Dec 21, 2011.

  1. EustasioJ

    EustasioJ Guest

    0
     
    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?
     
  2. IgorG

    IgorG Forums Analyst Staff Member

    49
    24%
    Joined:
    Oct 27, 2009
    Messages:
    24,547
    Likes Received:
    1,240
    Location:
    Novosibirsk, Russia
    Looks like uncompleted upgrade. Fix it with bootstrapper repair procedure (described in KB).
     
  3. EustasioJ

    EustasioJ Guest

    0
     
    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?
     
    Last edited by a moderator: Dec 23, 2011
  4. EustasioJ

    EustasioJ Guest

    0
     
    Please, i need a solution soon!
     
  5. EustasioJ

    EustasioJ Guest

    0
     
    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
     
  6. EustasioJ

    EustasioJ Guest

    0
     
    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
     
  7. IgorG

    IgorG Forums Analyst Staff Member

    49
    24%
    Joined:
    Oct 27, 2009
    Messages:
    24,547
    Likes Received:
    1,240
    Location:
    Novosibirsk, Russia
    Did you upgrade MySQL? Try to use MySQL shipped with Plesk distribution kit.
     
  8. EustasioJ

    EustasioJ Guest

    0
     
    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?
     
  9. RaúlP

    RaúlP Guest

    0
     
    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.
     
  10. EustasioJ

    EustasioJ Guest

    0
     
    Any answer?
     
  11. Mike Burn

    Mike Burn Guest

    0
     
    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
     
  12. duno

    duno New Pleskian

    22
    53%
    Joined:
    Jun 28, 2005
    Messages:
    13
    Likes Received:
    0
    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.
     
Loading...