CiviCRM Community Forums (archive)

I am trying to import a couple new members into our database and am receiving the error below.  Last time I imported data there were no issues, and I haven't changed anything to the best of my knowledge.  I haven't got a clue as to what the above error means or how to resolve it, but I need to do so ASAP.  Any & all help will be much appreciated.

Thanks!

Database Error Code: Identifier name 'pkqlmimetypeapplicationvndoasisopendocumentspreadsheetpkqconfigurationsstatusbarpkqconfigurationsacc' is too long, 1059
Additional Details:

Array
(
    [callback] => Array
        (
           

• => CRM_Core_Error
[1] => handle
        )

   

Code: [Select]

=> a515ac9c2796ca0e23adbe92c68fc9fc
    [message] => DB Error: a515ac9c2796ca0e23adbe92c68fc9fc
    [mode] => 16
    [debug_info] => CREATE TABLE civicrm_import_job_8aaccd72fba0e2de9b4c6aaea7d40f24 (`pkqlmimetypeapplicationvndoasisopendocumentspreadsheetpkqconfigurationsstatusbarpkqconfigurationsacceleratorcurrentxmlpkpkqconfigurationsfloaterpkqconfigurationspopupmenupkqconfigurationsprogressbarpkqconfigurationsmenubarpkqconfigurationstoolbarpkqconfigurationsimagesbitmapspkqcontentxmlrusuiyg` text) ENGINE=InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci [nativecode=1059 ** Identifier name 'pkqlmimetypeapplicationvndoasisopendocumentspreadsheetpkqconfigurationsstatusbarpkqconfigurationsacc' is too long]
    [type] => DB_Error
    [user_info] => CREATE TABLE civicrm_import_job_8aaccd72fba0e2de9b4c6aaea7d40f24 (`pkqlmimetypeapplicationvndoasisopendocumentspreadsheetpkqconfigurationsstatusbarpkqconfigurationsacceleratorcurrentxmlpkpkqconfigurationsfloaterpkqconfigurationspopupmenupkqconfigurationsprogressbarpkqconfigurationsmenubarpkqconfigurationstoolbarpkqconfigurationsimagesbitmapspkqcontentxmlrusuiyg` text) ENGINE=InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci [nativecode=1059 ** Identifier name 'pkqlmimetypeapplicationvndoasisopendocumentspreadsheetpkqconfigurationsstatusbarpkqconfigurationsacc' 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_8aaccd72fba0e2de9b4c6aaea7d40f24 (`pkqlmimetypeapplicationvndoasisopendocumentspreadsheetpkqconfigurationsstatusbarpkqconfigurationsacceleratorcurrentxmlpkpkqconfigurationsfloaterpkqconfigurationspopupmenupkqconfigurationsprogressbarpkqconfigurationsmenubarpkqconfigurationstoolbarpkqconfigurationsimagesbitmapspkqcontentxmlrusuiyg` text) ENGINE=InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci [nativecode=1059 ** Identifier name 'pkqlmimetypeapplicationvndoasisopendocumentspreadsheetpkqconfigurationsstatusbarpkqconfigurationsacc' is too long]"]
)[/quote]

check the first row of your csv file. Seems like it might have some unneeded headers and hence giving you that error, as it tries to create a column with that name

lobo

That's not it...

I re-created the header row to ensure nothing was corrupted or unneeded some how.  I attempted the import again and this time it worked - but there was a duplicate, and as I had checked "skip duplicates", I went back to try again using "update" this time instead of "skip".  Now the same file (has not been opened or modified in any way since prior to the first semi-successful attempt) is throwing the same error as before.

Any other ideas?