search

jxmx / smooth-qsl

Smooth QSL is a simple QSL manager. Upload ADIFs and then people can download printable QSLs from the logs.
https://mfamily.org/smoothqsl
Apache License 2.0
5 stars 4 forks source link

sql import error on xampp server. #12

Closed imoldovavan closed 8 months ago

imoldovavan commented 10 months ago

-- -- Table structure for table trans

--DROP TABLE IF EXISTS trans; MySQL said: Documentation

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '--DROP TABLE IF EXISTS trans' at line 5

jxmx commented 10 months ago

@imoldovavan - What version of MariaDB are you using?

imoldovavan commented 10 months ago

MariaDB 10.4.28 XAMPP Version: 8.2.4

jxmx commented 10 months ago

@imoldovavan I can't immediately reproduce an SQL error that your showing above. Is this when you're loading the database for the first time? MariaDB 10.4 is obsolete; can you use a newer version? I don't use XAMPP so I don't know what your options are.

michelinok commented 9 months ago

You must remove the "--" , you can find this "error" also on all the other Drop Table inside the sql file.

jxmx commented 9 months ago

The -- is there on purpose because in most cases you don't want to drop the existing tables because they presumably have data in them. However the original error as reported is that @imoldovavan server is saying that -- is an invalid command itself which it isn't.

jxmx commented 8 months ago

Can't reproduce