View Issue Details

IDProjectCategoryView StatusLast Update
0015670phpList 3 applicationSubscriber Importpublic01-02-12 14:22
Reporterdubwise259 Assigned To 
Status resolvedResolutionfixed 
PlatformLinuxOSUbuntu ServerOS Version11.04
Product Version2.10.16 
Fixed in Version2.11.6 
Summary0015670: Database error 1064 when selecting "Import of address data with differring and individual attributes"
DescriptionFresh install phplist 2.10.17 / French language / UTF-8
PHP 5.3 / MySQL 5.1

Almost the same error as 0015465 but the error is slightly less detailed :

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 " at line 1

I've double-checked importcsv.php and I have no extra " near from confirm=yes nor reset=yes

Browser cache cleared.

Steps To ReproduceMain Page => Import => "Import of address data with differring and individual attributes"
Choose a CSV file (with only email attribute) with a new user which is not already in the database.
Error appears at this step :
TagsNo tags attached.



01-02-12 12:36

administrator   ~0051442

can you upload an example import file to reproduce this?


01-02-12 14:10


test.csv (31 bytes)   
test.csv (31 bytes)   


01-02-12 14:12

reporter   ~0051446

yes of course but it's a simple CSV file with only 1 column (email) and 1 user.


01-02-12 14:22

administrator   ~0051447

Can replicate the error on which is 2.10.17

but it is ok on which is trunk