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/CAPq0zEB_CtNhav6tCs2xt5mrN9xKFwsCbY%2Bcp%2BS%3Dbc-vEgnVDw%40mail.gmail.com.
