Importing a CSV

Started by SamoanOnion, 22 October 2013, 21:07:44

Previous topic - Next topic
A financial contribution is greatly appreciated as a support, to help us to keep live the project.
If you like this project you can donate some piece of BitCoin to this address: bc1qy5tgq6tvrckac2a57unxvqcnxamrvhduve9sj9

SamoanOnion

hello, I'm trying to import a CSV file, but I keep getting the following error, any help would be much appreciated...



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 '11)' at line 1 SQL=INSERT INTO joomla25_abbook (title, subtitle, alias, ideditor, price, pag, user_id, created_by_alias, description, image, file, year, idlocation, idlibrary, vote, numvote, hits, published, qty, isbn, approved, userid, url, url_label, dateinsert, catalogo, checked_out, checked_out_time, access, metakey, metadesc, note, language, editedby, catid) VALUES (,11)
SQL =

INSERT INTO #__abbook  (title, subtitle, alias, ideditor, price, pag, user_id, created_by_alias, description, image,  file, year, idlocation, idlibrary, vote, numvote, hits, published, qty, isbn, approved, userid, url, url_label, dateinsert, catalogo, checked_out, checked_out_time, access, metakey, metadesc, note, language, editedby, catid) VALUES (,11)

JDatabase::query: SQL Error DB function failed with error number 1064
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 '11)' at line 1 SQL=INSERT INTO joomla25_abbook (title, subtitle, alias, ideditor, price, pag, user_id, created_by_alias, description, image, file, year, idlocation, idlibrary, vote, numvote, hits, published, qty, isbn, approved, userid, url, url_label, dateinsert, catalogo, checked_out, checked_out_time, access, metakey, metadesc, note, language, editedby, catid) VALUES (,11)

A financial contribution is greatly appreciated as a support, to help us to keep live the project.
If you like this project you can donate some piece of BitCoin to this address: bc1qy5tgq6tvrckac2a57unxvqcnxamrvhduve9sj9

federica

Hi SamoanOnion,
perhaps every first field of csv rows are empty, check your csv file.
Can you post the first row of your csv file?
Al mondo ci sono 10 tipi di persone, quelli che hanno capito il codice binario e quelli che non l'hanno capito.
Informatizzati [url="https://informatizzati.org"]https://informatizzati.org[/url]
Stacca la spina [url="https://disconnessi.org"]https://disconnessi.org[/url]