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/e1babc49-0fb9-4bed-beb9-b68d192aafa2n%40googlegroups.com.
