Migration WHMCS to Blesta

[visualwebtechnologies]

i try to migration whmcs to blesta after fill all details 

 

shown white blank screen 

 

Please help us 

[Blesta Addons]

1 hour ago, visualwebtechnologies said:

i try to migration whmcs to blesta after fill all details 

 

shown white blank screen 

 

Please help us 

Enable error reporting in blesta config file, then the error will be shown for you.

 

[visualwebtechnologies]

SQLSTATE[HY000] [2005] Unknown MySQL server host  error shown

[visualwebtechnologies]

The import completed but the following errors ocurred:

importContacts: Undefined index: clients on line 427

importTaxes: There is already an active transaction on line 231

importCurrencies: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'code' at row 1 on line 196

importInvoices: There is already an active transaction on line 231

importTransactions: There is already an active transaction on line 231

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

importPackageOptions: There is already an active transaction on line 231

importServices: There is already an active transaction on line 231

importSupportDepartments: There is already an active transaction on line 231

importSupportTickets: There is already an active transaction on line 231

importMisc: There is already an active transaction on line 231

4 hours ago, Blesta Addons said:

Enable error reporting in blesta config file, then the error will be shown for you.

 

 

[Paul]

4 hours ago, visualwebtechnologies said:

importCurrencies: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'code' at row 1 on line 196

Do you have any currencies in whmcs that are longer than 3 characters? currencies.code is limited to 3 characters in Blesta, under the standard, currencies should be 3 characters.. like EUR, USD, CAD, etc. Looks like you may have one that is longer than this in your whmcs.

[visualwebtechnologies]

Ok after import somr error i share you before.. Onky clients import no invoices imoort, no transaction, anf no packages import on blesta what is that please fix

[Paul]

17 minutes ago, visualwebtechnologies said:

Ok after import somr error i share you before.. Onky clients import no invoices imoort, no transaction, anf no packages import on blesta what is that please fix

When an error occurs, it's not able to complete the import. It's important to correct the issue, re-import on your fresh  Blesta database (why we recommend backing up Blesta after installing, then restore your database backup before attempting another import). I would also recommend importing from a cloned WHMCS database so that you can make adjustments to your database. For example, one error was a currency code longer than 3 characters. You'd need to modify any currencies longer than 3 characters to be 3 characters, then retry the import. Same goes for any contacts that are not associated with any clients.

[visualwebtechnologies]

What about invoices, transactions details, packages plan not import 

 

I was 2 times blesta fresh install then import same error 

[Paul]

2 hours ago, visualwebtechnologies said:

What about invoices, transactions details, packages plan not import 

 

I was 2 times blesta fresh install then import same error 

You must correct the error that you got, then re-import. If that is the only error, then the import will be able to continue with importing all of those other things.

[locthb]

- Do not been able to import the domain list. 

- Utf8 error.

[Paul]

What was the complete error and the output?