Thank you it works with season but it still doesn't work with belchertown and i don't understand why. I have modified belchertown.py by changing all calls to xtypes.get_series to have **option_dict but it still doesn't work and still gives the same "no such column" error. I understand that option_dict is a global variable accessible from all modules
El miércoles, 26 de julio de 2023 a las 21:35:15 UTC+2, Tom Keffer escribió: > 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/b1460026-e8c4-4e87-b961-9240c1da8762n%40googlegroups.com.
