Uploaded image for project: 'CiviCRM'
  1. CiviCRM
  2. 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

                  People

                  • Assignee:
                    lobo Donald A. Lobo
                    Reporter:
                    lcdweb Brian Shaughnessy
                  • Votes:
                    0 Vote for this issue
                    Watchers:
                    0 Start watching this issue

                    Dates

                    • Created:
                      Updated:
                      Resolved: