NOTE:: Before reporting an issue, make sure you are running the latest version, currently 3.3.1

View Issue Details Jump to Notes ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0015670phplist applicationSubscriber Importpublic30-01-12 17:1301-02-12 14:22
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.
Attached Filescsv file icon test.csv [^] (31 bytes) 01-02-12 14:10

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
support (administrator)
01-02-12 12:36

can you upload an example import file to reproduce this?
dubwise259 (reporter)
01-02-12 14:12

yes of course but it's a simple CSV file with only 1 column (email) and 1 user.
support (administrator)
01-02-12 14:22

Can replicate the error on [^] which is 2.10.17

but it is ok on [^] which is trunk

Copyright © 2000 - 2017 MantisBT Team
Powered by Mantis Bugtracker