CRM-9079 csv import: truncate header row field lengths if they exceed mysql limits

          Details

          • Type: Bug
          • Status: Done/Fixed
          • Priority: Minor
          • Resolution: Fixed/Completed
          • Affects Version/s: 3.4.7, 4.0.7
          • Fix Version/s: 4.1.0
          • Component/s: Core CiviCRM
          • Labels:
            None

            Description

            MySQL limits field name lengths to 64. Our CSV importer converts the header row to field names for the purpose of the temp table, and currently crashes if the field name exceeds the MySQL name limit.

            The attached patch truncates the column name if it will exceed the limit.

              Attachments

                Activity

                [CRM-9079] csv import: truncate header row field lengths if they exceed mysql limits
                There are no comments yet on this issue.

                  People

                  • Assignee:
                    Donald A. Lobo
                    Reporter:
                    Brian Shaughnessy

                    Dates

                    • Created:
                      Updated:
                      Resolved: