Migration to MySQL - WeeWX with errors in syslog

[Uwe S.]

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

[Uwe S.]

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.]

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.]

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 

[gjr80]

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

[Uwe S.]

Done :-)

[gjr80]

Thanks!

Gary