Details
-
Type: Bug
-
Status: Closed
-
Priority: Major
-
Resolution: Fixed
-
Affects Version/s: 4.6.0
-
Fix Version/s: 4.7.1
-
Component/s: Staff Interface
-
Labels:None
Description
tbltickets.title in WHMCS is a text field. support_tickets.summary is varchar 255 in Blesta. An error occurs when a support ticket title/summary in WHMCS is larger than 255 characters.
[1] => importSupportTickets: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'summary' at row 1 on line 196
To find these records, we can run this query on the WHMCS database:
SELECT * FROM tbltickets WHERE (LENGTH(`title`) > '255')
What we should do in Blesta is truncate tbltickets.title to 255 characters before inserting it into Blesta.