Fixed in commit 52db478 <https://github.com/weewx/weewx/commit/52db4781a712807f99c914c3ae76415426ecc7be> .
The fix is in the file weewx/xtypes.py <https://raw.githubusercontent.com/weewx/weewx/V5/bin/weewx/xtypes.py>. You can simply swap out your old version for the new one, if you are comfortable doing that. Otherwise, wait for V5. On Wed, Jul 26, 2023 at 7:01 AM Tom Keffer <[email protected]> wrote: > Thanks. > > Turns out there is a bug in how aggregates are calculated that prevents > this. I've created issue #881 <https://github.com/weewx/weewx/issues/881>. > > I'll fix it, but not until Version 5.0. > > -tk > > On Wed, Jul 26, 2023 at 5:56 AM [email protected] <[email protected]> > wrote: > >> I try with the Seasson skin and i get the same error "no such column: >> None". Doesn't work. >> >> El miércoles, 26 de julio de 2023 a las 13:30:58 UTC+2, [email protected] >> escribió: >> >>> Thank you very much. but it don't works in belchertown. It gives this >>> error: >>> Jul 26 13:25:32 raspberrypi weewx[1189454] ERROR weewx.reportengine: >>> Caught unrecoverable exception in generator >>> 'user.belchertown.HighchartsJsonGenerator' >>> Jul 26 13:25:32 raspberrypi weewx[1189454] ERROR weewx.reportengine: >>> **** Error trying to use database binding wx_binding to graph >>> observation outTemp. Error was: no such column: None. >>> Jul 26 13:25:32 raspberrypi weewx[1189454] ERROR weewx.reportengine: >>> **** Traceback (most recent call last): >>> Jul 26 13:25:32 raspberrypi weewx[1189454] ERROR weewx.reportengine: >>> **** File "/usr/share/weewx/weedb/sqlite.py", line 39, in guarded_fn >>> Jul 26 13:25:32 raspberrypi weewx[1189454] ERROR weewx.reportengine: >>> **** return fn(*args, **kwargs) >>> Jul 26 13:25:32 raspberrypi weewx[1189454] ERROR weewx.reportengine: >>> **** File "/usr/share/weewx/weedb/sqlite.py", line 233, in execute >>> Jul 26 13:25:32 raspberrypi weewx[1189454] ERROR weewx.reportengine: >>> **** return sqlite3.Cursor.execute(self, *args, **kwargs) >>> Jul 26 13:25:32 raspberrypi weewx[1189454] ERROR weewx.reportengine: >>> **** sqlite3.OperationalError: no such column: None >>> Jul 26 13:25:32 raspberrypi weewx[1189454] ERROR weewx.reportengine: >>> **** >>> Jul 26 13:25:32 raspberrypi weewx[1189454] ERROR weewx.reportengine: >>> **** During handling of the above exception, another exception >>> occurred: >>> Jul 26 13:25:32 raspberrypi weewx[1189454] ERROR weewx.reportengine: >>> **** >>> Jul 26 13:25:32 raspberrypi weewx[1189454] ERROR weewx.reportengine: >>> **** Traceback (most recent call last): >>> Jul 26 13:25:32 raspberrypi weewx[1189454] ERROR weewx.reportengine: >>> **** File "/usr/share/weewx/user/belchertown.py", line 3790, in >>> get_observation_data >>> Jul 26 13:25:32 raspberrypi weewx[1189454] ERROR weewx.reportengine: >>> **** (time_start_vt, time_stop_vt, obs_vt) = >>> weewx.xtypes.get_series( >>> Jul 26 13:25:32 raspberrypi weewx[1189454] ERROR weewx.reportengine: >>> **** File "/usr/share/weewx/weewx/xtypes.py", line 100, in get_series >>> Jul 26 13:25:32 raspberrypi weewx[1189454] ERROR weewx.reportengine: >>> **** return xtype.get_series(obs_type, timespan, db_manager, >>> aggregate_type, >>> Jul 26 13:25:32 raspberrypi weewx[1189454] ERROR weewx.reportengine: >>> **** File "/usr/share/weewx/weewx/xtypes.py", line 167, in get_series >>> Jul 26 13:25:32 raspberrypi weewx[1189454] ERROR weewx.reportengine: >>> **** agg_vt = get_aggregate(obs_type, stamp, do_aggregate, >>> db_manager) >>> Jul 26 13:25:32 raspberrypi weewx[1189454] ERROR weewx.reportengine: >>> **** File "/usr/share/weewx/weewx/xtypes.py", line 127, in >>> get_aggregate >>> Jul 26 13:25:32 raspberrypi weewx[1189454] ERROR weewx.reportengine: >>> **** return xtype.get_aggregate(obs_type, timespan, >>> aggregate_type, db_manager, >>> Jul 26 13:25:32 raspberrypi weewx[1189454] ERROR weewx.reportengine: >>> **** File "/usr/share/weewx/weewx/xtypes.py", line 551, in >>> get_aggregate >>> Jul 26 13:25:32 raspberrypi weewx[1189454] ERROR weewx.reportengine: >>> **** row = >>> db_manager.getSql(DailySummaries.agg_sql_dict[aggregate_type] % inter_dict) >>> Jul 26 13:25:32 raspberrypi weewx[1189454] ERROR weewx.reportengine: >>> **** File "/usr/share/weewx/weewx/manager.py", line 579, in getSql >>> Jul 26 13:25:32 raspberrypi weewx[1189454] ERROR weewx.reportengine: >>> **** _cursor.execute(sql, sqlargs) >>> Jul 26 13:25:32 raspberrypi weewx[1189454] ERROR weewx.reportengine: >>> **** File "/usr/share/weewx/weedb/sqlite.py", line 51, in guarded_fn >>> Jul 26 13:25:32 raspberrypi weewx[1189454] ERROR weewx.reportengine: >>> **** raise weedb.NoColumnError(e) >>> Jul 26 13:25:32 raspberrypi weewx[1189454] ERROR weewx.reportengine: >>> **** weedb.NoColumnError: no such column: None >>> Jul 26 13:25:32 raspberrypi weewx[1189454] ERROR weewx.reportengine: >>> **** >>> Jul 26 13:25:32 raspberrypi weewx[1189454] ERROR weewx.reportengine: >>> **** During handling of the above exception, another exception >>> occurred: >>> Jul 26 13:25:32 raspberrypi weewx[1189454] ERROR weewx.reportengine: >>> **** >>> Jul 26 13:25:32 raspberrypi weewx[1189454] ERROR weewx.reportengine: >>> **** Traceback (most recent call last): >>> Jul 26 13:25:32 raspberrypi weewx[1189454] ERROR weewx.reportengine: >>> **** File "/usr/share/weewx/weewx/reportengine.py", line 197, in run >>> Jul 26 13:25:32 raspberrypi weewx[1189454] ERROR weewx.reportengine: >>> **** obj.start() >>> Jul 26 13:25:32 raspberrypi weewx[1189454] ERROR weewx.reportengine: >>> **** File "/usr/share/weewx/weewx/reportengine.py", line 385, in >>> start >>> Jul 26 13:25:32 raspberrypi weewx[1189454] ERROR weewx.reportengine: >>> **** self.run() >>> Jul 26 13:25:32 raspberrypi weewx[1189454] ERROR weewx.reportengine: >>> **** File "/usr/share/weewx/user/belchertown.py", line 2819, in run >>> Jul 26 13:25:32 raspberrypi weewx[1189454] ERROR weewx.reportengine: >>> **** series_data = self.get_observation_data( >>> Jul 26 13:25:32 raspberrypi weewx[1189454] ERROR weewx.reportengine: >>> **** File "/usr/share/weewx/user/belchertown.py", line 3798, in >>> get_observation_data >>> Jul 26 13:25:32 raspberrypi weewx[1189454] ERROR weewx.reportengine: >>> **** raise Warning( >>> Jul 26 13:25:32 raspberrypi weewx[1189454] ERROR weewx.reportengine: >>> **** Warning: Error trying to use database binding wx_binding to graph >>> observation outTemp. Error was: no such column: None. >>> Jul 26 13:25:32 raspberrypi weewx[1189454] ERROR weewx.reportengine: >>> **** Generator terminated >>> >>> El martes, 25 de julio de 2023 a las 20:28:37 UTC+2, Tom Keffer escribió: >>> >>>> If your question is a general one, and not specific to the Belchertown >>>> skin, you already have a thread going on this topic. >>>> https://groups.google.com/g/weewx-user/c/8jmtc7RASgo/m/9WQ5vhbjAQAJ >>>> >>>> Or, is your question specific to the Belchertown skin? In that case, >>>> I'm not familiar enough with the skin to help you. >>>> >>>> On Tue, Jul 25, 2023 at 8:55 AM [email protected] <[email protected]> >>>> wrote: >>>> >>>>> It seems easy but i don't get it. I try with aggregate_type = >>>>> max_ge(25,"degree_C") buy it don't work >>>>> >>>>> Responder a todos >>>>> Responder al autor >>>>> Reenviar >>>>> >>>>> >>>>> El lunes, 24 de julio de 2023 a las 16:29:10 UTC+2, [email protected] >>>>> escribió: >>>>> >>>>>> Is there a way to make a graphic like the one I ask for with the >>>>>> bechertown skin? >>>>>> I do not get it >>>>>> >>>>> -- >>>>> 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]. >>>>> To view this discussion on the web visit >>>>> https://groups.google.com/d/msgid/weewx-user/9de082d7-1298-4382-829d-910c8db567cdn%40googlegroups.com >>>>> <https://groups.google.com/d/msgid/weewx-user/9de082d7-1298-4382-829d-910c8db567cdn%40googlegroups.com?utm_medium=email&utm_source=footer> >>>>> . >>>>> >>>> -- >> 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]. >> To view this discussion on the web visit >> https://groups.google.com/d/msgid/weewx-user/5bc2af84-6931-4cc7-a356-502c1249ab0en%40googlegroups.com >> <https://groups.google.com/d/msgid/weewx-user/5bc2af84-6931-4cc7-a356-502c1249ab0en%40googlegroups.com?utm_medium=email&utm_source=footer> >> . >> > -- 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]. To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/CAPq0zEAMOqmhNjSW5BZ38-C8u5WXK5hUjeuDE0iv2ibm7npmZg%40mail.gmail.com.
