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"