Vox Populi(x) forum

Alexandria Book Library => Errori (Bugs) => Topic started by: SamoanOnion on 22 October 2013, 21:07:44

Title: Importing a CSV
Post by: SamoanOnion on 22 October 2013, 21:07:44
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)
Title: Re: Importing a CSV
Post by: federica on 10 December 2013, 10:55:21
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?