Jump to content
  • 0

Migration WHMCS to Blesta


visualwebtechnologies

Question

10 answers to this question

Recommended Posts

  • 0

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.

 

 

Link to comment
Share on other sites

  • 0
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.

Link to comment
Share on other sites

  • 0
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.

Link to comment
Share on other sites

  • 0
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.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...