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 Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • Get this error on importing contacts (yes even on the demo site ( -:)
Pages: [1]

Author Topic: Get this error on importing contacts (yes even on the demo site ( -:)  (Read 959 times)

alfred_nutile

  • Ask me questions
  • ****
  • Posts: 464
  • Karma: 14
    • River Valley Tech Collective
Get this error on importing contacts (yes even on the demo site ( -:)
August 10, 2009, 08:53:53 am
DB Error: syntax error

Database Error Code: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'group text, full_name text, first_name text, last_name text, company text, addre' at line 1, 1064


Seems like this is the first time I have tried import "Skip" for a setting.
So it would be
Individuals
First row Labels
Skip if exist
No Date

I even made a dummy file with 5 rows of dummy emails only and it happens.

Else it works if I choose update.

2.25 posting bug as well but trying to get help.

Kiran Jagtap

  • Ask me questions
  • ****
  • Posts: 533
  • Karma: 51
Re: Get this error on importing contacts (yes even on the demo site ( -:)
August 10, 2009, 09:16:42 am
I just tried sample import on http://demo.civicrm.org/
with Individual contact,  only emails and having 'Skip' mode and it seems to be working fine for me.

.csv is like
 "Email"
"test1@civicrm.org"
"test2@civicrm.org"
"test3@civicrm.org"
"test4@civicrm.org"
"test5@civicrm.org"

and contact seems to be successfully imported.

would be good if you attach u r sample import file.

kiran
You Are Designed To Choose... Defined By Choice.

alfred_nutile

  • Ask me questions
  • ****
  • Posts: 464
  • Karma: 14
    • River Valley Tech Collective
Re: Get this error on importing contacts (yes even on the demo site ( -:)
August 10, 2009, 10:30:47 am
yup your right.
Funny I do not see anything in my files but I removed the header
"Email","Group","Full Name","First Name","Last Name","Company","Address","City","State","ZIP","Phone","Fax"
And it is moving along now.
Maybe cause it did not end in a ,?

Kiran Jagtap

  • Ask me questions
  • ****
  • Posts: 533
  • Karma: 51
Re: Get this error on importing contacts (yes even on the demo site ( -:)
August 10, 2009, 10:55:18 pm
Import process require column count should be equal for all records, We are skipping rows those don't match column count.
If you map header than header column count is consider as standard column count else first data row column count considered.

you might be interesting in related threads
http://issues.civicrm.org/jira/browse/CRM-4429
http://forum.civicrm.org/index.php/topic,7816.0.html

kiran
You Are Designed To Choose... Defined By Choice.

Kiran Jagtap

  • Ask me questions
  • ****
  • Posts: 533
  • Karma: 51
Re: Get this error on importing contacts (yes even on the demo site ( -:)
August 10, 2009, 11:21:12 pm
It seems like "Group" is the root cause,  since it is mysql reserved word and u used as header name.
so If we use any mysql reserve word as header name -> import will get break.

related issue is here : http://issues.civicrm.org/jira/browse/CRM-4881

kiran
« Last Edit: August 10, 2009, 11:39:14 pm by kiran »
You Are Designed To Choose... Defined By Choice.
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • Get this error on importing contacts (yes even on the demo site ( -:)

This forum was archived on 2017-11-26.