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 <tkef...@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 me think your database has a NULL value for the >>> temperature observation somewhere. Thankfully weewx has a utility that can >>> try to help. >>> >>> Make a backup of your database >>> >>> Run sudo wee_database --check-strings >>> >>> Then if it found some, run sudo wee_database --fix-strings >>> >>> Then rebuild the daily dummaries with sudo wee_database --rebuild-daily >>> >>> Once completed, restart weewx and see if the error goes away. >>> >>> >>> On Friday, November 30, 2018 at 9:17:23 AM UTC-5, Jonis Maurin Ceará >>> wrote: >>> >>> Pat, I'm not sure if I'm doing something wrong or not.....but I can't >>> see anything in hook places. >>> I've updated skin package and then create a file called >>> 'index_hook_after_forecast.inc' inside 'skins/Belchertown' folder >>> (/etc/weewx). >>> >>> But after first report/page gerenatio (after restart weewx), I'm getting >>> this error (and report page doesn't contain my text/html from hook file): >>> >>> Nov 30 12:11:49 SkyWeather weewx[8251]: cheetahgenerator: Generated 4 >>> files for report Highcharts_Belchertown in 93.32 seconds >>> Nov 30 12:11:49 SkyWeather weewx[8251]: copygenerator: copied 0 files to >>> /var/www/html/weewx >>> Nov 30 12:11:49 SkyWeather weewx[8251]: Belchertown Extension: version >>> 0.8rc3 >>> Nov 30 12:11:49 SkyWeather weewx[8251]: reportengine: Caught >>> unrecoverable exception in generator weewx.cheetahgenerator.CheetahGenerator >>> Nov 30 12:11:49 SkyWeather weewx[8251]: **** a float is required >>> Nov 30 12:11:49 SkyWeather weewx[8251]: **** Traceback (most >>> recent call last): >>> Nov 30 12:11:49 SkyWeather weewx[8251]: **** File >>> "/usr/share/weewx/weewx/reportengine.py", line 239, in run >>> Nov 30 12:11:49 SkyWeather weewx[8251]: **** obj.start() >>> Nov 30 12:11:49 SkyWeather weewx[8251]: **** File >>> "/usr/share/weewx/weewx/reportengine.py", line 273, in start >>> Nov 30 12:11:49 SkyWeather weewx[8251]: **** self.run() >>> Nov 30 12:11:49 SkyWeather weewx[8251]: **** File >>> "/usr/share/weewx/weewx/cheetahgenerator.py", line 158, in run >>> Nov 30 12:11:49 SkyWeather weewx[8251]: **** ngen = >>> self.generate(gen_dict[section_name], self.gen_ts) >>> Nov 30 12:11:49 SkyWeather weewx[8251]: **** File >>> "/usr/share/weewx/weewx/cheetahgenerator.py", line 232, in generate >>> Nov 30 12:11:49 SkyWeather weewx[8251]: **** ngen += >>> self.generate(section[subsection], gen_ts) >>> Nov 30 12:11:49 SkyWeather weewx[8251]: **** File >>> "/usr/share/weewx/weewx/c >>> >>> ... >> >> -- >> 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. >> > -- > 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.
