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/4a7adecf-7f6d-4700-97f2-c218ce3ca025n%40googlegroups.com.
