Whmcs 6.x To Blesta

[coderpro12]

Hi

 

Im getting the following error:

 

importMisc
-----------------
decrypted 0 values using WHMCS' custom algorithm
decrypt took: 0 seconds
total time took: 0.5836 seconds
Array
(
[error] => Array
(
[0] => The import completed but the following errors ocurred:
[1] => importContacts: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'client_id' cannot be null on line 124
[2] => importTaxes: There is already an active transaction on line 163
[3] => importCurrencies: SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens on line 124
[4] => importInvoices: There is already an active transaction on line 163
[5] => importTransactions: There is already an active transaction on line 163
[6] => importPackages: SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens on line 124
[7] => importPackageOptions: There is already an active transaction on line 163
[8] => importServices: There is already an active transaction on line 163
[9] => importSupportDepartments: There is already an active transaction on line 163
[10] => importSupportTickets: There is already an active transaction on line 163
[11] => importMisc: There is already an active transaction on line 163
)

 

When i run the importer i have followed the following guide https://licensecart.com/whmcs-blesta

 

Thanks 

[Tyson]

It sounds like your WHMCS database may not have a valid userid for every contact from tblcontacts. This value becomes the client ID in Blesta, so one must exist. You may need to update that database table to ensure each record contains a non-null userid.

[coderpro12]

Hello,

 

I was able to fix the contacts issues now im getting this error 

 

 

The import completed but the following errors ocurred:

importInvoices: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'client_id' cannot be null on line 124

importTransactions: There is already an active transaction on line 163

importPackages: SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens on line 124

importPackageOptions: There is already an active transaction on line 163

importServices: There is already an active transaction on line 163

importSupportDepartments: There is already an active transaction on line 163

importSupportTickets: There is already an active transaction on line 163

importMisc: There is already an active transaction on line 163

[Tyson]

It looks like the same issue is occurring now for invoices. Each userid in tblinvoices should be non-null as well.