Uploaded image for project: 'Blesta Core'
  1. Blesta Core
  2. CORE-3253

Import Manager: WHMCS Data too long for column 'summary'

    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.

        Activity

          People

          • Assignee:
            jonathan Jonathan Reissmueller
            Reporter:
            admin Paul Phillips
          • Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:
              Fix Release Date:
              24/Sep/19

              Time Tracking

              Estimated:
              Original Estimate - Not Specified
              Not Specified
              Remaining:
              Remaining Estimate - 0 minutes
              0m
              Logged:
              Time Spent - 5 hours, 32 minutes
              5h 32m

                Agile