Details
Bug
Major
Description
When importing from WHMCS, the following error is sometimes encountered:
importSupportTickets
-----------------
SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column 'code' at row 1
This has to do with the tbltickets.tid column, which contains ticket numbers in WHMCS being a VARCHAR(128). The corresponding table in Blesta, tickets.code is INT(10).
WHMCS tickets can be all numeric, but sometimes they may contain a "-" or other characters, as it is user defined.
We need to somehow cast/convert VARCHAR to INT, in such a way that it should not generate duplicates.
A simple solution would be to use the tbltickets.id value as the code instead, though all tickets would have a different ticket number than previously.
Let's just update support_tickets.code to support a varchar(128). Doesn't break anything and maybe useful in the future