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

Database Error: Identifier name is too long while importing contacts

    Details

    • Type: Bug
    • Status: Done/Fixed
    • Priority: Major
    • Resolution: Won't Fix
    • Affects Version/s: 3.4.0
    • Fix Version/s: Unscheduled
    • Component/s: Core CiviCRM
    • Labels:
      None

      Description

      While importing contacts from a csv file I get the following Database error message:

      DB Error: a515ac9c2796ca0e23adbe92c68fc9fc
      Error Details
      Database Error Code: Identifier name 'receipt_datefrnamnefternamnnotetransaction_idemail_match_to_contacttilltotal_amountavgiftfeenet_amou' is too long, 1059
      Additional Details:

      Array
      (
      [callback] => Array
      (
      [0] => CRM_Core_Error
      [1] => handle
      )

      [code] => a515ac9c2796ca0e23adbe92c68fc9fc
      [message] => DB Error: a515ac9c2796ca0e23adbe92c68fc9fc
      [mode] => 16
      [debug_info] => CREATE TABLE civicrm_import_job_6a841fd43c5aed055c84f37c7e928500 (`receipt_datefrnamnefternamnnotetransaction_idemail_match_to_contacttilltotal_amountavgiftfeenet_amountsaldocurrencyegen_referensbeskrivningcontribution_typecontribution_sourcepayment_instrumentreceive_datecontribution_statusthank_you_send` text) ENGINE=InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci [nativecode=1059 ** Identifier name 'receipt_datefrnamnefternamnnotetransaction_idemail_match_to_contacttilltotal_amountavgiftfeenet_amou' is too long]
      [type] => DB_Error
      [user_info] => CREATE TABLE civicrm_import_job_6a841fd43c5aed055c84f37c7e928500 (`receipt_datefrnamnefternamnnotetransaction_idemail_match_to_contacttilltotal_amountavgiftfeenet_amountsaldocurrencyegen_referensbeskrivningcontribution_typecontribution_sourcepayment_instrumentreceive_datecontribution_statusthank_you_send` text) ENGINE=InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci [nativecode=1059 ** Identifier name 'receipt_datefrnamnefternamnnotetransaction_idemail_match_to_contacttilltotal_amountavgiftfeenet_amou' is too long]
      [to_string] => [db_error: message="DB Error: a515ac9c2796ca0e23adbe92c68fc9fc" code=0 mode=callback callback=CRM_Core_Error::handle prefix="" info="CREATE TABLE civicrm_import_job_6a841fd43c5aed055c84f37c7e928500 (`receipt_datefrnamnefternamnnotetransaction_idemail_match_to_contacttilltotal_amountavgiftfeenet_amountsaldocurrencyegen_referensbeskrivningcontribution_typecontribution_sourcepayment_instrumentreceive_datecontribution_statusthank_you_send` text) ENGINE=InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci [nativecode=1059 ** Identifier name 'receipt_datefrnamnefternamnnotetransaction_idemail_match_to_contacttilltotal_amountavgiftfeenet_amou' is too long]"]
      )

      The header line of the csv file is:
      "Receipt date";"Förnamn";"Efternamn";"Note";"Transaction ID";"Email (match to contact)";"Till";"total amount";"avgift";"fee";"net amount";"Saldo";"currency";"Egen Referens";"Beskrivning";"Contribution type";"contribution source";"Payment instrument";"Receive Date";"Contribution Status";"Thank you send"

        Attachments

          Activity

            People

            • Assignee:
              lobo Donald A. Lobo
              Reporter:
              prolineserver Holger Motzkau
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: