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.
Activity
Paul Phillips
created issue -
Paul Phillips
made changes -
| Field | Original Value | New Value |
|---|---|---|
| Fix Version/s | 5.10.0-b2 [ 11914 ] |
Paul Phillips
made changes -
| Rank | Ranked higher |
Paul Phillips
made changes -
| Rank | Ranked lower |
Paul Phillips
made changes -
| 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. |
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. |
| Sprint | 5.11.0 Sprint 1 [ 194 ] |
| Rank | Ranked higher |
| Sprint | 5.11.0 Sprint 1 [ 194 ] | 5.10.0 Sprint 9 [ 198 ] |
| Rank | Ranked higher |
| Assignee | Abdy Franco [ abdy ] |
| Status | Open [ 1 ] | In Progress [ 3 ] |
| Remaining Estimate | 0 minutes [ 0 ] | |
| Time Spent | 2 hours, 4 minutes [ 7440 ] | |
| Worklog Id | 16916 [ 16916 ] |
| Status | In Progress [ 3 ] | In Review [ 5 ] |
| Resolution | Fixed [ 1 ] |
| Resolution | Fixed [ 1 ] | |
| Status | In Review [ 5 ] | Reopened [ 4 ] |
| Time Spent | 2 hours, 4 minutes [ 7440 ] | 3 hours, 4 minutes [ 11040 ] |
| Worklog Id | 16937 [ 16937 ] |
| Status | Reopened [ 4 ] | In Review [ 5 ] |
| Resolution | Fixed [ 1 ] |
| Status | In Review [ 5 ] | Closed [ 6 ] |
Let's just update support_tickets.code to support a varchar(128). Doesn't break anything and maybe useful in the future