• 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.