CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site

This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Import (Moderator: Yashodha Chaku) »
  • Database Error Code: Identifier name
Pages: [1]

Author Topic: Database Error Code: Identifier name  (Read 881 times)

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Database Error Code: Identifier name
August 22, 2011, 08:18:08 am
When trying to import a CSV file into a Drupal 7 CiviCRM 4.0.5 site I get:

Quote
(
    [callback] => Array
        (
           
  • => CRM_Core_Error
  • [1] => handle
            )

       
[message] => DB Error: unknown error
    [mode] => 16
    [debug_info] => CREATE TABLE civicrm_import_job_e677af23a7feec76a80f310e38a5700d (`mill_idconstituent_typegraduation_year_degree_typeccccc_tagnotesextrel_core_titlenickname_firstbirth_datebirth_countryspouse_sortnamespouse_prefyearstreet_addressadditional_address_additional_address_citystatezipcountryaddress_typeaddress_phonecompleteaddress_phone_usextrel_regioncommunication_preferencesjob_titlecompanynameextrel_descriptors_emailadditional_emailprospect_managername_titlefirstnamemiddlenamelastnamesuffixadvance_idexternal_id` text) ENGINE=InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci [nativecode=1059 ** Identifier name 'mill_idconstituent_typegraduation_year_degree_typeccccc_tagnotesextrel_core_titlenickname_firstbirt' is too long]
    [type] => DB_Error
    [user_info] => CREATE TABLE civicrm_import_job_e677af23a7feec76a80f310e38a5700d (`mill_idconstituent_typegraduation_year_degree_typeccccc_tagnotesextrel_core_titlenickname_firstbirth_datebirth_countryspouse_sortnamespouse_prefyearstreet_addressadditional_address_additional_address_citystatezipcountryaddress_typeaddress_phonecompleteaddress_phone_usextrel_regioncommunication_preferencesjob_titlecompanynameextrel_descriptors_emailadditional_emailprospect_managername_titlefirstnamemiddlenamelastnamesuffixadvance_idexternal_id` text) ENGINE=InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci [nativecode=1059 ** Identifier name 'mill_idconstituent_typegraduation_year_degree_typeccccc_tagnotesextrel_core_titlenickname_firstbirt' is too long]
    [to_string] => [db_error: message="DB Error: unknown error" code=-1 mode=callback callback=CRM_Core_Error::handle prefix="" info="CREATE TABLE civicrm_import_job_e677af23a7feec76a80f310e38a5700d (`mill_idconstituent_typegraduation_year_degree_typeccccc_tagnotesextrel_core_titlenickname_firstbirth_datebirth_countryspouse_sortnamespouse_prefyearstreet_addressadditional_address_additional_address_citystatezipcountryaddress_typeaddress_phonecompleteaddress_phone_usextrel_regioncommunication_preferencesjob_titlecompanynameextrel_descriptors_emailadditional_emailprospect_managername_titlefirstnamemiddlenamelastnamesuffixadvance_idexternal_id` text) ENGINE=InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci [nativecode=1059 ** Identifier name 'mill_idconstituent_typegraduation_year_degree_typeccccc_tagnotesextrel_core_titlenickname_firstbirt' is too long]"]
)

I do not see how I can proceed with this. :(
CiviHosting and CiviOnline -- The CiviCRM hosting experts, since 2007

See here for the official: What to do if you think you've found a bug.

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Import (Moderator: Yashodha Chaku) »
  • Database Error Code: Identifier name

This forum was archived on 2017-11-26.