search

astro-datalab / fits2db

2 stars 3 forks source link

ERROR 1064 (42000) at line 3 #8

Open ianjarog opened 3 years ago

ianjarog commented 3 years ago

Hello @mjfitzpatrick
I tested the script on Mysql Server version: 8.0.25-0ubuntu0.20.04.1 (Ubuntu); and got the following errors.

ERROR 1064 (42000) at line 3: 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 'Row integer, Value bigint )' at line 2

mjfitzpatrick commented 3 years ago

Thanks for the question, although I'm a little unclear on exactly what you did to generate the error message. A 1064 error basically a syntax problem and can sometimes be caused if you use a reserved SQL keyword as e.g. a column or table name. Could you possibly run the task again but instead of piping the output to the database could you save and post the first few dozen lines here. Are 'Row' and 'Value' perhaps column names in the table you're trying to load?