Thanks! Gary
On Tuesday, 1 September 2020 at 20:50:34 UTC+10 uwe.sc...@gmail.com wrote: > 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 uwe.sc...@gmail.com >> 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 weewx-user+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/6a4b1fe5-0b0e-4371-9a89-91457cf62e55n%40googlegroups.com.