• 29-09-2016, 19:32:00
    #1
    Merhabalar , whmcs taşırken aldığımız hatalar mevcut. Bu durumu 2 gündür çözemedim. Eski yerinde sorunsuz çalışıyor ancak şuan bu problemler mevcut. Site aktif oluyor ama ne ticketlara cevap verebiliyoruz, nede bir sipariş alabiliyoruz. Yardımlarınızı rica ederim. Kurulumda aldığımız hatalar aşağıdaki gibi.


    Ücretli bir şekilde sorunlarımızı halledecek ve optimizasyon yapabilecek arkadaşların yardımlarını bekliyoruz.





    Errors Occurred
    
    Please open a ticket with the debug information below for support
    
    File: upgrade330.sql
    Line 1 - Duplicate column name 'order'
    Line 4 - Duplicate column name 'setup'
    Line 5 - Duplicate column name 'copyto'
    Line 6 - Duplicate column name 'plaintext'
    Line 7 - Duplicate column name 'invoicenum'
    Line 8 - Duplicate column name 'productdownload'
    Line 9 - Duplicate column name 'downloads'
    Line 15 - Field 'attachments' doesn't have a default value
    Line 16 - Field 'attachments' doesn't have a default value
    Errors Occurred
    
    Please open a ticket with the debug information below for support
    
    File: upgrade340.sql
    Line 1 - Unknown column 'urlforwarding' in 'tbldomains'
    Line 3 - Unknown column 'renew' in 'tbldomainpricing'
    Line 5 - Duplicate column name 'idprotection'
    Line 6 - Duplicate column name 'eppcode'
    Line 7 - Duplicate column name 'idprotection'
    Line 9 - Data truncated for column 'domainstatus' at row 1
    Line 11 - Data truncated for column 'status' at row 1
    Line 16 - Field 'attachments' doesn't have a default value
    Line 17 - Field 'attachments' doesn't have a default value
    Line 18 - Field 'attachments' doesn't have a default value
    Line 30 - Unknown column 'type' in 'field list'
    Line 31 - Duplicate column name 'replyingadmin'
    Line 36 - Unknown column 'primarynameserver' in 'tblservers'
    Line 37 - Duplicate column name 'nameserver3'
    Line 40 - Duplicate column name 'accesshash'
    Errors Occurred
    
    Please open a ticket with the debug information below for support
    
    File: upgrade341.sql
    Line 6 - Field 'attachments' doesn't have a default value
    Errors Occurred
    
    Please open a ticket with the debug information below for support
    
    File: upgrade350.sql
    Line 8 - Duplicate column name 'type'
    Line 9 - Unknown column 'tblorders.domaintype' in 'field list'
    Line 10 - Can't DROP 'hostingid'; check that column/key exists
    Line 11 - Duplicate column name 'contactid'
    Line 12 - Duplicate column name 'clientsonly'
    Line 14 - Duplicate column name 'billingcid'
    Line 16 - Can't DROP 'randomstring'; check that column/key exists
    Errors Occurred
    
    Please open a ticket with the debug information below for support
    
    File: upgrade360.sql
    Line 2 - Field 'widgets' doesn't have a default value
    Line 3 - Field 'widgets' doesn't have a default value
    Line 4 - Field 'widgets' doesn't have a default value
    Line 7 - Duplicate column name 'roleid'
    Line 8 - Duplicate column name 'noautoresponder'
    Line 11 - Field 'attachments' doesn't have a default value
    Line 13 - Unknown column 'userlevel' in 'where clause'
    Line 14 - Unknown column 'userlevel' in 'where clause'
    Line 15 - Unknown column 'userlevel' in 'where clause'
    Line 16 - Can't DROP 'userlevel'; check that column/key exists
    Line 17 - Can't DROP 'ordernotifications'; check that column/key exists
    Errors Occurred
    
    Please open a ticket with the debug information below for support
    
    File: upgrade361.sql
    Line 1 - Unknown column 'price' in 'tblproductconfigoptionssub'
    Line 2 - Duplicate column name 'quarterly'
    Line 3 - Unknown column 'monthly' in 'field list'
    Line 6 - Duplicate column name 'donotrenew'
    Errors Occurred
    
    Please open a ticket with the debug information below for support
    
    File: upgrade362.sql
    Line 3 - Duplicate key name 'invoiceid'
    Line 4 - Duplicate key name 'userid'
    Line 5 - Duplicate key name 'date'
    Line 6 - Duplicate key name 'transid'
    Line 9 - Duplicate key name 'name'
    Line 11 - Duplicate key name 'logouttime'
    Line 12 - Duplicate key name 'roleid_permid'
    Line 14 - Duplicate key name 'username'
    Line 16 - Duplicate key name 'affiliateid'
    Line 17 - Duplicate key name 'clientid'
    Line 18 - Can't DROP 'PRIMARY'; check that column/key exists
    Line 21 - Duplicate key name 'affiliateid'
    Line 23 - Duplicate key name 'affiliateid'
    Line 25 - Duplicate key name 'clearingdate'
    Line 27 - Duplicate key name 'date'
    Line 29 - Duplicate key name 'domain'
    Line 31 - Duplicate key name 'ip'
    Line 33 - Duplicate key name 'name'
    Line 35 - Key column 'day' doesn't exist in table
    Line 37 - Duplicate key name 'serviceid'
    Line 39 - Duplicate key name 'firstname_lastname'
    Line 40 - Duplicate key name 'email'
    Line 41 - Duplicate key name 'setting'
    Line 42 - Duplicate key name 'userid_firstname_lastname'
    Line 44 - Duplicate key name 'email'
    Line 47 - Duplicate key name 'serviceid'
    Line 49 - Duplicate key name 'fieldid_relid'
    Line 51 - Duplicate key name 'extension_registrationperiod'
    Line 52 - Duplicate key name 'order'
    Line 54 - Duplicate key name 'userid'
    Line 55 - Duplicate key name 'orderid'
    Line 56 - Duplicate key name 'domain'
    Line 57 - Duplicate key name 'status'
    Line 59 - Duplicate key name 'domainid'
    Line 61 - Duplicate key name 'parentid'
    Line 63 - Duplicate key name 'title'
    Line 66 - Duplicate key name 'userid'
    Line 68 - Duplicate key name 'type'
    Line 69 - Duplicate key name 'name'
    Line 71 - Duplicate key name 'fraud'
    Line 74 - Unknown column 'rootpassword' in 'where clause'
    Line 75 - Can't DROP 'rootpassword'; check that column/key exists
    Line 76 - Duplicate key name 'serviceid'
    Line 77 - Duplicate key name 'userid'
    Line 78 - Duplicate key name 'orderid'
    Line 79 - Duplicate key name 'productid'
    Line 80 - Duplicate key name 'serverid'
    Line 81 - Duplicate key name 'domain'
    Line 82 - Duplicate key name 'domainstatus'
    Line 85 - Duplicate key name 'serviceid'
    Line 86 - Duplicate key name 'name'
    Line 87 - Duplicate key name 'status'
    Line 89 - Duplicate key name 'relid_configid'
    Line 94 - Duplicate key name 'status'
    Line 95 - Unknown column 'category' in 'tblknowledgebase'
    Line 98 - Duplicate key name 'name'
    Line 100 - Duplicate key name 'name'
    Line 102 - Duplicate key name 'userid'
    Line 104 - Duplicate key name 'ordernum'
    Line 105 - Duplicate key name 'userid'
    Line 106 - Duplicate key name 'contactid'
    Line 107 - Duplicate key name 'date'
    Line 108 - Unknown column 'id' in 'tblpaymentgateways'
    Line 109 - Duplicate key name 'gateway_setting'
    Line 110 - Duplicate key name 'setting_value'
    Line 111 - Unknown column 'productid' in 'tblproductconfigoptions'
    Line 112 - Key column 'productid' doesn't exist in table
    Line 114 - Duplicate key name 'configid'
    Line 115 - Duplicate key name 'order'
    Line 117 - Unknown column 'defaultserver' in 'tblproducts'
    Line 118 - Duplicate key name 'gid'
    Line 119 - Duplicate key name 'name'
    Line 121 - Duplicate key name 'code'
    Line 123 - Duplicate key name 'registrar_setting'
    Line 126 - Duplicate key name 'state_country'
    Line 129 - Duplicate key name 'name'
    Line 131 - Duplicate key name 'tid'
    Line 134 - Duplicate key name 'ticketid_date'
    Line 136 - Duplicate key name 'parentid_name'
    Line 139 - Duplicate key name 'tid_date'
    Line 141 - Duplicate key name 'tid_c'
    Line 142 - Duplicate key name 'userid'
    Line 143 - Duplicate key name 'status'
    Line 144 - Duplicate key name 'date'
    Line 148 - Duplicate key name 'duedate'
    Line 150 - Duplicate key name 'orderid'
    Line 151 - Duplicate key name 'serviceid'
    Errors Occurred
    
    Please open a ticket with the debug information below for support
    
    File: upgrade370.sql
    Line 1 - Duplicate column name 'level'
    Line 3 - Duplicate column name 'tax2'
    Line 4 - Duplicate column name 'taxrate2'
    Line 6 - Field 'attachments' doesn't have a default value
    Line 7 - Field 'attachments' doesn't have a default value
    Line 8 - Duplicate column name 'latefeeoveride'
    Line 9 - Duplicate column name 'overideduenotices'
    Line 11 - Duplicate column name 'qty'
    Line 12 - Can't DROP 'item'; check that column/key exists
    Line 13 - Unknown column 'discount' in 'tblpromotions'
    Line 15 - Duplicate column name 'applyonce'
    Line 17 - Field 'attachments' doesn't have a default value
    Line 18 - Duplicate column name 'service'
    Line 19 - Can't DROP 'domain'; check that column/key exists
    Line 23 - Duplicate column name 'hostname'
    Errors Occurred
    
    Please open a ticket with the debug information below for support
    
    File: upgrade380.sql
    Line 4 - Duplicate column name 'sortorder'
    Line 5 - Duplicate column name 'sortorder'
    Line 6 - Duplicate column name 'tax'
    Line 8 - Duplicate column name 'tax'
    Line 12 - Duplicate column name 'rating'
    Line 15 - Unknown column 'productid' in 'tblproductconfigoptions'
    Line 19 - Duplicate column name 'notes'
    Line 21 - Unknown column 'subscriptionid' in 'tblhostingaddons'
    Line 24 - Field 'attachments' doesn't have a default value
    Errors Occurred
    
    Please open a ticket with the debug information below for support
    
    File: upgrade400.sql
    Line 1 - Duplicate column name 'existingclient'
    Line 2 - Duplicate column name 'relid'
    Line 3 - Duplicate column name 'currency'
    Line 6 - Duplicate entry '1' for key 'PRIMARY'
    Line 10 - Duplicate column name 'currency'
    Line 11 - Duplicate column name 'currency'
    Line 12 - Can't DROP 'id'; check that column/key exists
    Line 14 - Duplicate column name 'securityqid'
    Line 15 - Duplicate column name 'to'
    Line 16 - Duplicate column name 'template'
    Line 18 - Duplicate column name 'refundid'
    Line 22 - Duplicate column name 'rate'
    Line 25 - Duplicate column name 'regexpr'
    Line 33 - Duplicate column name 'groupid'
    Line 35 - Duplicate column name 'overidesuspenduntil'
    Line 38 - Duplicate column name 'gatewayid'
    Errors Occurred
    
    Please open a ticket with the debug information below for support
    
    File: upgrade410.sql
    Line 1 - Duplicate column name 'piperepliesonly'
    Line 4 - Can't DROP 'defaultserver'; check that column/key exists
    Line 5 - Duplicate column name 'servergroup'
    Line 7 - Duplicate column name 'cardlastfour'
    Line 8 - Duplicate column name 'downloads'
    Line 9 - Duplicate column name 'addonid'
    Line 10 - Duplicate column name 'hidden'
    Line 11 - Duplicate column name 'hidden'
    Line 12 - Duplicate column name 'cc'
    Line 15 - Duplicate column name 'pwresetkey'
    Line 16 - Field 'attachments' doesn't have a default value
    Line 17 - Field 'attachments' doesn't have a default value
    Line 18 - Duplicate column name 'overagesenabled'
    Line 20 - Duplicate column name 'qtyminimum'
    Line 21 - Duplicate column name 'description'
    Errors Occurred
    
    Please open a ticket with the debug information below for support
    
    File: upgrade420.sql
    Line 1 - Duplicate column name 'parentid'
    Line 2 - Duplicate column name 'parentid'
    Line 3 - Duplicate column name 'catid'
    Line 5 - Duplicate column name 'requires'
    Line 6 - Duplicate column name 'subaccount'
    Line 13 - Duplicate entry '1' for key 'PRIMARY'
    Line 14 - Duplicate column name 'promoid'
    Line 15 - Duplicate column name 'promoid'
    Line 16 - Duplicate column name 'triennially'
    Line 17 - Duplicate column name 'tsetupfee'
    Line 21 - Duplicate column name 'renewals'
    Line 22 - Duplicate column name 'hours'
    Errors Occurred
    
    Please open a ticket with the debug information below for support
    
    File: upgrade421.sql
    Line 2 - Duplicate column name 'pwresetkey'
    Errors Occurred
    
    Please open a ticket with the debug information below for support
    
    File: upgrade430.sql
    Line 1 - Duplicate column name 'weight'
    Line 9 - Duplicate column name 'suspendreason'
    Line 11 - Duplicate column name 'recurfor'
    Line 12 - Field 'attachments' doesn't have a default value
    Errors Occurred
    
    Please open a ticket with the debug information below for support
    
    File: upgrade440.sql
    Line 2 - Duplicate column name 'separateinvoices'
    Line 3 - Duplicate column name 'separateinvoices'
    Line 4 - Duplicate column name 'disableautocc'
    Line 6 - Duplicate column name 'language'
    Line 7 - Duplicate column name 'userid'
    Line 8 - Duplicate column name 'upgradeemail'
    Errors Occurred
    
    Please open a ticket with the debug information below for support
    
    File: upgrade450.sql
    Line 1 - Duplicate column name 'startdate'
    Line 2 - Duplicate column name 'notes'
    Line 3 - Duplicate column name 'suspendproduct'
    Line 4 - Field 'attachments' doesn't have a default value
    Line 5 - Duplicate column name 'showinvoice'
    Line 6 - Duplicate column name 'autoterminatedays'
    Line 8 - Duplicate column name 'assignedips'
    Line 9 - Duplicate column name 'proposal'
    Line 15 - Duplicate column name 'disabled'
    Line 16 - Duplicate column name 'attachments'
    Line 17 - Duplicate column name 'upgrades'
    Errors Occurred
    
    Please open a ticket with the debug information below for support
    
    File: upgrade500.sql
    Line 1 - Duplicate column name 'homewidgets'
    Line 2 - Duplicate column name 'widgets'
    Line 6 - Field 'attachments' doesn't have a default value
    Line 8 - Duplicate column name 'onetime'
    Line 9 - Duplicate column name 'description'
    Line 10 - Duplicate column name 'recurringcycles'
    Line 11 - Duplicate column name 'allowqty'
    Line 12 - Field 'attachments' doesn't have a default value
    Line 13 - Duplicate column name 'nameserver5'
    Line 15 - Duplicate column name 'order'
    Errors Occurred
    
    Please open a ticket with the debug information below for support
    
    File: upgrade501.sql
    Line 1 - Duplicate column name 'defaultgateway'
    Line 2 - Duplicate column name 'contactid'
    Line 3 - Duplicate column name 'contactid'
    Line 4 - Duplicate column name 'hidden'
    Line 5 - Duplicate column name 'orderdata'
    Errors Occurred
    
    Please open a ticket with the debug information below for support
    
    File: upgrade502.sql
    Line 1 - Duplicate column name 'showgroup'
    Errors Occurred
    
    Please open a ticket with the debug information below for support
    
    File: upgrade510.sql
    Line 4 - Duplicate column name 'synced'
    Line 5 - Duplicate column name 'sticky'
    Line 7 - Duplicate column name 'retired'
    Line 13 - Duplicate column name 'authmodule'
    Line 15 - Duplicate column name 'reminders'
    Line 18 - Duplicate entry '1' for key 'PRIMARY'
    Line 20 - Duplicate column name 'lifetimepromo'
    Line 21 - Duplicate column name 'datesent'
    Errors Occurred
    
    Please open a ticket with the debug information below for support
    
    File: upgrade520.sql
    Line 1 - Duplicate column name 'disabled'
    Line 6 - Duplicate column name 'emailoptout'
    Line 8 - Duplicate column name 'marketing'
    Line 9 - Duplicate column name 'overrideautoclose'
    Line 12 - Field 'attachments' doesn't have a default value
    Line 13 - Duplicate column name 'orderfrmtpl'
    Line 15 - Duplicate column name 'affiliateemails'
    Line 20 - Field 'attachments' doesn't have a default value
    Errors Occurred
    
    Please open a ticket with the debug information below for support
    
    File: upgrade521.sql
    Line 1 - Duplicate column name 'authmodule'
    Line 2 - Duplicate column name 'upgradechargefullcycle'
    Errors Occurred
    
    Please open a ticket with the debug information below for support
    
    File: upgrade539.sql
    Line 2 - Duplicate column name 'passwordhash'
    Here's what you should do next:
  • 30-09-2016, 13:49:43
    #2
    GalaxyShell adlı üyeden alıntı: mesajı görüntüle
    Merhabalar , whmcs taşırken aldığımız hatalar mevcut. Bu durumu 2 gündür çözemedim. Eski yerinde sorunsuz çalışıyor ancak şuan bu problemler mevcut. Site aktif oluyor ama ne ticketlara cevap verebiliyoruz, nede bir sipariş alabiliyoruz. Yardımlarınızı rica ederim. Kurulumda aldığımız hatalar aşağıdaki gibi.


    Ücretli bir şekilde sorunlarımızı halledecek ve optimizasyon yapabilecek arkadaşların yardımlarını bekliyoruz.





    Errors Occurred
    
    Please open a ticket with the debug information below for support
    
    File: upgrade330.sql
    Line 1 - Duplicate column name 'order'
    Line 4 - Duplicate column name 'setup'
    Line 5 - Duplicate column name 'copyto'
    Line 6 - Duplicate column name 'plaintext'
    Line 7 - Duplicate column name 'invoicenum'
    Line 8 - Duplicate column name 'productdownload'
    Line 9 - Duplicate column name 'downloads'
    Line 15 - Field 'attachments' doesn't have a default value
    Line 16 - Field 'attachments' doesn't have a default value
    Errors Occurred
    
    Please open a ticket with the debug information below for support
    
    File: upgrade340.sql
    Line 1 - Unknown column 'urlforwarding' in 'tbldomains'
    Line 3 - Unknown column 'renew' in 'tbldomainpricing'
    Line 5 - Duplicate column name 'idprotection'
    Line 6 - Duplicate column name 'eppcode'
    Line 7 - Duplicate column name 'idprotection'
    Line 9 - Data truncated for column 'domainstatus' at row 1
    Line 11 - Data truncated for column 'status' at row 1
    Line 16 - Field 'attachments' doesn't have a default value
    Line 17 - Field 'attachments' doesn't have a default value
    Line 18 - Field 'attachments' doesn't have a default value
    Line 30 - Unknown column 'type' in 'field list'
    Line 31 - Duplicate column name 'replyingadmin'
    Line 36 - Unknown column 'primarynameserver' in 'tblservers'
    Line 37 - Duplicate column name 'nameserver3'
    Line 40 - Duplicate column name 'accesshash'
    Errors Occurred
    
    Please open a ticket with the debug information below for support
    
    File: upgrade341.sql
    Line 6 - Field 'attachments' doesn't have a default value
    Errors Occurred
    
    Please open a ticket with the debug information below for support
    
    File: upgrade350.sql
    Line 8 - Duplicate column name 'type'
    Line 9 - Unknown column 'tblorders.domaintype' in 'field list'
    Line 10 - Can't DROP 'hostingid'; check that column/key exists
    Line 11 - Duplicate column name 'contactid'
    Line 12 - Duplicate column name 'clientsonly'
    Line 14 - Duplicate column name 'billingcid'
    Line 16 - Can't DROP 'randomstring'; check that column/key exists
    Errors Occurred
    
    Please open a ticket with the debug information below for support
    
    File: upgrade360.sql
    Line 2 - Field 'widgets' doesn't have a default value
    Line 3 - Field 'widgets' doesn't have a default value
    Line 4 - Field 'widgets' doesn't have a default value
    Line 7 - Duplicate column name 'roleid'
    Line 8 - Duplicate column name 'noautoresponder'
    Line 11 - Field 'attachments' doesn't have a default value
    Line 13 - Unknown column 'userlevel' in 'where clause'
    Line 14 - Unknown column 'userlevel' in 'where clause'
    Line 15 - Unknown column 'userlevel' in 'where clause'
    Line 16 - Can't DROP 'userlevel'; check that column/key exists
    Line 17 - Can't DROP 'ordernotifications'; check that column/key exists
    Errors Occurred
    
    Please open a ticket with the debug information below for support
    
    File: upgrade361.sql
    Line 1 - Unknown column 'price' in 'tblproductconfigoptionssub'
    Line 2 - Duplicate column name 'quarterly'
    Line 3 - Unknown column 'monthly' in 'field list'
    Line 6 - Duplicate column name 'donotrenew'
    Errors Occurred
    
    Please open a ticket with the debug information below for support
    
    File: upgrade362.sql
    Line 3 - Duplicate key name 'invoiceid'
    Line 4 - Duplicate key name 'userid'
    Line 5 - Duplicate key name 'date'
    Line 6 - Duplicate key name 'transid'
    Line 9 - Duplicate key name 'name'
    Line 11 - Duplicate key name 'logouttime'
    Line 12 - Duplicate key name 'roleid_permid'
    Line 14 - Duplicate key name 'username'
    Line 16 - Duplicate key name 'affiliateid'
    Line 17 - Duplicate key name 'clientid'
    Line 18 - Can't DROP 'PRIMARY'; check that column/key exists
    Line 21 - Duplicate key name 'affiliateid'
    Line 23 - Duplicate key name 'affiliateid'
    Line 25 - Duplicate key name 'clearingdate'
    Line 27 - Duplicate key name 'date'
    Line 29 - Duplicate key name 'domain'
    Line 31 - Duplicate key name 'ip'
    Line 33 - Duplicate key name 'name'
    Line 35 - Key column 'day' doesn't exist in table
    Line 37 - Duplicate key name 'serviceid'
    Line 39 - Duplicate key name 'firstname_lastname'
    Line 40 - Duplicate key name 'email'
    Line 41 - Duplicate key name 'setting'
    Line 42 - Duplicate key name 'userid_firstname_lastname'
    Line 44 - Duplicate key name 'email'
    Line 47 - Duplicate key name 'serviceid'
    Line 49 - Duplicate key name 'fieldid_relid'
    Line 51 - Duplicate key name 'extension_registrationperiod'
    Line 52 - Duplicate key name 'order'
    Line 54 - Duplicate key name 'userid'
    Line 55 - Duplicate key name 'orderid'
    Line 56 - Duplicate key name 'domain'
    Line 57 - Duplicate key name 'status'
    Line 59 - Duplicate key name 'domainid'
    Line 61 - Duplicate key name 'parentid'
    Line 63 - Duplicate key name 'title'
    Line 66 - Duplicate key name 'userid'
    Line 68 - Duplicate key name 'type'
    Line 69 - Duplicate key name 'name'
    Line 71 - Duplicate key name 'fraud'
    Line 74 - Unknown column 'rootpassword' in 'where clause'
    Line 75 - Can't DROP 'rootpassword'; check that column/key exists
    Line 76 - Duplicate key name 'serviceid'
    Line 77 - Duplicate key name 'userid'
    Line 78 - Duplicate key name 'orderid'
    Line 79 - Duplicate key name 'productid'
    Line 80 - Duplicate key name 'serverid'
    Line 81 - Duplicate key name 'domain'
    Line 82 - Duplicate key name 'domainstatus'
    Line 85 - Duplicate key name 'serviceid'
    Line 86 - Duplicate key name 'name'
    Line 87 - Duplicate key name 'status'
    Line 89 - Duplicate key name 'relid_configid'
    Line 94 - Duplicate key name 'status'
    Line 95 - Unknown column 'category' in 'tblknowledgebase'
    Line 98 - Duplicate key name 'name'
    Line 100 - Duplicate key name 'name'
    Line 102 - Duplicate key name 'userid'
    Line 104 - Duplicate key name 'ordernum'
    Line 105 - Duplicate key name 'userid'
    Line 106 - Duplicate key name 'contactid'
    Line 107 - Duplicate key name 'date'
    Line 108 - Unknown column 'id' in 'tblpaymentgateways'
    Line 109 - Duplicate key name 'gateway_setting'
    Line 110 - Duplicate key name 'setting_value'
    Line 111 - Unknown column 'productid' in 'tblproductconfigoptions'
    Line 112 - Key column 'productid' doesn't exist in table
    Line 114 - Duplicate key name 'configid'
    Line 115 - Duplicate key name 'order'
    Line 117 - Unknown column 'defaultserver' in 'tblproducts'
    Line 118 - Duplicate key name 'gid'
    Line 119 - Duplicate key name 'name'
    Line 121 - Duplicate key name 'code'
    Line 123 - Duplicate key name 'registrar_setting'
    Line 126 - Duplicate key name 'state_country'
    Line 129 - Duplicate key name 'name'
    Line 131 - Duplicate key name 'tid'
    Line 134 - Duplicate key name 'ticketid_date'
    Line 136 - Duplicate key name 'parentid_name'
    Line 139 - Duplicate key name 'tid_date'
    Line 141 - Duplicate key name 'tid_c'
    Line 142 - Duplicate key name 'userid'
    Line 143 - Duplicate key name 'status'
    Line 144 - Duplicate key name 'date'
    Line 148 - Duplicate key name 'duedate'
    Line 150 - Duplicate key name 'orderid'
    Line 151 - Duplicate key name 'serviceid'
    Errors Occurred
    
    Please open a ticket with the debug information below for support
    
    File: upgrade370.sql
    Line 1 - Duplicate column name 'level'
    Line 3 - Duplicate column name 'tax2'
    Line 4 - Duplicate column name 'taxrate2'
    Line 6 - Field 'attachments' doesn't have a default value
    Line 7 - Field 'attachments' doesn't have a default value
    Line 8 - Duplicate column name 'latefeeoveride'
    Line 9 - Duplicate column name 'overideduenotices'
    Line 11 - Duplicate column name 'qty'
    Line 12 - Can't DROP 'item'; check that column/key exists
    Line 13 - Unknown column 'discount' in 'tblpromotions'
    Line 15 - Duplicate column name 'applyonce'
    Line 17 - Field 'attachments' doesn't have a default value
    Line 18 - Duplicate column name 'service'
    Line 19 - Can't DROP 'domain'; check that column/key exists
    Line 23 - Duplicate column name 'hostname'
    Errors Occurred
    
    Please open a ticket with the debug information below for support
    
    File: upgrade380.sql
    Line 4 - Duplicate column name 'sortorder'
    Line 5 - Duplicate column name 'sortorder'
    Line 6 - Duplicate column name 'tax'
    Line 8 - Duplicate column name 'tax'
    Line 12 - Duplicate column name 'rating'
    Line 15 - Unknown column 'productid' in 'tblproductconfigoptions'
    Line 19 - Duplicate column name 'notes'
    Line 21 - Unknown column 'subscriptionid' in 'tblhostingaddons'
    Line 24 - Field 'attachments' doesn't have a default value
    Errors Occurred
    
    Please open a ticket with the debug information below for support
    
    File: upgrade400.sql
    Line 1 - Duplicate column name 'existingclient'
    Line 2 - Duplicate column name 'relid'
    Line 3 - Duplicate column name 'currency'
    Line 6 - Duplicate entry '1' for key 'PRIMARY'
    Line 10 - Duplicate column name 'currency'
    Line 11 - Duplicate column name 'currency'
    Line 12 - Can't DROP 'id'; check that column/key exists
    Line 14 - Duplicate column name 'securityqid'
    Line 15 - Duplicate column name 'to'
    Line 16 - Duplicate column name 'template'
    Line 18 - Duplicate column name 'refundid'
    Line 22 - Duplicate column name 'rate'
    Line 25 - Duplicate column name 'regexpr'
    Line 33 - Duplicate column name 'groupid'
    Line 35 - Duplicate column name 'overidesuspenduntil'
    Line 38 - Duplicate column name 'gatewayid'
    Errors Occurred
    
    Please open a ticket with the debug information below for support
    
    File: upgrade410.sql
    Line 1 - Duplicate column name 'piperepliesonly'
    Line 4 - Can't DROP 'defaultserver'; check that column/key exists
    Line 5 - Duplicate column name 'servergroup'
    Line 7 - Duplicate column name 'cardlastfour'
    Line 8 - Duplicate column name 'downloads'
    Line 9 - Duplicate column name 'addonid'
    Line 10 - Duplicate column name 'hidden'
    Line 11 - Duplicate column name 'hidden'
    Line 12 - Duplicate column name 'cc'
    Line 15 - Duplicate column name 'pwresetkey'
    Line 16 - Field 'attachments' doesn't have a default value
    Line 17 - Field 'attachments' doesn't have a default value
    Line 18 - Duplicate column name 'overagesenabled'
    Line 20 - Duplicate column name 'qtyminimum'
    Line 21 - Duplicate column name 'description'
    Errors Occurred
    
    Please open a ticket with the debug information below for support
    
    File: upgrade420.sql
    Line 1 - Duplicate column name 'parentid'
    Line 2 - Duplicate column name 'parentid'
    Line 3 - Duplicate column name 'catid'
    Line 5 - Duplicate column name 'requires'
    Line 6 - Duplicate column name 'subaccount'
    Line 13 - Duplicate entry '1' for key 'PRIMARY'
    Line 14 - Duplicate column name 'promoid'
    Line 15 - Duplicate column name 'promoid'
    Line 16 - Duplicate column name 'triennially'
    Line 17 - Duplicate column name 'tsetupfee'
    Line 21 - Duplicate column name 'renewals'
    Line 22 - Duplicate column name 'hours'
    Errors Occurred
    
    Please open a ticket with the debug information below for support
    
    File: upgrade421.sql
    Line 2 - Duplicate column name 'pwresetkey'
    Errors Occurred
    
    Please open a ticket with the debug information below for support
    
    File: upgrade430.sql
    Line 1 - Duplicate column name 'weight'
    Line 9 - Duplicate column name 'suspendreason'
    Line 11 - Duplicate column name 'recurfor'
    Line 12 - Field 'attachments' doesn't have a default value
    Errors Occurred
    
    Please open a ticket with the debug information below for support
    
    File: upgrade440.sql
    Line 2 - Duplicate column name 'separateinvoices'
    Line 3 - Duplicate column name 'separateinvoices'
    Line 4 - Duplicate column name 'disableautocc'
    Line 6 - Duplicate column name 'language'
    Line 7 - Duplicate column name 'userid'
    Line 8 - Duplicate column name 'upgradeemail'
    Errors Occurred
    
    Please open a ticket with the debug information below for support
    
    File: upgrade450.sql
    Line 1 - Duplicate column name 'startdate'
    Line 2 - Duplicate column name 'notes'
    Line 3 - Duplicate column name 'suspendproduct'
    Line 4 - Field 'attachments' doesn't have a default value
    Line 5 - Duplicate column name 'showinvoice'
    Line 6 - Duplicate column name 'autoterminatedays'
    Line 8 - Duplicate column name 'assignedips'
    Line 9 - Duplicate column name 'proposal'
    Line 15 - Duplicate column name 'disabled'
    Line 16 - Duplicate column name 'attachments'
    Line 17 - Duplicate column name 'upgrades'
    Errors Occurred
    
    Please open a ticket with the debug information below for support
    
    File: upgrade500.sql
    Line 1 - Duplicate column name 'homewidgets'
    Line 2 - Duplicate column name 'widgets'
    Line 6 - Field 'attachments' doesn't have a default value
    Line 8 - Duplicate column name 'onetime'
    Line 9 - Duplicate column name 'description'
    Line 10 - Duplicate column name 'recurringcycles'
    Line 11 - Duplicate column name 'allowqty'
    Line 12 - Field 'attachments' doesn't have a default value
    Line 13 - Duplicate column name 'nameserver5'
    Line 15 - Duplicate column name 'order'
    Errors Occurred
    
    Please open a ticket with the debug information below for support
    
    File: upgrade501.sql
    Line 1 - Duplicate column name 'defaultgateway'
    Line 2 - Duplicate column name 'contactid'
    Line 3 - Duplicate column name 'contactid'
    Line 4 - Duplicate column name 'hidden'
    Line 5 - Duplicate column name 'orderdata'
    Errors Occurred
    
    Please open a ticket with the debug information below for support
    
    File: upgrade502.sql
    Line 1 - Duplicate column name 'showgroup'
    Errors Occurred
    
    Please open a ticket with the debug information below for support
    
    File: upgrade510.sql
    Line 4 - Duplicate column name 'synced'
    Line 5 - Duplicate column name 'sticky'
    Line 7 - Duplicate column name 'retired'
    Line 13 - Duplicate column name 'authmodule'
    Line 15 - Duplicate column name 'reminders'
    Line 18 - Duplicate entry '1' for key 'PRIMARY'
    Line 20 - Duplicate column name 'lifetimepromo'
    Line 21 - Duplicate column name 'datesent'
    Errors Occurred
    
    Please open a ticket with the debug information below for support
    
    File: upgrade520.sql
    Line 1 - Duplicate column name 'disabled'
    Line 6 - Duplicate column name 'emailoptout'
    Line 8 - Duplicate column name 'marketing'
    Line 9 - Duplicate column name 'overrideautoclose'
    Line 12 - Field 'attachments' doesn't have a default value
    Line 13 - Duplicate column name 'orderfrmtpl'
    Line 15 - Duplicate column name 'affiliateemails'
    Line 20 - Field 'attachments' doesn't have a default value
    Errors Occurred
    
    Please open a ticket with the debug information below for support
    
    File: upgrade521.sql
    Line 1 - Duplicate column name 'authmodule'
    Line 2 - Duplicate column name 'upgradechargefullcycle'
    Errors Occurred
    
    Please open a ticket with the debug information below for support
    
    File: upgrade539.sql
    Line 2 - Duplicate column name 'passwordhash'
    Here's what you should do next:
    Merhaba, linkte sorun için konu açıldığında verilen cevap ;

    Hi,
    This means you are trying to perform an installation over a pre-existing database, you can only install on an empty database.
    So drop the database and perform the installation again.

    Bu olmuş, eski tarihli bir konu fakat temiz bir veritabanı açıp tekrar deneyebilirsiniz.
    • GalaxyShell
    GalaxyShell bunu beğendi.
    1 kişi bunu beğendi.
  • 30-09-2016, 15:25:08
    #3
    Merhaba
    Php versiyon farkı ve php modülleri eksik olmasından kaynaklanabilir.
    Whmcs versiyon notlarından sunucu gereksinimlerine bakıp bu şekilde çözebilirsiniz.
  • 30-09-2016, 23:33:15
    #4
    poyrazhost adlı üyeden alıntı: mesajı görüntüle
    Merhaba, linkte sorun için konu açıldığında verilen cevap ;

    Hi,
    This means you are trying to perform an installation over a pre-existing database, you can only install on an empty database.
    So drop the database and perform the installation again.

    Bu olmuş, eski tarihli bir konu fakat temiz bir veritabanı açıp tekrar deneyebilirsiniz.
    sistemmedya adlı üyeden alıntı: mesajı görüntüle
    Merhaba
    Php versiyon farkı ve php modülleri eksik olmasından kaynaklanabilir.
    Whmcs versiyon notlarından sunucu gereksinimlerine bakıp bu şekilde çözebilirsiniz.
    Cevaplarınız için teşekkür ederim, ancak ne yapsamda işler yolunda gitmedi. Bu sebeple bir developer arkadaştan yardım almak zorunda kaldım. Yanısıra sürümüde güncellemiş olduk bu arada