Print Page - Importing SQL Error

Title: Importing SQL Error
Post by: jerry110 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

Title: Re: Importing SQL Error
Post by: jerry110 on 21 July 2020, 23:09:09

Here is the file im using: Made from the sample File..........(CSV)

Title: Re: Importing SQL Error
Post by: federica 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

Title: Re: Importing SQL Error
Post by: jerry110 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

Alexandria Book Library => Supporto (Support) => Topic started by: jerry110 on 21 July 2020, 22:15:53