Results 1 to 13 of 13
  1. #1
    Join Date
    Jul 2009
    Location
    Serbia
    Posts
    125

    whmcs white pages

    Hello i have problems with white pages.e.g when i go to add payment he show white page and not send confirmation mail to cliet but total cost is ok.


    I reinstall whmces complete delete files and install new version 4.12 and when i type database name and user pass... and click to next i get this erors

    Errors Occured

    Please open a ticket with the debug information below for support

    File: install.sql
    Line 1 - Table 'tblaccounts' already exists
    Line 2 - Table 'tblactivitylog' already exists
    Line 3 - Table 'tbladdons' already exists
    Line 4 - Table 'tbladminlog' already exists
    Line 5 - Table 'tbladmins' already exists
    Line 6 - Table 'tblaffiliates' already exists
    Line 7 - Table 'tblaffiliatesaccounts' already exists
    Line 8 - Table 'tblaffiliateshistory' already exists
    Line 9 - Table 'tblannouncements' already exists
    Line 10 - Table 'tblbannedemails' already exists
    Line 11 - Table 'tblbannedips' already exists
    Line 12 - Table 'tblbrowserlinks' already exists
    Line 13 - Table 'tblcalendar' already exists
    Line 14 - Table 'tblcancelrequests' already exists
    Line 15 - Table 'tblclients' already exists
    Line 16 - Table 'tblconfiguration' already exists
    Line 17 - Table 'tblcredit' already exists
    Line 18 - Table 'tblcustomfields' already exists
    Line 19 - Table 'tblcustomfieldsvalues' already exists
    Line 20 - Table 'tbldomainpricing' already exists
    Line 21 - Table 'tbldomains' already exists
    Line 22 - Table 'tbldomainsadditionalfields' already exists
    Line 23 - Table 'tbldownloadcats' already exists
    Line 24 - Table 'tbldownloads' already exists
    Line 25 - Table 'tblemails' already exists
    Line 26 - Table 'tblemailtemplates' already exists
    Line 27 - Table 'tblfraud' already exists
    Line 28 - Table 'tblgatewaylog' already exists
    Line 29 - Table 'tblhosting' already exists
    Line 30 - Table 'tblhostingaddons' already exists
    Line 31 - Table 'tblhostingconfigoptions' already exists
    Line 32 - Table 'tblinvoiceitems' already exists
    Line 33 - Table 'tblinvoices' already exists
    Line 34 - Table 'tblknowledgebase' already exists
    Line 35 - Table 'tblknowledgebasecats' already exists
    Line 36 - Table 'tblorders' already exists
    Line 37 - Table 'tblpaymentgateways' already exists
    Line 38 - Table 'tblproductconfigoptions' already exists
    Line 39 - Table 'tblproductconfigoptionssub' already exists
    Line 40 - Table 'tblproductgroups' already exists
    Line 41 - Table 'tblproducts' already exists
    Line 42 - Table 'tblpromotions' already exists
    Line 43 - Table 'tblregistrars' already exists
    Line 44 - Table 'tblreselleraccountsetup' already exists
    Line 45 - Table 'tblservers' already exists
    Line 46 - Table 'tbltax' already exists
    Line 47 - Table 'tblticketbreaklines' already exists
    Line 48 - Table 'tblticketdepartments' already exists
    Line 49 - Table 'tblticketlog' already exists
    Line 50 - Table 'tblticketmaillog' already exists
    Line 51 - Table 'tblticketnotes' already exists
    Line 52 - Table 'tblticketpredefinedcats' already exists
    Line 53 - Table 'tblticketpredefinedreplies' already exists
    Line 54 - Table 'tblticketreplies' already exists
    Line 55 - Table 'tbltickets' already exists
    Line 56 - Table 'tblticketspamfilters' already exists
    Line 57 - Table 'tbltodolist' already exists
    Line 58 - Table 'tblupgrades' already exists
    Line 59 - Table 'tblwhoislog' already exists
    Line 158 - Duplicate entry '1' for key 1
    Line 159 - Duplicate entry '2' for key 1
    Line 160 - Duplicate entry '3' for key 1
    Line 161 - Duplicate entry '4' for key 1
    Line 162 - Duplicate entry '5' for key 1
    Line 163 - Duplicate entry '6' for key 1
    Errors Occured

    Please open a ticket with the debug information below for support

    File: emailtemplates.sql
    Line 1 - Column count doesn't match value count at row 1
    Line 2 - Column count doesn't match value count at row 1
    Line 3 - Column count doesn't match value count at row 1
    Line 4 - Column count doesn't match value count at row 1
    Line 5 - Column count doesn't match value count at row 1
    Line 6 - Column count doesn't match value count at row 1
    Line 7 - Column count doesn't match value count at row 1
    Line 8 - Column count doesn't match value count at row 1
    Line 9 - Column count doesn't match value count at row 1
    Line 10 - Column count doesn't match value count at row 1
    Line 11 - Column count doesn't match value count at row 1
    Line 12 - Column count doesn't match value count at row 1
    Line 13 - Column count doesn't match value count at row 1
    Line 14 - Column count doesn't match value count at row 1
    Line 15 - Column count doesn't match value count at row 1
    Line 16 - Column count doesn't match value count at row 1
    Line 17 - Column count doesn't match value count at row 1
    Line 18 - Column count doesn't match value count at row 1
    Line 19 - Column count doesn't match value count at row 1
    Line 20 - Column count doesn't match value count at row 1
    Line 21 - Column count doesn't match value count at row 1
    Line 22 - Column count doesn't match value count at row 1
    Line 23 - Column count doesn't match value count at row 1
    Line 24 - Column count doesn't match value count at row 1
    Line 25 - Column count doesn't match value count at row 1

    And click to next to type admion details i get this message


    Please open a ticket with the debug information below for support

    File: upgrade330.sql
    Line 1 - Duplicate column name 'order'
    Line 3 - Table 'tblnotes' already exists
    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'
    Errors Occured

    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 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 Occured

    Please open a ticket with the debug information below for support

    File: upgrade341.sql
    Line 1 - Table 'tblaffiliatespending' already exists
    Errors Occured

    Please open a ticket with the debug information below for support

    File: upgrade350.sql
    Line 3 - Table 'tblcontacts' already exists
    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 Occured

    Please open a ticket with the debug information below for support

    File: upgrade360.sql
    Line 1 - Table 'tbladminroles' already exists
    Line 2 - Duplicate entry '1' for key 1
    Line 3 - Duplicate entry '2' for key 1
    Line 4 - Duplicate entry '3' for key 1
    Line 5 - Table 'tbladminperms' already exists
    Line 7 - Duplicate column name 'roleid'
    Line 8 - Duplicate column name 'noautoresponder'
    Line 12 - Table 'tbllinks' already exists
    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
    Line 43 - Table 'tblaffiliateswithdrawals' already exists
    Errors Occured

    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 Occured

    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 - Duplicate key name 'day_month_year'
    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 99 - Duplicate key name 'name'
    Line 101 - Duplicate key name 'name'
    Line 103 - Duplicate key name 'userid'
    Line 105 - Duplicate key name 'ordernum'
    Line 106 - Duplicate key name 'userid'
    Line 107 - Duplicate key name 'contactid'
    Line 108 - Duplicate key name 'date'
    Line 109 - Unknown column 'id' in 'tblpaymentgateways'
    Line 110 - Duplicate key name 'gateway_setting'
    Line 111 - Duplicate key name 'setting_value'
    Line 112 - Unknown column 'productid' in 'tblproductconfigoptions'
    Line 113 - Key column 'productid' doesn't exist in table
    Line 115 - Duplicate key name 'configid'
    Line 116 - Duplicate key name 'order'
    Line 118 - Unknown column 'defaultserver' in 'tblproducts'
    Line 119 - Duplicate key name 'gid'
    Line 120 - Duplicate key name 'name'
    Line 122 - Duplicate key name 'code'
    Line 124 - Duplicate key name 'registrar_setting'
    Line 127 - Duplicate key name 'state_country'
    Line 130 - Duplicate key name 'name'
    Line 132 - Duplicate key name 'tid'
    Line 135 - Duplicate key name 'ticketid_date'
    Line 137 - Duplicate key name 'parentid_name'
    Line 140 - Duplicate key name 'tid_date'
    Line 142 - Duplicate key name 'tid_c'
    Line 143 - Duplicate key name 'userid'
    Line 144 - Duplicate key name 'status'
    Line 145 - Duplicate key name 'date'
    Line 149 - Duplicate key name 'duedate'
    Line 151 - Duplicate key name 'orderid'
    Line 152 - Duplicate key name 'serviceid'
    Line 156 - Table 'tblsslorders' already exists
    Errors Occured

    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 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 18 - Duplicate column name 'service'
    Line 19 - Can't DROP 'domain'; check that column/key exists
    Line 23 - Duplicate column name 'hostname'
    Errors Occured

    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 13 - Table 'tblproductconfiggroups' already exists
    Line 14 - Table 'tblproductconfiglinks' already exists
    Line 15 - Unknown column 'productid' in 'tblproductconfigoptions'
    Line 16 - Table 'tblnetworkissues' already exists
    Line 19 - Duplicate column name 'notes'
    Line 21 - Unknown column 'subscriptionid' in 'tblhostingaddons'
    Line 22 - Table 'tblquotes' already exists
    Line 23 - Table 'tblquoteitems' already exists
    Errors Occured

    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 5 - Table 'tblcurrencies' already exists
    Line 6 - Duplicate entry '1' for key 1
    Line 7 - Table 'tblpricing' already exists
    Line 10 - Duplicate column name 'currency'
    Line 11 - Duplicate column name 'currency'
    Line 12 - Can't DROP 'id'; check that column/key exists
    Line 13 - Table 'tbladminsecurityquestions' already 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 26 - Table 'tblknowledgebaselinks' already exists
    Line 27 - Table 'tblbillableitems' already exists
    Line 32 - Table 'tblclientgroups' already exists
    Line 33 - Duplicate column name 'groupid'
    Line 34 - Table 'tblticketescalations' already exists
    Line 35 - Duplicate column name 'overidesuspenduntil'
    Line 38 - Duplicate column name 'gatewayid'
    Errors Occured

    Please open a ticket with the debug information below for support

    File: upgrade410.sql
    Line 1 - Duplicate column name 'piperepliesonly'
    Line 2 - Table 'tblservergroups' already exists
    Line 3 - Table 'tblservergroupsrel' already exists
    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 14 - Table 'tblclientsfiles' already exists
    Line 15 - Duplicate column name 'pwresetkey'
    Line 19 - Duplicate column name 'overagesenabled'
    Line 21 - Duplicate column name 'qtyminimum'
    Line 22 - Duplicate column name 'description'


    i complete install and whmcs is work but afein white pages and problem with mass mailing an costumer confirmation mail.

    How to fix this problem?

    Thanks

  2. #2
    Join Date
    Aug 2008
    Location
    Ashburn, VA
    Posts
    99
    This is happening because it is trying to create a table in mysql with the same name but one already exist. are you sure you are pressing the upgrade button, i have had WHMCS for 6 months and if you go to install the same version again i couldn't get it to work. Im not up to date with 4.1 im on 4.0. But i know from test that if the license is not valid that the whole client area is just a white page.

  3. #3
    Join Date
    Jul 2009
    Location
    Serbia
    Posts
    125
    I delete all whmcs files from old version 4.0.0 and upload new 4.1.2

  4. #4
    Join Date
    Aug 2008
    Location
    Ashburn, VA
    Posts
    99
    Yeah but there is still a database that has all the information in it. what control panel do you have? cPanel?

  5. #5
    Join Date
    Jul 2009
    Location
    Serbia
    Posts
    125
    yes whm/cpanel

  6. #6
    Join Date
    Aug 2008
    Location
    Ashburn, VA
    Posts
    99
    You should open up the MySQL database wizard and make a new user and database and then reinstall on that.

  7. #7
    Join Date
    Jul 2009
    Location
    Serbia
    Posts
    125
    But i have 150 users.with that action i will delete all.

  8. #8
    Join Date
    Aug 2008
    Location
    Ashburn, VA
    Posts
    99
    hm. i see. Have you opened a WHMCS support ticket? or posted on their forums? they would know more about it them me/the community here.

  9. #9
    Join Date
    May 2009
    Posts
    50
    I second WebCave - open a ticket with whmcs support. Matt and his team will get you sorted out. I wouldnt start deleting things until they tell you too.

  10. #10
    Join Date
    Aug 2008
    Location
    Ashburn, VA
    Posts
    99
    Yes matt is very helpful he has helped me out numerous times. probably should have suggested that first. Hope you get things working out for you

  11. #11
    Try removing the install folder and accessing the admin area and changing the client template to the correct client template.

  12. #12
    Join Date
    Jul 2009
    Location
    Serbia
    Posts
    125
    i send ticket to whmcs

  13. #13
    Join Date
    Aug 2008
    Location
    Ashburn, VA
    Posts
    99
    ok let us know how things go hope you get this resolved

Similar Threads

  1. WHMCS affiliates and landing pages
    By HostedPlanet in forum Hosting Software and Control Panels
    Replies: 1
    Last Post: 10-12-2009, 08:00 PM
  2. Replies: 0
    Last Post: 04-29-2009, 11:15 AM
  3. Online White Pages
    By MikeWalczak in forum Web Hosting Lounge
    Replies: 0
    Last Post: 02-28-2007, 11:39 PM
  4. Replies: 9
    Last Post: 05-26-2006, 08:49 AM
  5. Massive white space on web pages
    By Dauda in forum Web Design and Content
    Replies: 1
    Last Post: 09-21-2005, 11:12 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •