Tom, thanks a lot for the reply, I will try this and report back.

Just one question: in the log I see the problem is on the Seasons skin, not 
Belchertown. Am I missing something?

On Wednesday, October 28, 2020 at 9:12:49 PM UTC+1 [email protected] wrote:

> It looks like the Belchertown skin is asking for aggregations over dates 
> back in 1978. Seeing as how WeeWX wasn't even invented until 2008, you 
> probably have some bad data in there, which is likely causing the problem.
>
> What is the earliest timestamp you expect in your database? For purposes 
> of illustration, let's assume it is 12-May 2018. Use a tool like the 
> website epochconverter.com to figure out what this is in Unix epoch time. 
> The answer for the example is 1589241600.
>
> Now use the sqlite3 tool to see what records predate that. 
>
> *sqlite3 /var/lib/weewx/weewx.sdb*
> sqlite> *select datetime(dateTime, 'unixepoch', 'localtime'), dateTime 
> from archive where dateTime < 1589241600;*
>
> If it's all garbage, then it's safe to delete these data:
>
> sqlite> *delete from archive where dateTime <1589241600;*
>
> Then drop and rebuild the daily summaries, just like you did before.
>
> Make a backup before you start.
>
> -tk
>
> On Wed, Oct 28, 2020 at 10:43 AM Alessandro Del Prete <
> [email protected]> wrote:
>
>> The full log is here: https://pastebin.com/f62DRnHL
>>
>> Luckily the reporting cycle started almost immediately, I noticed this " 
>> Daily summary cannot be used." error :
>>
>> Oct 28 18:17:27 ubuntu weewx[694317] DEBUG weewx.reportengine: Found 
>> configuration file /etc/weewx/skins/Seasons/skin.conf for report 
>> 'SeasonsReport'
>> Oct 28 18:17:27 ubuntu weewx[694317] DEBUG weewx.cheetahgenerator: Using 
>> search list ['weewx.cheetahgenerator.Almanac', 
>> 'weewx.cheetahgenerator.Station', 'weewx.cheetahgenerator.Current', 
>> 'weewx.cheetahgenerator.Stats', 'weewx.cheetahgenerator.UnitInfo', 
>> 'weewx.cheetahgenerator.Extras']
>> Oct 28 18:17:27 ubuntu weewx[694317] INFO weewx.restx: Hubitat: Published 
>> record 2020-10-28 18:17:17 CET (1603905437)
>> Oct 28 18:17:27 ubuntu weewx[694317] DEBUG weewx.manager: Daily summary 
>> version is 2.0
>> Oct 28 18:17:27 ubuntu weewx[694317] DEBUG weewx.xtypes: obs_type=wind; 
>> aggregate_type=count
>> Oct 28 18:17:27 ubuntu weewx[694317] DEBUG weewx.xtypes: 
>> timespan=[1972-10-01 00:00:00 CET (86742000) -> 1972-10-02 00:00:00 CET 
>> (86828400)]
>> Oct 28 18:17:27 ubuntu weewx[694317] DEBUG weewx.xtypes: 
>> first_timestamp=1970-01-01 01:01:00 CET (60); last_timestamp=2020-10-28 
>> 18:17:00 CET (1603905420)
>> Oct 28 18:17:27 ubuntu weewx[694317] DEBUG weewx.xtypes: *Daily summary 
>> cannot be used.*
>> Oct 28 18:17:27 ubuntu weewx[694317] ERROR weewx.cheetahgenerator: 
>> Generate failed with exception '<class 'NameMapper.NotFound'>'
>> Oct 28 18:17:27 ubuntu weewx[694317] ERROR weewx.cheetahgenerator: **** 
>> Ignoring template /etc/weewx/skins/Seasons/NOAA/NOAA-%Y-%m.txt.tmpl
>> Oct 28 18:17:27 ubuntu weewx[694317] ERROR weewx.cheetahgenerator: **** 
>> Reason: cannot find 'count' while searching for 'day.wind.count.raw'
>> Oct 28 18:17:27 ubuntu weewx[694317] ERROR weewx.cheetahgenerator: ****  
>> Traceback (most recent call last):
>> Oct 28 18:17:27 ubuntu weewx[694317] ERROR weewx.cheetahgenerator: ****  
>>   File "/usr/share/weewx/weewx/cheetahgenerator.py", line 322, in generate
>> Oct 28 18:17:27 ubuntu weewx[694317] ERROR weewx.cheetahgenerator: ****  
>>     unicode_string = compiled_template.respond()
>> Oct 28 18:17:27 ubuntu weewx[694317] ERROR weewx.cheetahgenerator: ****  
>>   File "_etc_weewx_skins_Seasons_NOAA_NOAA__Y__m_txt_tmpl.py", line 431, in 
>> respond
>> Oct 28 18:17:27 ubuntu weewx[694317] ERROR weewx.cheetahgenerator: ****  
>> NameMapper.NotFound: cannot find 'count' while searching for 
>> 'day.wind.count.raw'
>> Oct 28 18:17:27 ubuntu weewx[694317] DEBUG weewx.xtypes: obs_type=wind; 
>> aggregate_type=count
>> Oct 28 18:17:27 ubuntu weewx[694317] DEBUG weewx.xtypes: 
>> timespan=[1978-10-01 00:00:00 CET (276044400) -> 1978-10-02 00:00:00 CET 
>> (276130800)]
>> Oct 28 18:17:27 ubuntu weewx[694317] DEBUG weewx.xtypes: 
>> first_timestamp=1970-01-01 01:01:00 CET (60); last_timestamp=2020-10-28 
>> 18:17:00 CET (1603905420)
>> Oct 28 18:17:27 ubuntu weewx[694317] DEBUG weewx.xtypes: *Daily summary 
>> cannot be used.*
>> Oct 28 18:17:27 ubuntu weewx[694317] ERROR weewx.cheetahgenerator: 
>> Generate failed with exception '<class 'NameMapper.NotFound'>'
>> Oct 28 18:17:27 ubuntu weewx[694317] ERROR weewx.cheetahgenerator: **** 
>> Ignoring template /etc/weewx/skins/Seasons/NOAA/NOAA-%Y-%m.txt.tmpl
>> Oct 28 18:17:27 ubuntu weewx[694317] ERROR weewx.cheetahgenerator: **** 
>> Reason: cannot find 'count' while searching for 'day.wind.count.raw'
>> Oct 28 18:17:27 ubuntu weewx[694317] ERROR weewx.cheetahgenerator: ****  
>> Traceback (most recent call last):
>> Oct 28 18:17:27 ubuntu weewx[694317] ERROR weewx.cheetahgenerator: ****  
>>   File "/usr/share/weewx/weewx/cheetahgenerator.py", line 322, in generate
>> Oct 28 18:17:27 ubuntu weewx[694317] ERROR weewx.cheetahgenerator: ****  
>>     unicode_string = compiled_template.respond()
>> Oct 28 18:17:27 ubuntu weewx[694317] ERROR weewx.cheetahgenerator: ****  
>>   File "_etc_weewx_skins_Seasons_NOAA_NOAA__Y__m_txt_tmpl.py", line 431, in 
>> respond
>> Oct 28 18:17:27 ubuntu weewx[694317] ERROR weewx.cheetahgenerator: ****  
>> NameMapper.NotFound: cannot find 'count' while searching for 
>> 'day.wind.count.raw'
>> Oct 28 18:17:28 ubuntu weewx[694317] DEBUG weewx.xtypes: obs_type=wind; 
>> aggregate_type=count
>> Oct 28 18:17:28 ubuntu weewx[694317] DEBUG weewx.xtypes: 
>> timespan=[2020-10-01 00:00:00 CEST (1601503200) -> 2020-10-02 00:00:00 CEST 
>> (1601589600)]
>> Oct 28 18:17:28 ubuntu weewx[694317] DEBUG weewx.xtypes: 
>> first_timestamp=1970-01-01 01:01:00 CET (60); last_timestamp=2020-10-28 
>> 18:17:00 CET (1603905420)
>> Oct 28 18:17:28 ubuntu weewx[694317] DEBUG weewx.xtypes: Daily summary 
>> will be used.
>> Oct 28 18:17:28 ubuntu weewx[694317] DEBUG weewx.xtypes: obs_type=wind; 
>> aggregate_type=count
>> Oct 28 18:17:28 ubuntu weewx[694317] DEBUG weewx.xtypes: 
>> timespan=[2020-10-02 00:00:00 CEST (1601589600) -> 2020-10-03 00:00:00 CEST 
>> (1601676000)]
>> Oct 28 18:17:28 ubuntu weewx[694317] DEBUG weewx.xtypes: 
>> first_timestamp=1970-01-01 01:01:00 CET (60); last_timestamp=2020-10-28 
>> 18:17:00 CET (1603905420)
>> Oct 28 18:17:28 ubuntu weewx[694317] DEBUG weewx.xtypes: Daily summary 
>> will be used.
>> Oct 28 18:17:28 ubuntu weewx[694317] DEBUG weewx.xtypes: obs_type=wind; 
>> aggregate_type=count
>> Oct 28 18:17:28 ubuntu weewx[694317] DEBUG weewx.xtypes: 
>> timespan=[2020-10-03 00:00:00 CEST (1601676000) -> 2020-10-04 00:00:00 CEST 
>> (1601762400)]
>> Oct 28 18:17:28 ubuntu weewx[694317] DEBUG weewx.xtypes: 
>> first_timestamp=1970-01-01 01:01:00 CET (60); last_timestamp=2020-10-28 
>> 18:17:00 CET (1603905420)
>> Oct 28 18:17:28 ubuntu weewx[694317] DEBUG weewx.xtypes: Daily summary 
>> will be used.
>>
>> On Wednesday, October 28, 2020 at 4:29:27 PM UTC+1 [email protected] 
>> wrote:
>>
>>> The only other thing I can think of is that the Belchertown skin is 
>>> making a query on something other than midnight-to-midnight.
>>>
>>> We can check that. Please replace your copy of xtypes.py (you should 
>>> find it in /usr/share/weewx/weewx/xtypes.py) with the attached. It has been 
>>> instrumented to log the aggregation interval. 
>>>
>>> Run with debug=1 from startup through the first reporting cycle. Post 
>>> the full log. It could be rather voluminous, so you may want to post the 
>>> log as an attachment, or upload to a service such as pastebin.com.
>>>
>>> -tk
>>>
>>> On Wed, Oct 28, 2020 at 7:59 AM Alessandro Del Prete <
>>> [email protected]> wrote:
>>>
>>>> Done. And restarted weewx.
>>>>
>>>> Oct 28 15:32:21 ubuntu weewx[611964] ERROR weewx.cheetahgenerator: 
>>>> Generate failed with exception '<class 'NameMapper.NotFound'>'
>>>> Oct 28 15:32:21 ubuntu weewx[611964] ERROR weewx.cheetahgenerator: **** 
>>>> Ignoring template /etc/weewx/skins/Seasons/NOAA/NOAA-%Y-%m.txt.tmpl
>>>> Oct 28 15:32:21 ubuntu weewx[611964] ERROR weewx.cheetahgenerator: **** 
>>>> Reason: cannot find 'count' while searching for 'day.wind.count.raw'
>>>> Oct 28 15:32:21 ubuntu weewx[611964] ERROR weewx.cheetahgenerator: 
>>>> ****  Traceback (most recent call last):
>>>> Oct 28 15:32:21 ubuntu weewx[611964] ERROR weewx.cheetahgenerator: 
>>>> ****    File "/usr/share/weewx/weewx/cheetahgenerator.py", line 322, in 
>>>> generate
>>>> Oct 28 15:32:21 ubuntu weewx[611964] ERROR weewx.cheetahgenerator: 
>>>> ****      unicode_string = compiled_template.respond()
>>>> Oct 28 15:32:21 ubuntu weewx[611964] ERROR weewx.cheetahgenerator: 
>>>> ****    File "_etc_weewx_skins_Seasons_NOAA_NOAA__Y__m_txt_tmpl.py", line 
>>>> 431, in respond
>>>> Oct 28 15:32:21 ubuntu weewx[611964] ERROR weewx.cheetahgenerator: 
>>>> ****  NameMapper.NotFound: cannot find 'count' while searching for 
>>>> 'day.wind.count.raw'
>>>> Oct 28 15:32:21 ubuntu weewx[611964] ERROR weewx.cheetahgenerator: 
>>>> Generate failed with exception '<class 'NameMapper.NotFound'>'
>>>> Oct 28 15:32:21 ubuntu weewx[611964] ERROR weewx.cheetahgenerator: **** 
>>>> Ignoring template /etc/weewx/skins/Seasons/NOAA/NOAA-%Y-%m.txt.tmpl
>>>> Oct 28 15:32:21 ubuntu weewx[611964] ERROR weewx.cheetahgenerator: **** 
>>>> Reason: cannot find 'count' while searching for 'day.wind.count.raw'
>>>> Oct 28 15:32:21 ubuntu weewx[611964] ERROR weewx.cheetahgenerator: 
>>>> ****  Traceback (most recent call last):
>>>> Oct 28 15:32:21 ubuntu weewx[611964] ERROR weewx.cheetahgenerator: 
>>>> ****    File "/usr/share/weewx/weewx/cheetahgenerator.py", line 322, in 
>>>> generate
>>>> Oct 28 15:32:21 ubuntu weewx[611964] ERROR weewx.cheetahgenerator: 
>>>> ****      unicode_string = compiled_template.respond()
>>>> Oct 28 15:32:21 ubuntu weewx[611964] ERROR weewx.cheetahgenerator: 
>>>> ****    File "_etc_weewx_skins_Seasons_NOAA_NOAA__Y__m_txt_tmpl.py", line 
>>>> 431, in respond
>>>> Oct 28 15:32:21 ubuntu weewx[611964] ERROR weewx.cheetahgenerator: 
>>>> ****  NameMapper.NotFound: cannot find 'count' while searching for 
>>>> 'day.wind.count.raw'
>>>>
>>>>
>>>> On Wednesday, October 28, 2020 at 1:54:04 PM UTC+1 [email protected] 
>>>> wrote:
>>>>
>>>>> This error could happen if a query was made for aggregation periods 
>>>>> that do not run midnight-to-midnight, but I don't know why the 
>>>>> Belchertown 
>>>>> skin would do that.
>>>>>
>>>>> One thing to try: rebuilding the daily summaries.
>>>>>
>>>>> *wee_database --drop-daily*
>>>>> *wee_database --rebuild-daily*
>>>>>
>>>>> -tk
>>>>>
>>>>> On Wed, Oct 28, 2020 at 12:22 AM Alessandro Del Prete <
>>>>> [email protected]> wrote:
>>>>>
>>>>>> 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
>>>>>>  
>>>>>> <https://groups.google.com/d/msgid/weewx-user/c8a13b8e-c377-47dd-9477-21372e4b0261n%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/a80c017d-070d-4c90-b71b-8273d74cb5efn%40googlegroups.com
>>>>  
>>>> <https://groups.google.com/d/msgid/weewx-user/a80c017d-070d-4c90-b71b-8273d74cb5efn%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/0c24713c-71a7-4d9d-986d-7bee1272c9e9n%40googlegroups.com
>>  
>> <https://groups.google.com/d/msgid/weewx-user/0c24713c-71a7-4d9d-986d-7bee1272c9e9n%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/096e0603-497a-4c23-9080-8622713690b9n%40googlegroups.com.

Reply via email to