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 > <javascript:>> 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.
