Ce site est optimisé pour être consulté depuis un navigateur moderne dans lequel JavaScript est activé.

Invalid column count dans CSV input sur line 1 Erreur

ayi

I’m trying to get a “.csv” file onto an SQL database with phpMyAdmin. However, whenever I import it, I get the error: Invalid column count in CSV input on line 1. 
I’ve spent all day playing around with different options to try and get it to work but with no avail. There are exactly 47 columns in my .csv file. I have created 47 columns in my SQL table. The names however aren’t exactly the same as the ones in the file. Whenever I import, it keeps giving me that error. 
Any help would be greatly appreciated! 
_Carpetfizz 
One thing I thought might be causing the problem was that the first column isn’t named anything in my excel document. Could this be causing an issue?
EDIT 12:30AM: phpMyAdmin is already the latest version available, via (apt-get install phpmyadmin) (phpmyadmin is already latest version)
<a href="http://pastebin.com/jTf67nsj" rel="noopener nofollow ugc">Here</a> is the .csv file, if that helps.
<hr>
Source : <a href="http://pastebin.com/jTf67nsj" rel="noopener nofollow ugc">Stack Overflow</a>

ayi_2

If your DB table already exists and you do NOT want to include all the table’s columns in your CSV file, then when you run PHP Admin Import, you’ll need fill in the Column Names field in the Format-Specific Options for CSV - Shown here at the bottom of the following screenshot.
In summary:
<ul>
<li>
Choose a CSV file
</li>
<li>
Set the Format to CSV
</li>
<li>
Fill in the Column Names field with the names of the columns in your CSV
</li>
<li>
If your CSV file has the column names listed in row 1, set “Skip this number of queries (for SQL) or lines (for other formats), starting from the first one” to 1
</li>
</ul>