Database error 1064 while importing emails

Once you've installed phpList Version 2... ask questions here!
Forum rules
Please help the volunteers to help you by supplying the version of phpList you are using, browser & version and if possible, a link to your phpList installation. This is for Version 2 of phpList (the orange one).

Database error 1064 while importing emails

Postby ramziddin » 1:02pm, Fri 30 Mar, 2007

Hi all

I was experimenting with importing emails with different values for attributes and get the folloiwing problem. My csv file contained the followings:

Email Extradata Name Send this user HTML emails
A@mail.com 1 A 1
B@mail.com 2 B 0
C@mail.com 3 C 1
... ... ... ...

(next column)

Country
France
Netherlands
Uzbekistan
...

I have checked and put correct delimiter and put a tick to show warnings. But while importing I am getting the following error message:

Database error 1064 while doing query 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 'data' at line 1

I haven't got any word like data in my file. But surprisingly it imported everything correcltly.

What may be the reason for this problem?
Is there any way to fix it?

Multo Gracio

Ramziddin
ramziddin
PL Nut
 
Posts: 31
Joined: 11:46am, Thu 01 Mar, 2007

Return to Question & Problems - after installing

Who is online

Users browsing this forum: Google [Bot] and 4 guests

cron