Error using MySQL/MariaDB

Question

Error using MySQL/MariaDB

Closed this issue 2 years ago · 1 comments

I am using the davishealthapi extension with a MariaDB database. I have setup the database to use the table prefix davishealthapi in my configuration to post to the same weewx database as my station.

I am getting data in the database, but I get this error every time the archival process runs.

2022-04-02 17:27:16 weewx[1] ERROR user.davishealthapi: Prune data error: (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 'vacuum' at line 1")

Answer 1 · 2022-04-08T20:29:40.000Z

I figured out this issue. It was a call to the vacuum function that did not account the use of MySQL and MariaDB. I commented out this code. Please see my PR #9