Can you take a look inside your database? What is the result of: *sqlite3 /var/lib/weewx/weewx.sdb* sqlite> *SELECT tbl_name FROM sqlite_master WHERE type='table';* sqlite> *.quit*
This will tell us whether the table archive_day_wind exists in your database. -tk On Tue, Oct 27, 2020 at 2:20 PM Alessandro Del Prete < [email protected]> wrote: > Hi, > > I have the same issue, it's a brand new installation of weewx 4.1.1, > working since a month with a belchertown skin and a weatherflow tempest. > > Today I was checking weewx.log and I noticed this: > > Oct 27 21:39:24 ubuntu weewx[59297] DEBUG weewx.manager: Daily summary > version is 2.0 > Oct 27 21:39:24 ubuntu weewx[59297] ERROR weewx.cheetahgenerator: Generate > failed with exception '<class 'NameMapper.NotFound'>' > Oct 27 21:39:24 ubuntu weewx[59297] ERROR weewx.cheetahgenerator: **** > Ignoring template /etc/weewx/skins/Seasons/NOAA/NOAA-%Y-%m.txt.tmpl > Oct 27 21:39:24 ubuntu weewx[59297] ERROR weewx.cheetahgenerator: **** > Reason: cannot find 'count' while searching for 'day.wind.count.raw' > Oct 27 21:39:24 ubuntu weewx[59297] ERROR weewx.cheetahgenerator: **** > Traceback (most recent call last): > Oct 27 21:39:24 ubuntu weewx[59297] ERROR weewx.cheetahgenerator: **** > File "/usr/share/weewx/weewx/cheetahgenerator.py", line 322, in generate > Oct 27 21:39:24 ubuntu weewx[59297] ERROR weewx.cheetahgenerator: **** > unicode_string = compiled_template.respond() > Oct 27 21:39:24 ubuntu weewx[59297] ERROR weewx.cheetahgenerator: **** > File "_etc_weewx_skins_Seasons_NOAA_NOAA__Y__m_txt_tmpl.py", line 431, in > respond > Oct 27 21:39:24 ubuntu weewx[59297] ERROR weewx.cheetahgenerator: **** > NameMapper.NotFound: cannot find 'count' while searching for > 'day.wind.count.raw' > Oct 27 21:39:24 ubuntu weewx[59297] ERROR weewx.cheetahgenerator: Generate > failed with exception '<class 'NameMapper.NotFound'>' > Oct 27 21:39:24 ubuntu weewx[59297] ERROR weewx.cheetahgenerator: **** > Ignoring template /etc/weewx/skins/Seasons/NOAA/NOAA-%Y-%m.txt.tmpl > Oct 27 21:39:24 ubuntu weewx[59297] ERROR weewx.cheetahgenerator: **** > Reason: cannot find 'count' while searching for 'day.wind.count.raw' > Oct 27 21:39:24 ubuntu weewx[59297] ERROR weewx.cheetahgenerator: **** > Traceback (most recent call last): > Oct 27 21:39:24 ubuntu weewx[59297] ERROR weewx.cheetahgenerator: **** > File "/usr/share/weewx/weewx/cheetahgenerator.py", line 322, in generate > Oct 27 21:39:24 ubuntu weewx[59297] ERROR weewx.cheetahgenerator: **** > unicode_string = compiled_template.respond() > Oct 27 21:39:24 ubuntu weewx[59297] ERROR weewx.cheetahgenerator: **** > File "_etc_weewx_skins_Seasons_NOAA_NOAA__Y__m_txt_tmpl.py", line 431, in > respond > Oct 27 21:39:24 ubuntu weewx[59297] ERROR weewx.cheetahgenerator: **** > NameMapper.NotFound: cannot find 'count' while searching for > 'day.wind.count.raw' > > Then I found your reply to solve the problem. I checked the DataBindings > section, and everything's like you suggested, no mixing (it was a new > installation), so I don't know why the issue came up only after some time. > > Is it possible to solve the problem without deleting the database? > > Thanks for any advice on this. > > Alessandro > > On Thursday, September 17, 2020 at 8:20:48 PM UTC+2 [email protected] > wrote: > >> The reason why this can occur is a rather technical one, but has to do >> with mixing the older, V3.x, way of specifying a schema, and the newer, >> V4.x way. >> >> 1. Stop weewx >> >> 2. Assuming there is nothing valuable in it, delete the archive >> /var/lib/weewx/weewx.sdb >> >> 3. Make sure your [DataBindings] section looks like this. Pay attention >> to the highlighted areas. >> >> [DataBindings] >> >> [[wx_binding]] >> # The database must match one of the sections in [Databases]. >> # This is likely to be the only option you would want to change. >> database = archive_sqlite >> # The name of the table within the database >> table_name = archive >> # The manager handles aggregation of data for historical summaries >> manager = weewx.manager.DaySummaryManager >> # The schema defines the structure of the database. >> # It is *only* used when the database is created. >> schema = schemas.wview_extended.schema >> >> 4. Restart weewx. >> >> -tk >> >> >> >> On Thu, Sep 17, 2020 at 11:00 AM '[email protected]' via weewx-user >> <[email protected]> wrote: >> >>> Hi, >>> >>> After two tries with cheaper Weather Stations which failed due to >>> Quality I bought now a Davis Vantage Pro2 Wireless with a Weatherlink Live >>> Adapter >>> >>> I have setup now a new Weewx Installation and had it running for some >>> days with "simulator" without any issues. >>> >>> Now I got my davis and I have configured it immediatly. >>> >>> But unfortunatley I am getting now the following error: >>> >>> *Sep 17 19:55:17 weewx-test weewx[23751] ERROR weewx.cheetahgenerator: >>> Generate failed with exception '<class 'NameMapper.NotFound'>'* >>> *Sep 17 19:55:17 weewx-test weewx[23751] ERROR weewx.cheetahgenerator: >>> **** Ignoring template /etc/weewx/skins/Seasons/NOAA/NOAA-%Y-%m.txt.tmpl* >>> *Sep 17 19:55:17 weewx-test weewx[23751] ERROR weewx.cheetahgenerator: >>> **** Reason: cannot find 'count' while searching for 'day.wind.count.raw'* >>> *Sep 17 19:55:17 weewx-test weewx[23751] ERROR weewx.cheetahgenerator: >>> **** Traceback (most recent call last):* >>> *Sep 17 19:55:17 weewx-test weewx[23751] ERROR weewx.cheetahgenerator: >>> **** File "/usr/share/weewx/weewx/cheetahgenerator.py", line 322, in >>> generate* >>> *Sep 17 19:55:17 weewx-test weewx[23751] ERROR weewx.cheetahgenerator: >>> **** unicode_string = compiled_template.respond()* >>> *Sep 17 19:55:17 weewx-test weewx[23751] ERROR weewx.cheetahgenerator: >>> **** File "_etc_weewx_skins_Seasons_NOAA_NOAA__Y__m_txt_tmpl.py", line >>> 431, in respond* >>> *Sep 17 19:55:17 weewx-test weewx[23751] ERROR weewx.cheetahgenerator: >>> **** NameMapper.NotFound: cannot find 'count' while searching for >>> 'day.wind.count.raw'* >>> *Sep 17 19:55:17 weewx-test weewx[23751] ERROR weewx.cheetahgenerator: >>> Generate failed with exception '<class 'NameMapper.NotFound'>'* >>> *Sep 17 19:55:17 weewx-test weewx[23751] ERROR weewx.cheetahgenerator: >>> **** Ignoring template /etc/weewx/skins/Seasons/NOAA/NOAA-%Y.txt.tmpl* >>> *Sep 17 19:55:17 weewx-test weewx[23751] ERROR weewx.cheetahgenerator: >>> **** Reason: cannot find 'count' while searching for 'month.wind.count.raw'* >>> *Sep 17 19:55:17 weewx-test weewx[23751] ERROR weewx.cheetahgenerator: >>> **** Traceback (most recent call last):* >>> *Sep 17 19:55:17 weewx-test weewx[23751] ERROR weewx.cheetahgenerator: >>> **** File "/usr/share/weewx/weewx/cheetahgenerator.py", line 322, in >>> generate* >>> *Sep 17 19:55:17 weewx-test weewx[23751] ERROR weewx.cheetahgenerator: >>> **** unicode_string = compiled_template.respond()* >>> *Sep 17 19:55:17 weewx-test weewx[23751] ERROR weewx.cheetahgenerator: >>> **** File "_etc_weewx_skins_Seasons_NOAA_NOAA__Y_txt_tmpl.py", line 862, >>> in respond* >>> *Sep 17 19:55:17 weewx-test weewx[23751] ERROR weewx.cheetahgenerator: >>> **** NameMapper.NotFound: cannot find 'count' while searching for >>> 'month.wind.count.raw'* >>> *Sep 17 19:55:17 weewx-test weewx[23751] ERROR weewx.cheetahgenerator: >>> Generate failed with exception '<class 'NameMapper.NotFound'>'* >>> *Sep 17 19:55:17 weewx-test weewx[23751] ERROR weewx.cheetahgenerator: >>> **** Ignoring template /etc/weewx/skins/Seasons/rss.xml.tmpl* >>> *Sep 17 19:55:17 weewx-test weewx[23751] ERROR weewx.cheetahgenerator: >>> **** Reason: cannot find 'max' while searching for 'day.wind.max'* >>> *Sep 17 19:55:17 weewx-test weewx[23751] ERROR weewx.cheetahgenerator: >>> **** Traceback (most recent call last):* >>> *Sep 17 19:55:17 weewx-test weewx[23751] ERROR weewx.cheetahgenerator: >>> **** File "/usr/share/weewx/weewx/cheetahgenerator.py", line 322, in >>> generate* >>> *Sep 17 19:55:17 weewx-test weewx[23751] ERROR weewx.cheetahgenerator: >>> **** unicode_string = compiled_template.respond()* >>> *Sep 17 19:55:17 weewx-test weewx[23751] ERROR weewx.cheetahgenerator: >>> **** File "_etc_weewx_skins_Seasons_rss_xml_tmpl.py", line 268, in >>> respond* >>> *Sep 17 19:55:17 weewx-test weewx[23751] ERROR weewx.cheetahgenerator: >>> **** NameMapper.NotFound: cannot find 'max' while searching for >>> 'day.wind.max'* >>> *Sep 17 19:55:17 weewx-test weewx[23751] INFO weewx.cheetahgenerator: >>> Generated 5 files for report SeasonsReport in 0.66 seconds* >>> *Sep 17 19:55:18 weewx-test weewx[23751] ERROR weewx.reportengine: >>> Caught unrecoverable exception in generator >>> 'weewx.imagegenerator.ImageGenerator'* >>> *Sep 17 19:55:18 weewx-test weewx[23751] ERROR weewx.reportengine: >>> **** no such table: archive_day_wind* >>> *Sep 17 19:55:18 weewx-test weewx[23751] ERROR weewx.reportengine: >>> **** Traceback (most recent call last):* >>> *Sep 17 19:55:18 weewx-test weewx[23751] ERROR weewx.reportengine: >>> **** File "/usr/share/weewx/weedb/sqlite.py", line 29, in guarded_fn* >>> *Sep 17 19:55:18 weewx-test weewx[23751] ERROR weewx.reportengine: >>> **** return fn(*args, **kwargs)* >>> *Sep 17 19:55:18 weewx-test weewx[23751] ERROR weewx.reportengine: >>> **** File "/usr/share/weewx/weedb/sqlite.py", line 211, in execute* >>> *Sep 17 19:55:18 weewx-test weewx[23751] ERROR weewx.reportengine: >>> **** return sqlite3.Cursor.execute(self, *args, **kwargs)* >>> *Sep 17 19:55:18 weewx-test weewx[23751] ERROR weewx.reportengine: >>> **** sqlite3.OperationalError: no such table: archive_day_wind* >>> *Sep 17 19:55:18 weewx-test weewx[23751] ERROR weewx.reportengine: >>> ***** >>> *Sep 17 19:55:18 weewx-test weewx[23751] ERROR weewx.reportengine: >>> **** During handling of the above exception, another exception >>> occurred:* >>> *Sep 17 19:55:18 weewx-test weewx[23751] ERROR weewx.reportengine: >>> ***** >>> *Sep 17 19:55:18 weewx-test weewx[23751] ERROR weewx.reportengine: >>> **** Traceback (most recent call last):* >>> *Sep 17 19:55:18 weewx-test weewx[23751] ERROR weewx.reportengine: >>> **** File "/usr/share/weewx/weewx/reportengine.py", line 197, in run* >>> *Sep 17 19:55:18 weewx-test weewx[23751] ERROR weewx.reportengine: >>> **** obj.start()* >>> *Sep 17 19:55:18 weewx-test weewx[23751] ERROR weewx.reportengine: >>> **** File "/usr/share/weewx/weewx/reportengine.py", line 280, in >>> start* >>> *Sep 17 19:55:18 weewx-test weewx[23751] ERROR weewx.reportengine: >>> **** self.run()* >>> *Sep 17 19:55:18 weewx-test weewx[23751] ERROR weewx.reportengine: >>> **** File "/usr/share/weewx/weewx/imagegenerator.py", line 41, in run* >>> *Sep 17 19:55:18 weewx-test weewx[23751] ERROR weewx.reportengine: >>> **** self.genImages(self.gen_ts)* >>> *Sep 17 19:55:18 weewx-test weewx[23751] ERROR weewx.reportengine: >>> **** File "/usr/share/weewx/weewx/imagegenerator.py", line 180, in >>> genImages* >>> *Sep 17 19:55:18 weewx-test weewx[23751] ERROR weewx.reportengine: >>> **** aggregate_interval=aggregate_interval)* >>> *Sep 17 19:55:18 weewx-test weewx[23751] ERROR weewx.reportengine: >>> **** File "/usr/share/weewx/weewx/xtypes.py", line 86, in get_series* >>> *Sep 17 19:55:18 weewx-test weewx[23751] ERROR weewx.reportengine: >>> **** aggregate_interval)* >>> *Sep 17 19:55:18 weewx-test weewx[23751] ERROR weewx.reportengine: >>> **** File "/usr/share/weewx/weewx/xtypes.py", line 628, in get_series* >>> *Sep 17 19:55:18 weewx-test weewx[23751] ERROR weewx.reportengine: >>> **** aggregate_interval)* >>> *Sep 17 19:55:18 weewx-test weewx[23751] ERROR weewx.reportengine: >>> **** File "/usr/share/weewx/weewx/xtypes.py", line 140, in get_series* >>> *Sep 17 19:55:18 weewx-test weewx[23751] ERROR weewx.reportengine: >>> **** agg_vt = get_aggregate(obs_type, stamp, do_aggregate, >>> db_manager)* >>> *Sep 17 19:55:18 weewx-test weewx[23751] ERROR weewx.reportengine: >>> **** File "/usr/share/weewx/weewx/xtypes.py", line 102, in >>> get_aggregate* >>> *Sep 17 19:55:18 weewx-test weewx[23751] ERROR weewx.reportengine: >>> **** **option_dict)* >>> *Sep 17 19:55:18 weewx-test weewx[23751] ERROR weewx.reportengine: >>> **** File "/usr/share/weewx/weewx/xtypes.py", line 796, in >>> get_aggregate* >>> *Sep 17 19:55:18 weewx-test weewx[23751] ERROR weewx.reportengine: >>> **** row = db_manager.getSql(sql, timespan)* >>> *Sep 17 19:55:18 weewx-test weewx[23751] ERROR weewx.reportengine: >>> **** File "/usr/share/weewx/weewx/manager.py", line 426, in getSql* >>> *Sep 17 19:55:18 weewx-test weewx[23751] ERROR weewx.reportengine: >>> **** _cursor.execute(sql, sqlargs)* >>> *Sep 17 19:55:18 weewx-test weewx[23751] ERROR weewx.reportengine: >>> **** File "/usr/share/weewx/weedb/sqlite.py", line 37, in guarded_fn* >>> *Sep 17 19:55:18 weewx-test weewx[23751] ERROR weewx.reportengine: >>> **** raise weedb.NoTableError(e)* >>> *Sep 17 19:55:18 weewx-test weewx[23751] ERROR weewx.reportengine: >>> **** weedb.NoTableError: no such table: archive_day_wind* >>> *Sep 17 19:55:18 weewx-test weewx[23751] ERROR weewx.reportengine: >>> **** Generator terminated* >>> >>> Any ideas? >>> >>> -- >>> 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/8cddf9c5-ac26-4bbf-bc3b-e21d0bc5e513n%40googlegroups.com >>> <https://groups.google.com/d/msgid/weewx-user/8cddf9c5-ac26-4bbf-bc3b-e21d0bc5e513n%40googlegroups.com?utm_medium=email&utm_source=footer> >>> . >>> >> -- > 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/9653844c-9165-4cac-a075-e1117984736en%40googlegroups.com > <https://groups.google.com/d/msgid/weewx-user/9653844c-9165-4cac-a075-e1117984736en%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- 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/CAPq0zEAOX7utDBnL%2Bgm1Ct17OV0NGUCHwjXwQ3L-fMu%3DJE-igw%40mail.gmail.com.
