Yes, all done with weewx stoped. But I find a way: delete rows with null values (those 2) and don't run rebuild (the DELETE was done AFTER rebuild command), so this way it's working.....but I'm not sure why rebuild is creating these 2 rows with null values :(
Em sex, 30 de nov de 2018 às 14:52, Pat <p...@obrienphoto.net> escreveu: > 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> >> 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> 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 a topic in the > Google Groups "weewx-user" group. > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/weewx-user/GSrKZEiPqsc/unsubscribe. > To unsubscribe from this group and all its topics, send an email to > weewx-user+unsubscr...@googlegroups.com. > For more options, visit https://groups.google.com/d/optout. > -- 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.
