Versions Compared

Old Version 28

changes.mady.by.user Paul Phillips

Saved on

compared with

New Version Current

changes.mady.by.user Paul Phillips

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Tip
titleDatabase Collation

Often times WHMCS has mixed database collations and this can cause issues during import. For this reason we recommend:

  • Cloning your WHMCS database, and updating the collation for all tables to utf8mb4_unicode_ci.
  • Make sure Blesta is also utf8mb4 by going to Tools > Utilities. Updating Blesta from utf8 to utf8mb4 can be accomplished by clicking the "Update to utf8mb4" button. If the Description says "Database already supports utf8mb4" then the collation has already been updated.
  • Import from your cloned utf8mb4_unicode_ci WHMCS database.


Tip
titleTicket Numbers

Blesta uses an int(10) column for ticket codes. If you have any non-numeric characters in your ticket system in WHMCS, you can update them to match the internal ID to prevent any errors during import. Do this to a cloned copy of your WHMCS database, not your production copy.

Code Block
languagesql
UPDATE tbltickets SET tid = id;



Info

If you prefer, you can create a copy of your WHMCS database and import from that instead of your live system.

...