Uploaded image for project: 'CiviCRM'
  1. CiviCRM
  2. CRM-9239

Import crash on long phone names

    Details

    • Type: Bug
    • Status: Done/Fixed
    • Priority: Critical
    • Resolution: Won't Fix
    • Affects Version/s: 4.0.5
    • Fix Version/s: Unscheduled
    • Component/s: Core CiviCRM
    • Labels:
      None
    • Documentation Required?:
      None
    • Funding Source:
      Needs Funding

      Description

      Was importing a long list. In the middle, one contact had for phone:
      ""+1 (030) 5834334350 (call. from abroad)"
      ie. a super long string, longer than the allowed size.

      If generated a DB error and stopped the import

      1) if should either truncate or add it to the not imported contacts, but not crash
      2) on the import, we asked to add the contacts to the group. As this is done as the last step of the process (presumably) there isn't any way to find the contacts imported in error

      Is there any way to undo the partial import in this case?

      More generally, it seems to be the same issue for api or the import (when something is too long it DB error) should be add the tests in the DAO? or find a mode on mysql that truncate instead of crashing?

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              xavier xavier dutoit
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: