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

            Hide
            Permalink
            admin Paul Phillips added a comment -

            This is also an issue for tblemailtemplates.subject / emails.subject

            Maybe we should truncate many other fields where whmcs uses text and we use varchar

            Show
            admin Paul Phillips added a comment - This is also an issue for tblemailtemplates.subject / emails.subject Maybe we should truncate many other fields where whmcs uses text and we use varchar

              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