The table exists. Could it be corrupted in some way? That would explain why the problem came up only recently.
SQLite version 3.31.1 2020-01-27 19:55:54 Enter ".help" for usage hints. sqlite> SELECT tbl_name FROM sqlite_master WHERE type='table'; archive archive_day_altimeter archive_day_appTemp archive_day_appTemp1 archive_day_barometer archive_day_batteryStatus1 archive_day_batteryStatus2 archive_day_batteryStatus3 archive_day_batteryStatus4 archive_day_batteryStatus5 archive_day_batteryStatus6 archive_day_batteryStatus7 archive_day_batteryStatus8 archive_day_cloudbase archive_day_co archive_day_co2 archive_day_consBatteryVoltage archive_day_dewpoint archive_day_dewpoint1 archive_day_ET archive_day_extraHumid1 archive_day_extraHumid2 archive_day_extraHumid3 archive_day_extraHumid4 archive_day_extraHumid5 archive_day_extraHumid6 archive_day_extraHumid7 archive_day_extraHumid8 archive_day_extraTemp1 archive_day_extraTemp2 archive_day_extraTemp3 archive_day_extraTemp4 archive_day_extraTemp5 archive_day_extraTemp6 archive_day_extraTemp7 archive_day_extraTemp8 archive_day_forecast archive_day_hail archive_day_hailBatteryStatus archive_day_hailRate archive_day_heatindex archive_day_heatindex1 archive_day_heatingTemp archive_day_heatingVoltage archive_day_humidex archive_day_humidex1 archive_day_inDewpoint archive_day_inHumidity archive_day_inTemp archive_day_inTempBatteryStatus archive_day_leafTemp1 archive_day_leafTemp2 archive_day_leafWet1 archive_day_leafWet2 archive_day_lightning_distance archive_day_lightning_disturber_count archive_day_lightning_energy archive_day_lightning_noise_count archive_day_lightning_strike_count archive_day_luminosity archive_day_maxSolarRad archive_day_nh3 archive_day_no2 archive_day_noise archive_day_o3 archive_day_outHumidity archive_day_outTemp archive_day_outTempBatteryStatus archive_day_pb archive_day_pm10_0 archive_day_pm1_0 archive_day_pm2_5 archive_day_pressure archive_day_radiation archive_day_rain archive_day_rainBatteryStatus archive_day_rainRate archive_day_referenceVoltage archive_day_rxCheckPercent archive_day_signal1 archive_day_signal2 archive_day_signal3 archive_day_signal4 archive_day_signal5 archive_day_signal6 archive_day_signal7 archive_day_signal8 archive_day_snow archive_day_snowBatteryStatus archive_day_snowDepth archive_day_snowMoisture archive_day_snowRate archive_day_so2 archive_day_soilMoist1 archive_day_soilMoist2 archive_day_soilMoist3 archive_day_soilMoist4 archive_day_soilTemp1 archive_day_soilTemp2 archive_day_soilTemp3 archive_day_soilTemp4 archive_day_supplyVoltage archive_day_txBatteryStatus archive_day_UV archive_day_uvBatteryStatus archive_day_windBatteryStatus archive_day_windchill archive_day_windDir archive_day_windGust archive_day_windGustDir archive_day_windrun archive_day_windSpeed *archive_day_wind* archive_day__metadata sqlite> On Wednesday, October 28, 2020 at 12:11:38 AM UTC+1 [email protected] wrote: > 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/c8a13b8e-c377-47dd-9477-21372e4b0261n%40googlegroups.com.
