View original (French)

Invalid number of fields in CSV at line 1

vacances2000 Posted messages 3 Status Member -  
Nhay Posted messages 838 Registration date   Status Member Last intervention   -
Hello,
I'm trying to import a CSV file into a database but I keep getting the error above every time. Here are some examples of lines:

"Andorra";"https://www.icloud.com/";"Yes"
"Aruba";"https://www.icloud.com/";"No"
"Australia";"https://www.icloud.com/";"No"

I thought I had everything right but unfortunately... Who can help me???

Thank you

Jonathan

2 answers

  1.
    Nhay Posted messages 838 Registration date   Status Member Last intervention   126
     
    It seems that he is trying to import from phpMyAdmin, your error in any case is about an incorrect number of fields, your database is expecting 4 and you are providing only 3.
    Check if you can specify the fields, or if your file does not have extra fields.
    0