MySQL compatibility?


#1

I want to use it with iobroker and flot,

My Mysql Database works good but the memsql Database gives an error if I try to use flot.
The LOG-file from iobroker gives my this error:

Error: ER_PARSE_ERROR: 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 ‘ORDER BY ts ASC’ at line 1|

what can I do?

best regards
Tobi


#2

Can you paste the full query that hit that error?

If you don’t know what the query is, one way you can find out is to enable query logging by running set global general_log = on and finding the query in tracelogs/queries.log (https://docs.memsql.com/operational-manual/v6.7/trace-log/#logging-queries)