View Issue Details

IDProjectCategoryView StatusLast Update
0015421phpList 3 applicationSubscriber Importpublic29-04-10 05:48
ReporterMahyar Assigned To 
Status resolvedResolutionfixed 
Product Version2.10.8 
Target Version2.10.12Fixed in Version2.10.12 
Summary0015421: Importing CSV with multiple values for Checkboxgroup crashes with SQL Error
DescriptionI have a CSV file that I use to import users, the file contains the email, the first name, the last name, and several other single value fields in addition to the field (Course) that is causing the problem which is an attribute defined as a checkboxgroup.

I am trying to import users with multiple values for the course field separating them by ; and adding a space after it.

The user is imported along with all attributes but it crashes on the multi-value attribute Course.

I have added the importcsv to my installation: ref

But I get an error always

"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 '; CFA) and phplist_user_user_attribute.attributeid = 50' at line 4"

I have tried adding the option id and the option value, all fail with the same error, tried removing the space before the semi column, same issue.

I have attached the csv file for reference..

I have attached my CSV file
TagsNo tags attached.


related to 0012206 resolvedmichiel incorrect import of checkboxgroup attributes 


08-03-10 14:07


Morgan.csv (150 bytes)


19-04-10 19:13

administrator   ~0050926

this will be working in the next release, however, using , as the value separator, which means you have to import your file as a TAB delimited file.