Tom, my question was not from the MySQL side, but because you said the weewx code consults the database to see if it can "do that type". In any case, I since realised tha I am seeing the same problem with the DB converted to sqlite, so that cannot be a cause.
On a side question, is there much significance to the "version" number in the DB metadata? I see one of my DBs is version 1 and the other is V4? Cameron. On Thursday 28 December 2023 at 10:52:26 am UTC+10 Tom Keffer wrote: On Wed, Dec 27, 2023 at 4:18 PM 'Cameron D' via weewx-development < [email protected]> wrote: Tom, is there any chance that it is confused by me using mysql storage type of float rather than real? I'm not a MySQL expert, but I doubt it. WeeWX does lots of little queries, which MySQL doesn't do as well as SQLite. It's possible that V5 is doing something that aggravates that. -- You received this message because you are subscribed to the Google Groups "weewx-development" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-development/db5da043-0192-417a-ab27-838a82ebb47bn%40googlegroups.com.
