Thanks for the clarification Tom! I knew about NULL and "", but had assumed that your wee_database checked for NULL, and not null string. Makes sense now.
Jonis - did you stop weewx in between making the changes? Maybe that could be causing the data to persist? Not really sure on this one. On Friday, November 30, 2018 at 10:14:12 AM UTC-5, Jonis Maurin Ceará wrote: > > For some reason, there is 2 records with null values....but even deleting > these, after running --rebuild-daily, both records still there (they are > re-create!) > I've tried to delete this both records from table 'archive' (using > dateTime as key), but still there after running rebuild! > > Em sex, 30 de nov de 2018 às 12:50, Thomas Keffer <tke...@gmail.com > <javascript:>> escreveu: > > Pat, just to clarify: there is a difference between a NULL value and a > null string. The former is equivalent to Python's None value, and are to be > expected throughout the databases. The latter is a string of zero length > and should not normally appear in the databases. The utility wee_database > checks only for zero-length strings. > > -tk > > On Fri, Nov 30, 2018 at 6:46 AM Pat <p...@obrienphoto.net <javascript:>> > wrote: > > Interesting. That command checks your archive table. So that seems fine. > > The error is coming from the archive_day_outTemp table and specifically > the MAX column. > > Any chance your archive_day_outTemp table has NULL values in MAX? > > You can try this MySQL query to see: SELECT > <https://zeus.obrienlabs.net/tools/empirephpadmin/url.php?url=https://dev.mysql.com/doc/refman/5.5/en/select.html> > > * FROM `archive_day_outTemp` WHERE max > <https://zeus.obrienlabs.net/tools/empirephpadmin/url.php?url=https://dev.mysql.com/doc/refman/5.5/en/group-by-functions.html#function_max> > > IS > <https://zeus.obrienlabs.net/tools/empirephpadmin/url.php?url=https://dev.mysql.com/doc/refman/5.5/en/comparison-operators.html#operator_is> > > NULL; > > If it finds one, you can rebuild the daily summaries. Shouldn't harm > anything, but have a backup first of course. > > wee_database --drop-daily > > wee_database --rebuild-daily > > > > > > On Friday, November 30, 2018 at 9:26:29 AM UTC-5, Jonis Maurin Ceará wrote: > > Actualy, no NULL strings are found :/ > > root@SkyWeather:/etc/weewx/skins# 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: 52456; Timestamp: 2018-11-30 12:20:00 -02 (1543587600) > No null strings found. > Completed Null String Check in 37.20 seconds. > > Em sex, 30 de nov de 2018 às 12:21, Pat <p...@obrienphoto.net> escreveu: > > That error makes m > > ... -- 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 weewx-user+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
