View Issue Details
|ID||Project||Category||View Status||Date Submitted||Last Update|
|0015670||phpList 3 application||Subscriber Import||public||30-01-12 17:13||01-02-12 14:22|
|Platform||Linux||OS||Ubuntu Server||OS Version||11.04|
|Target Version||Fixed in Version||2.11.6|
|Summary||0015670: Database error 1064 when selecting "Import of address data with differring and individual attributes"|
|Description||Fresh 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 Reproduce||Main 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 :
|Tags||No tags attached.|
can you upload an example import file to reproduce this?
test.csv (31 bytes)
||yes of course but it's a simple CSV file with only 1 column (email) and 1 user.|
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