Author Topic: Importing SQL Error  (Read 170 times)

Offline jerry110

  • Coccinella
  • *
  • Posts: 3
  • Karma: +0/-0
Importing SQL Error
« on: 21 July 2020, 22:15:53 »
Im using the template in the sample file they provide as a CSV here is the error:
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 '2)' at line 3

Vox Populi(x) forum

Importing SQL Error
« on: 21 July 2020, 22:15:53 »

Offline jerry110

  • Coccinella
  • *
  • Posts: 3
  • Karma: +0/-0
Re: Importing SQL Error
« Reply #1 on: 21 July 2020, 23:09:09 »
Here is the file im using: Made from the sample File..........(CSV)

Vox Populi(x) forum

Re: Importing SQL Error
« Reply #1 on: 21 July 2020, 23:09:09 »

Offline federica

  • Amministratore
  • Delfino
  • *****
  • Posts: 1.052
  • Karma: +1/-0
Re: Importing SQL Error
« Reply #2 on: 22 July 2020, 09:48:37 »
Hi jerry110,
your file contains tab-separated values. The correct separator is that "
Try to insert a book then export it. You should use that file to add the other books you need
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!

Offline jerry110

  • Coccinella
  • *
  • Posts: 3
  • Karma: +0/-0
Re: Importing SQL Error
« Reply #3 on: 24 July 2020, 01:30:52 »
Yea i got fed up and went with a different solution.....thanks for your time!

Vox Populi(x) forum

Re: Importing SQL Error
« Reply #3 on: 24 July 2020, 01:30:52 »