Done :-) gjr80 schrieb am Montag, 31. August 2020 um 22:31:36 UTC+2:
> You are correct, though that wiki article was first written quite some > time ago when the only schema shipped with WeeWX was ‘wview’. The article > should be updated to highlight there are now two schemas shipped with > WeeWX. Anyone can edit the wiki, hint hint.... > > Gary > On Tuesday, 1 September 2020 at 04:00:43 UTC+10 [email protected] wrote: > >> Answering myself: >> >> I think i have found the error. The description of the DB change seem to >> be wrong: >> https://github.com/weewx/weewx/wiki/Transfer%20from%20sqlite%20to%20MySQL >> >> This part should be: >> schemas.wview_*extended*.schema >> >> Uwe S. schrieb am Montag, 31. August 2020 um 19:18:31 UTC+2: >> >>> I've contacted the developer of Belchertown skin. >>> He said that a row is missing in a table. It should be in with the >>> extended schema which is used in my installation (V4.1.x). >>> Unfortunately there's nothing what he can do as it should work and he >>> asked to open a thread in this group. >>> >>> If anyone can help, would be appreciated >>> >>> Thanks >>> >>> Uwe S. schrieb am Montag, 31. August 2020 um 18:23:21 UTC+2: >>> >>>> Seem to be related to the Belchertown skin. Once uninstalled, the >>>> errors do not come up again. So i might need to ask the developer of the >>>> skin >>>> >>>> Uwe S. schrieb am Montag, 31. August 2020 um 18:09:27 UTC+2: >>>> >>>>> Dear all, >>>>> >>>>> i was going to move to MySQL as DB engine. >>>>> For this i followed the steps and transferred the DB content to MySQL >>>>> using the wee_database option. >>>>> >>>>> So far it went through, WeeWX restarted and added records to the >>>>> archive tabie. >>>>> >>>>> But there are errors in the syslog which are reoccuring on every run: >>>>> >>>>> Aug 31 18:05:35 WeeWX weewx[18750] ERROR weewx.reportengine: Caught >>>>> unrecoverable exception in generator >>>>> 'user.belchertown.HighchartsJsonGenerator' >>>>> Aug 31 18:05:35 WeeWX weewx[18750] ERROR weewx.reportengine: **** >>>>> Error trying to use database binding wx_binding to graph observation >>>>> maxSolarRad. Error was: maxSolarRad. >>>>> Aug 31 18:05:35 WeeWX weewx[18750] ERROR weewx.reportengine: **** >>>>> Traceback (most recent call last): >>>>> Aug 31 18:05:35 WeeWX weewx[18750] ERROR weewx.reportengine: **** File >>>>> "/usr/share/weewx/user/belchertown.py", line 2325, in get_observation_data >>>>> Aug 31 18:05:35 WeeWX weewx[18750] ERROR weewx.reportengine: **** >>>>> (time_start_vt, time_stop_vt, obs_vt) = >>>>> archive.getSqlVectors(TimeSpan(start_ts, end_ts), obs_lookup, >>>>> aggregate_type, aggregate_interval) >>>>> Aug 31 18:05:35 WeeWX weewx[18750] ERROR weewx.reportengine: **** File >>>>> "/usr/share/weewx/weewx/manager.py", line 452, in getSqlVectors >>>>> Aug 31 18:05:35 WeeWX weewx[18750] ERROR weewx.reportengine: **** >>>>> aggregate_type, aggregate_interval) >>>>> Aug 31 18:05:35 WeeWX weewx[18750] ERROR weewx.reportengine: **** File >>>>> "/usr/share/weewx/weewx/xtypes.py", line 91, in get_series >>>>> Aug 31 18:05:35 WeeWX weewx[18750] ERROR weewx.reportengine: **** >>>>> raise weewx.UnknownType(obs_type) >>>>> Aug 31 18:05:35 WeeWX weewx[18750] ERROR weewx.reportengine: **** >>>>> weewx.UnknownType: maxSolarRad >>>>> Aug 31 18:05:35 WeeWX weewx[18750] ERROR weewx.reportengine: **** >>>>> Aug 31 18:05:35 WeeWX weewx[18750] ERROR weewx.reportengine: **** >>>>> During handling of the above exception, another exception occurred: >>>>> Aug 31 18:05:35 WeeWX weewx[18750] ERROR weewx.reportengine: **** >>>>> Aug 31 18:05:35 WeeWX weewx[18750] ERROR weewx.reportengine: **** >>>>> Traceback (most recent call last): >>>>> Aug 31 18:05:35 WeeWX weewx[18750] ERROR weewx.reportengine: **** File >>>>> "/usr/share/weewx/weewx/reportengine.py", line 197, in run >>>>> Aug 31 18:05:35 WeeWX weewx[18750] ERROR weewx.reportengine: **** >>>>> obj.start() >>>>> Aug 31 18:05:35 WeeWX weewx[18750] ERROR weewx.reportengine: **** File >>>>> "/usr/share/weewx/weewx/reportengine.py", line 280, in start >>>>> Aug 31 18:05:35 WeeWX weewx[18750] ERROR weewx.reportengine: **** >>>>> self.run() >>>>> Aug 31 18:05:35 WeeWX weewx[18750] ERROR weewx.reportengine: **** File >>>>> "/usr/share/weewx/user/belchertown.py", line 1823, in run >>>>> Aug 31 18:05:35 WeeWX weewx[18750] ERROR weewx.reportengine: **** >>>>> series_data = self.get_observation_data(binding, archive, >>>>> observation_type, >>>>> minstamp, maxstamp, aggregate_type, aggregate_interval, time_length, >>>>> xAxis_groupby, xAxis_categories, mirrored_value, weatherRange_obs_lookup, >>>>> wind_rose_color) >>>>> Aug 31 18:05:35 WeeWX weewx[18750] ERROR weewx.reportengine: **** File >>>>> "/usr/share/weewx/user/belchertown.py", line 2327, in get_observation_data >>>>> Aug 31 18:05:35 WeeWX weewx[18750] ERROR weewx.reportengine: **** >>>>> raise Warning( "Error trying to use database binding %s to graph >>>>> observation %s. Error was: %s." % (binding, obs_lookup, e) ) >>>>> Aug 31 18:05:35 WeeWX weewx[18750] ERROR weewx.reportengine: **** >>>>> Warning: Error trying to use database binding wx_binding to graph >>>>> observation maxSolarRad. Error was: maxSolarRad. >>>>> Aug 31 18:05:35 WeeWX weewx[18750] ERROR weewx.reportengine: **** >>>>> Generator terminated >>>>> >>>>> >>>>> Any idea how i can fix that? As you can see i am using the skin >>>>> Belchertown >>>>> >>>> -- 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/e7eb35fb-a747-454d-a43e-61587ee1871dn%40googlegroups.com.
