Import csv file does not work
-
Hi there,
I formatted my csv file and it still does not import. I get this message:
Database Error: 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 ‘WHERE id = 4’ at line 1
I tried with a single line of data with these columns:
first_name,last_name,phone,email,membership_status,gardening_experience,volunteer___administration,volunteer___community_events,volunteer___gardening,volunteer___gardening_expertise,volunteer___garden_of_lights,volunteer___operations,volunteer___supplier,message,mailing_list,approved,membership,relevant_notes_and_past_data,id
“firstname”,”lastname”,””,”[email protected]”,””,””,””,””,””,””,””,””,””,””,””,””,””,”market garden plant sale production “,”3”
Anyone has a clue how to solve the issue?
Serge
- The topic ‘Import csv file does not work’ is closed to new replies.