Hi, I am using mqysql as my weewx database. I run the wee_database --check-strings and it comes back clean but if I run mysql command to look for NULL I get a lot of results. Anyone know why this would be the case?
Thanks wee_database --check-strings Using configuration file /etc/weewx/weewx.conf Using database binding 'wx_binding', which is bound to database 'archive_mysql' Preparing Null String Check, this may take awhile... Checking record: 488186; Timestamp: 2018-03-12 10:05:00 AEDT (1520809500) No null strings found. Completed Null String Check in 28.89 seconds. Yet, if I run the command below it shows I do have NULL values. MariaDB [weewx]> select dateTime, rain , rainRate from archive where rain IS NULL; +------------+------+----------+ | dateTime | rain | rainRate | +------------+------+----------+ | 1501541984 | NULL | 0 | | 1501546184 | NULL | 0 | | 1501563583 | NULL | 0 | | 1501564184 | NULL | 0 | | 1501564490 | NULL | 0 | | 1501585184 | NULL | 0 | | 1501590884 | NULL | 0 | | 1501634684 | NULL | 0 | | 1501635284 | NULL | 0 | | 1501636784 | NULL | 0 | | 1501656884 | NULL | 0 | | 1501659584 | NULL | 0 | | 1501675645 | NULL | 0 | -- You received this message because you are subscribed to the Google Groups "weewx-user" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
