Jump to content
  • 0

Errors Trying to import WHMCS 7.5


Question

Posted

I am trying to migrate to Blesta version 5.1 from WHMCS 7.5 and here is the error I get from the Import Manager:

 

decrypted 0 values using WHMCS' custom algorithm
decrypt took: 0 seconds
total time took: 140.9774 seconds
Array
(
    [error] => Array
        (
            [0] => 
            [1] => importClients: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'root_whmcs.tblcreditcards' doesn't exist on line 196
            [2] => importContacts: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '* FROM `tblcreditcards`, `tblcontacts` INNER JOIN `tblpaymethods` ON `tblpaymeth' at line 1 on line 196
            [3] => importTaxes: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '*, * FROM `tblcreditcards`, `tblcontacts`, `tbltax` INNER JOIN `tblpaymethods` O' at line 1 on line 196
            [4] => importCurrencies: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '*, *, * FROM `tblcreditcards`, `tblcontacts`, `tbltax`, `tblcurrencies` INNER JO' at line 1 on line 196
            [5] => importInvoices: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '*, *, *, * FROM `tblcreditcards`, `tblcontacts`, `tbltax`, `tblcurrencies`, `tbl' at line 1 on line 196
            [6] => importTransactions: SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens on line 196
            [7] => importPackages: SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens on line 196
            [8] => importPackageOptions: SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens on line 196
            [9] => importServices: SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens on line 196
            [10] => importSupportDepartments: SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens on line 196
            [11] => importSupportTickets: SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens on line 196
            [12] => importAffiliates: SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens on line 196
            [13] => importMisc: SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens on line 196

2 answers to this question

Recommended Posts

  • 0
Posted
SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect string value: '\xE1\xBA' for column `tocdov_blesta`.`contacts`.`state` at row 1
SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect string value: '\xC3' for column `tocdov_blesta`.`contacts`.`state` at row 1
SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect string value: '\xE1' for column `tocdov_blesta`.`contacts`.`state` at row 1
SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect string value: '\xC3' for column `tocdov_blesta`.`contacts`.`state` at row 1
SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect string value: '\xC3' for column `tocdov_blesta`.`contacts`.`state` at row 1


decrypted 0 values using WHMCS' custom algorithm
decrypt took: 0 seconds
total time took: 209.9862 seconds
Array
(
    [error] => Array
        (
            [0] => The import completed but the following errors ocurred:
            [1] => importContacts: SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect string value: '\xE1\xBB' for column `tocdov_blesta`.`contacts`.`state` at row 1 on line 196
            [2] => importTaxes: There is already an active transaction on line 231
            [3] => importCurrencies: SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens on line 196
            [4] => importInvoices: There is already an active transaction on line 231
            [5] => importTransactions: There is already an active transaction on line 231
            [6] => importPackages: SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens on line 196
            [7] => importServices: There is already an active transaction on line 231
            [8] => importSupportDepartments: There is already an active transaction on line 231
            [9] => importSupportTickets: There is already an active transaction on line 231
            [10] => importAffiliates: There is already an active transaction on line 231
            [11] => importMisc: There is already an active transaction on line 231
        )

)
On version 5.1.1 I still can't import whmcs into blesta.

Please sign in to comment

You will be able to leave a comment after signing in



Sign In Now
×
×
  • Create New...