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) »
  • Import Error
Pages: [1]

Author Topic: Import Error  (Read 1199 times)

jchoi

  • I’m new here
  • *
  • Posts: 5
  • Karma: 0
  • CiviCRM version: 4.0.3
  • CMS version: Drupal
  • MySQL version: 5.1.54-msl-usrs-sure2-log
  • PHP version: 5.3.6
Import Error
November 04, 2011, 01:34:07 pm
I have been importing a series of CSV files and have been encountering one specific problem. For many of the CSV files that I have been importing (not all), I have been getting the same error message. The message says "Sorry. A non-recoverable error has occurred. DB Error: Already Exists."I tried breaking up rows into separate spread books and adjusting the dedupe rule. Nothing has worked so far. I would really appreciate any input.

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Import Error
November 04, 2011, 04:26:59 pm

can u try and delete all tables which match:

civicrm_import_job_*

and see if that fixes the issue

thanx

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

jchoi

  • I’m new here
  • *
  • Posts: 5
  • Karma: 0
  • CiviCRM version: 4.0.3
  • CMS version: Drupal
  • MySQL version: 5.1.54-msl-usrs-sure2-log
  • PHP version: 5.3.6
Re: Import Error
November 07, 2011, 09:49:06 am
I'm trying to research what a "table" is exactly, but I am not exactly sure. So how would I exactly go about deleting tables?

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: Import Error
November 07, 2011, 09:51:22 am
"Table" here refers to a MySQL table. Probably your host provides phpMyAdmin. You will need to go to the phpMyAdmin page and select your CiviCRM database and then find the tables in question. Then there will be an option somewhere to DROP each table. This you must do one by one.
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.

jchoi

  • I’m new here
  • *
  • Posts: 5
  • Karma: 0
  • CiviCRM version: 4.0.3
  • CMS version: Drupal
  • MySQL version: 5.1.54-msl-usrs-sure2-log
  • PHP version: 5.3.6
Re: Import Error
November 07, 2011, 11:17:49 am
Thank you guys for your great feedback so far. But I am still having trouble. Is there a way to check whether my host provides phpMyAdmin? I am not sure where and how I can access it. Sorry about the continuing trouble.

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: Import Error
November 07, 2011, 11:19:40 am
If they gave you a control panel, look there. If not, I would say you should ask them.
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) »
  • Import Error

This forum was archived on 2017-11-26.