Author Topic: Importing a CSV  (Read 1578 times)

SamoanOnion

  • Guest
Importing a CSV
« 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)

Offline federica

  • Amministratore
  • Delfino
  • *****
  • Posts: 1.003
  • Karma: +1/-0
Re: Importing a CSV
« Reply #1 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?
Al mondo ci sono 10 tipi di persone, quelli che hanno capito il codice binario e quelli che non l'hanno capito.
http://www.antivirushelp.it
stacca la spina!