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 <[email protected]> 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 <[email protected]> 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 [email protected]. > 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 [email protected]. For more options, visit https://groups.google.com/d/optout.
