View Issue Details

IDProjectCategoryView StatusLast Update
0015670phplist applicationSubscriber Importpublic01-02-12 14:22
Reporterdubwise259 
PrioritynormalSeverityminorReproducibilityalways
Status resolvedResolutionfixed 
PlatformLinuxOSUbuntu ServerOS Version11.04
Product Version2.10.16 
Target VersionFixed 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 :
http://....your_phplist/admin/?page=import2&confirm=yes
TagsNo tags attached.

Activities

support

01-02-12 12:36

administrator   ~0051442


can you upload an example import file to reproduce this?

dubwise259

01-02-12 14:10

reporter  

test.csv (31 bytes)

dubwise259

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.

support

01-02-12 14:22

administrator   ~0051447

Can replicate the error on http://demo.phplist.com/lists/admin/?page=import2 which is 2.10.17

but it is ok on http://dev.phplist.com/lists/admin/?page=import2&confirm=yes which is trunk