I have set up a Stretch VM using the same locale and timezone settings as you running a .deb weeWX install and I cannot reproduce the fault you are experiencing. This really brings me back to the your database. I will instrument one of the weeWX files with some extra logging so we can see exactly what is happening when the offending tag(s) is/are called. In the meantime can you confirm exactly what version of weeWX you are now running on the problem system (3.8.2 I am guessing) so that I can ensure I give you a compatible version of the file.
Gary On Friday, 9 November 2018 20:27:44 UTC+10, Jonis Maurin Ceará wrote: > > Sure! > And one more info: this error (wind) happens on all skins. > > pi@SkyWeather:~ $ locale >> LANG=en_GB.UTF-8 >> LANGUAGE= >> LC_CTYPE="en_GB.UTF-8" >> LC_NUMERIC="en_GB.UTF-8" >> LC_TIME="en_GB.UTF-8" >> LC_COLLATE="en_GB.UTF-8" >> LC_MONETARY="en_GB.UTF-8" >> LC_MESSAGES="en_GB.UTF-8" >> LC_PAPER="en_GB.UTF-8" >> LC_NAME="en_GB.UTF-8" >> LC_ADDRESS="en_GB.UTF-8" >> LC_TELEPHONE="en_GB.UTF-8" >> LC_MEASUREMENT="en_GB.UTF-8" >> LC_IDENTIFICATION="en_GB.UTF-8" >> LC_ALL= >> pi@SkyWeather:~ $ timedatectl >> Local time: Fri 2018-11-09 08:26:49 -02 >> Universal time: Fri 2018-11-09 10:26:49 UTC >> RTC time: n/a >> Time zone: America/Sao_Paulo (-02, -0200) >> Network time on: yes >> NTP synchronized: yes >> RTC in local TZ: no > > > > Em sex, 9 de nov de 2018 às 00:53, gjr80 <gjrod...@gmail.com <javascript:>> > escreveu: > >> I have not forgotten this. Definitely starting with a clean database: >> >> Nov 5 10:02:31 SkyWeather weewx[30088]: manager: Created and >> initialized table 'archive' in database 'weewx.sdb' >> Nov 5 10:02:31 SkyWeather weewx[30088]: manager: Created daily summary >> tables >> >> Interesting that the only template that fails is week.html.tmpl, all of >> its friends (index.html.tmpl, month.html.tmpl and year.html.tmpl) also >> contain wind tags but only week.html.tmpl fails. Suggests the issue is >> confined to week.wind.xxx. >> >> Can I ask you to run a couple of commands on your weeWX system and post >> the output. The commands are: >> >> locale >> timedatectl >> >> >> Gary >> >> >> On Tuesday, 6 November 2018 23:50:02 UTC+10, Jonis Maurin Ceará wrote: >>> >>> Yes, logs from fresh install yesterday. >>> >>> >>> Nov 5 10:02:31 SkyWeather weewx[30084]: engine: Initializing weewx >>>>> version 3.8.2 >>>> >>>> Nov 5 10:02:31 SkyWeather weewx[30084]: engine: Using Python 2.7.13 >>>>> (default, Sep 26 2018, 18:42:22) #012[GCC 6.3.0 20170516] >>>> >>>> Nov 5 10:02:31 SkyWeather weewx[30084]: engine: Platform >>>>> Linux-4.14.71-v7+-armv7l-with-debian-9.4 >>>> >>>> Nov 5 10:02:31 SkyWeather weewx[30084]: engine: Locale is 'en_GB.UTF-8' >>>> >>>> Nov 5 10:02:31 SkyWeather weewx[30084]: engine: pid file is >>>>> /var/run/weewx.pid >>>> >>>> Nov 5 10:02:31 SkyWeather weewx[30088]: engine: Using configuration >>>>> file /etc/weewx/weewx.conf >>>> >>>> Nov 5 10:02:31 SkyWeather weewx[30088]: engine: Loading station type >>>>> Simulator (weewx.drivers.simulator) >>>> >>>> Nov 5 10:02:31 SkyWeather weewx[30073]: Starting weewx weather system: >>>>> weewx. >>>> >>>> Nov 5 10:02:31 SkyWeather weewx[30088]: engine: StdConvert target unit >>>>> is 0x1 >>>> >>>> Nov 5 10:02:31 SkyWeather weewx[30088]: wxcalculate: The following >>>>> values will be calculated: barometer=prefer_hardware, >>>>> windchill=prefer_hardware, dewpoint=prefer_hardware, >>>>> appTemp=prefer_hardware, rainRate=prefer_hardware, >>>>> windrun=prefer_hardware, >>>>> heatindex=prefer_hardware, maxSolarRad=prefer_hardware, >>>>> humidex=prefer_hardware, pressure=prefer_hardware, >>>>> inDewpoint=prefer_hardware, ET=prefer_hardware, >>>>> altimeter=prefer_hardware, >>>>> cloudbase=prefer_hardware >>>> >>>> Nov 5 10:02:31 SkyWeather weewx[30088]: wxcalculate: The following >>>>> algorithms will be used for calculations: altimeter=aaNOAA, maxSolarRad=RS >>>> >>>> Nov 5 10:02:31 SkyWeather weewx[30088]: engine: Archive will use data >>>>> binding wx_binding >>>> >>>> Nov 5 10:02:31 SkyWeather weewx[30088]: engine: Record generation will >>>>> be attempted in 'hardware' >>>> >>>> Nov 5 10:02:31 SkyWeather weewx[30088]: engine: Using archive interval >>>>> of 300 seconds (specified in weewx configuration) >>>> >>>> Nov 5 10:02:31 SkyWeather weewx[30088]: manager: Created and >>>>> initialized table 'archive' in database 'weewx.sdb' >>>> >>>> Nov 5 10:02:31 SkyWeather weewx[30088]: manager: Created daily summary >>>>> tables >>>> >>>> Nov 5 10:02:31 SkyWeather weewx[30088]: engine: Using binding >>>>> 'wx_binding' to database 'weewx.sdb' >>>> >>>> Nov 5 10:02:31 SkyWeather weewx[30088]: manager: Starting backfill of >>>>> daily summaries >>>> >>>> Nov 5 10:02:31 SkyWeather weewx[30088]: restx: StationRegistry: >>>>> Registration not requested. >>>> >>>> Nov 5 10:02:31 SkyWeather weewx[30088]: restx: Wunderground: Posting >>>>> not enabled. >>>> >>>> Nov 5 10:02:31 SkyWeather weewx[30088]: restx: PWSweather: Posting not >>>>> enabled. >>>> >>>> Nov 5 10:02:31 SkyWeather weewx[30088]: restx: CWOP: Posting not >>>>> enabled. >>>> >>>> Nov 5 10:02:31 SkyWeather weewx[30088]: restx: WOW: Posting not >>>>> enabled. >>>> >>>> Nov 5 10:02:31 SkyWeather weewx[30088]: restx: AWEKAS: Posting not >>>>> enabled. >>>> >>>> Nov 5 10:02:31 SkyWeather weewx[30088]: engine: Starting up weewx >>>>> version 3.8.2 >>>> >>>> Nov 5 10:02:31 SkyWeather weewx[30088]: engine: Clock error is -0.30 >>>>> seconds (positive is fast) >>>> >>>> Nov 5 10:02:31 SkyWeather weewx[30088]: engine: Starting main packet >>>>> loop. >>>> >>>> Nov 5 10:05:16 SkyWeather weewx[30088]: manager: Added record >>>>> 2018-11-05 10:05:00 -02 (1541419500) to database 'weewx.sdb' >>>> >>>> Nov 5 10:05:16 SkyWeather weewx[30088]: manager: Added record >>>>> 2018-11-05 10:05:00 -02 (1541419500) to daily summary in 'weewx.sdb' >>>> >>>> Nov 5 10:05:19 SkyWeather weewx[30088]: cheetahgenerator: Generate >>>>> failed with exception '<class 'weedb.NoColumnError'>' >>>> >>>> Nov 5 10:05:19 SkyWeather weewx[30088]: cheetahgenerator: **** >>>>> Ignoring template /etc/weewx/skins/Standard/week.html.tmpl >>>> >>>> Nov 5 10:05:19 SkyWeather weewx[30088]: cheetahgenerator: **** Reason: >>>>> no such column: wind >>>> >>>> Nov 5 10:05:19 SkyWeather weewx[30088]: **** Traceback (most recent >>>>> call last): >>>> >>>> Nov 5 10:05:19 SkyWeather weewx[30088]: **** File >>>>> "/usr/share/weewx/weewx/cheetahgenerator.py", line 330, in generate >>>> >>>> Nov 5 10:05:19 SkyWeather weewx[30088]: **** print >> _file, >>>>> compiled_template >>>> >>>> Nov 5 10:05:19 SkyWeather weewx[30088]: **** File >>>>> "/usr/lib/python2.7/dist-packages/Cheetah/Template.py", line 1005, in >>>>> __str__ >>>> >>>> Nov 5 10:05:19 SkyWeather weewx[30088]: **** rc = getattr(self, >>>>> mainMethName)() >>>> >>>> Nov 5 10:05:19 SkyWeather weewx[30088]: **** File >>>>> "_etc_weewx_skins_Standard_week_html_tmpl.py", line 949, in respond >>>> >>>> Nov 5 10:05:19 SkyWeather weewx[30088]: **** File >>>>> "_etc_weewx_skins_Standard_week_html_tmpl.py", line 245, in >>>>> __errorCatcher26 >>>> >>>> Nov 5 10:05:19 SkyWeather weewx[30088]: **** File "<string>", line >>>>> 1, in <module> >>>> >>>> Nov 5 10:05:19 SkyWeather weewx[30088]: **** File >>>>> "/usr/share/weewx/weewx/tags.py", line 329, in __getattr__ >>>> >>>> Nov 5 10:05:19 SkyWeather weewx[30088]: **** return >>>>> self._do_query(aggregate_type) >>>> >>>> Nov 5 10:05:19 SkyWeather weewx[30088]: **** File >>>>> "/usr/share/weewx/weewx/tags.py", line 343, in _do_query >>>> >>>> Nov 5 10:05:19 SkyWeather weewx[30088]: **** val=val, >>>>> **self.option_dict) >>>> >>>> Nov 5 10:05:19 SkyWeather weewx[30088]: **** File >>>>> "/usr/share/weewx/weewx/wxmanager.py", line 60, in getAggregate >>>> >>>> Nov 5 10:05:19 SkyWeather weewx[30088]: **** return >>>>> weewx.manager.DaySummaryManager.getAggregate(self, timespan, obs_type, >>>>> aggregateType, **option_dict) >>>> >>>> Nov 5 10:05:19 SkyWeather weewx[30088]: **** File >>>>> "/usr/share/weewx/weewx/manager.py", line 1249, in getAggregate >>>> >>>> Nov 5 10:05:19 SkyWeather weewx[30088]: **** **option_dict) >>>> >>>> Nov 5 10:05:19 SkyWeather weewx[30088]: **** File >>>>> "/usr/share/weewx/weewx/manager.py", line 458, in getAggregate >>>> >>>> Nov 5 10:05:19 SkyWeather weewx[30088]: **** _row = >>>>> self.getSql(select_stmt % interpolate_dict) >>>> >>>> Nov 5 10:05:19 SkyWeather weewx[30088]: **** File >>>>> "/usr/share/weewx/weewx/manager.py", line 394, in getSql >>>> >>>> Nov 5 10:05:19 SkyWeather weewx[30088]: **** _cursor.execute(sql, >>>>> sqlargs) >>>> >>>> Nov 5 10:05:19 SkyWeather weewx[30088]: **** File >>>>> "/usr/share/weewx/weedb/sqlite.py", line 41, in guarded_fn >>>> >>>> Nov 5 10:05:19 SkyWeather weewx[30088]: **** raise >>>>> weedb.NoColumnError(e) >>>> >>>> Nov 5 10:05:19 SkyWeather weewx[30088]: **** NoColumnError: no such >>>>> column: wind >>>> >>>> Nov 5 10:05:23 SkyWeather weewx[30088]: cheetahgenerator: Generated 13 >>>>> files for report StandardReport in 6.81 seconds >>>> >>>> Nov 5 10:05:31 SkyWeather weewx[30088]: imagegenerator: Generated 49 >>>>> images for StandardReport in 7.38 seconds >>>> >>>> Nov 5 10:05:31 SkyWeather weewx[30088]: copygenerator: copied 9 files >>>>> to /var/www/html/weewx >>>> >>>> Nov 5 10:10:16 SkyWeather weewx[30088]: manager: Added record >>>>> 2018-11-05 10:10:00 -02 (1541419800) to database 'weewx.sdb' >>>> >>>> Nov 5 10:10:16 SkyWeather weewx[30088]: manager: Added record >>>>> 2018-11-05 10:10:00 -02 (1541419800) to daily summary in 'weewx.sdb' >>>> >>>> Nov 5 10:10:17 SkyWeather weewx[30088]: cheetahgenerator: Generate >>>>> failed with exception '<class 'weedb.NoColumnError'>' >>>> >>>> Nov 5 10:10:17 SkyWeather weewx[30088]: cheetahgenerator: **** >>>>> Ignoring template /etc/weewx/skins/Standard/week.html.tmpl >>>> >>>> Nov 5 10:10:17 SkyWeather weewx[30088]: cheetahgenerator: **** Reason: >>>>> no such column: wind >>>> >>>> Nov 5 10:10:17 SkyWeather weewx[30088]: **** Traceback (most recent >>>>> call last): >>>> >>>> Nov 5 10:10:17 SkyWeather weewx[30088]: **** File >>>>> "/usr/share/weewx/weewx/cheetahgenerator.py", line 330, in generate >>>> >>>> Nov 5 10:10:17 SkyWeather weewx[30088]: **** print >> _file, >>>>> compiled_template >>>> >>>> Nov 5 10:10:17 SkyWeather weewx[30088]: **** File >>>>> "/usr/lib/python2.7/dist-packages/Cheetah/Template.py", line 1005, in >>>>> __str__ >>>> >>>> Nov 5 10:10:17 SkyWeather weewx[30088]: **** rc = getattr(self, >>>>> mainMethName)() >>>> >>>> Nov 5 10:10:17 SkyWeather weewx[30088]: **** File >>>>> "_etc_weewx_skins_Standard_week_html_tmpl.py", line 949, in respond >>>> >>>> Nov 5 10:10:17 SkyWeather weewx[30088]: **** File >>>>> "_etc_weewx_skins_Standard_week_html_tmpl.py", line 245, in >>>>> __errorCatcher26 >>>> >>>> Nov 5 10:10:17 SkyWeather weewx[30088]: **** File "<string>", line >>>>> 1, in <module> >>>> >>>> Nov 5 10:10:17 SkyWeather weewx[30088]: **** File >>>>> "/usr/share/weewx/weewx/tags.py", line 329, in __getattr__ >>>> >>>> Nov 5 10:10:17 SkyWeather weewx[30088]: **** return >>>>> self._do_query(aggregate_type) >>>> >>>> Nov 5 10:10:17 SkyWeather weewx[30088]: **** File >>>>> "/usr/share/weewx/weewx/tags.py", line 343, in _do_query >>>> >>>> Nov 5 10:10:17 SkyWeather weewx[30088]: **** val=val, >>>>> **self.option_dict) >>>> >>>> Nov 5 10:10:17 SkyWeather weewx[30088]: **** File >>>>> "/usr/share/weewx/weewx/wxmanager.py", line 60, in getAggregate >>>> >>>> Nov 5 10:10:17 SkyWeather weewx[30088]: **** return >>>>> weewx.manager.DaySummaryManager.getAggregate(self, timespan, obs_type, >>>>> aggregateType, **option_dict) >>>> >>>> Nov 5 10:10:17 SkyWeather weewx[30088]: **** File >>>>> "/usr/share/weewx/weewx/manager.py", line 1249, in getAggregate >>>> >>>> Nov 5 10:10:17 SkyWeather weewx[30088]: **** **option_dict) >>>> >>>> Nov 5 10:10:17 SkyWeather weewx[30088]: **** File >>>>> "/usr/share/weewx/weewx/manager.py", line 458, in getAggregate >>>> >>>> Nov 5 10:10:17 SkyWeather weewx[30088]: **** _row = >>>>> self.getSql(select_stmt % interpolate_dict) >>>> >>>> Nov 5 10:10:17 SkyWeather weewx[30088]: **** File >>>>> "/usr/share/weewx/weewx/manager.py", line 394, in getSql >>>> >>>> Nov 5 10:10:17 SkyWeather weewx[30088]: **** _cursor.execute(sql, >>>>> sqlargs) >>>> >>>> Nov 5 10:10:17 SkyWeather weewx[30088]: **** File >>>>> "/usr/share/weewx/weedb/sqlite.py", line 41, in guarded_fn >>>> >>>> Nov 5 10:10:17 SkyWeather weewx[30088]: **** raise >>>>> weedb.NoColumnError(e) >>>> >>>> Nov 5 10:10:17 SkyWeather weewx[30088]: **** NoColumnError: no such >>>>> column: wind >>>> >>>> Nov 5 10:10:18 SkyWeather weewx[30088]: cheetahgenerator: Generated 13 >>>>> files for report StandardReport in 2.02 seconds >>>> >>>> Nov 5 10:10:19 SkyWeather weewx[30088]: imagegenerator: Generated 12 >>>>> images for StandardReport in 0.98 seconds >>>> >>>> Nov 5 10:10:19 SkyWeather weewx[30088]: copygenerator: copied 0 files >>>>> to /var/www/html/weewx >>>> >>>> >>>> >>> Em seg, 5 de nov de 2018 às 22:37, gjr80 <gjrod...@gmail.com> escreveu: >>> >>>> Ok, the problem is that if you are starting from a clean install >>>> (including database) running the simulator after a daylight savings change >>>> the timezone/daylight savings state of your system is irrelevant, all >>>> times/timestamps are drawn from the system clock and if it is not changing >>>> (since the daylight saving cutover was in the past) then daylight saving >>>> cannot be the cause of the error. >>>> >>>> Do you still have the logs on your system from when you did the clean >>>> install using simulator and SQLite? If so can you post the log from when >>>> weeWX first started after that install through until the error appeared. >>>> If >>>> you don't have the logs then please do a clean install using the simulator >>>> and SQLite and provide the log showing weeWX startup through until the >>>> error occurs. >>>> >>>> Gary >>>> >>>> On Tuesday, 6 November 2018 09:59:06 UTC+10, Jonis Maurin Ceará wrote: >>>>> >>>>> Ok, let me explain: >>>>> >>>>> 1) Remove all packages and files relates to weewx (including all dir >>>>> and subdirs on /etc/weewx, /usr/share/weewx, /var/lib/weewx or >>>>> /usr/lib/weewx, don't rememebr now). Everything >>>>> 2) Install from .deb package and accept default settings (name, >>>>> location, driver=simulation, etc...) >>>>> 3) Just start, done! >>>>> >>>>> When you access webpage, loads fine.....but still the same error in >>>>> logfile, wind column not found (of course, the error is using sqlite, and >>>>> not mysqllite like I posted). >>>>> >>>>> Second attempt: >>>>> 1) Change archive database to mysql instead of sqlite. >>>>> 2) Re-start weewx. Tables are created and archive page is created >>>>> 3) Still the same problem on log (wind column), but information on >>>>> log's say 'mysql' driver, and not sqlite. >>>>> >>>>> And then with fileparser driver, with exactly same results.... >>>>> >>>>> >>>>> I found something related to brazilian daylight saving time, but I >>>>> lost the link of thread and also I don't knwo where to put suggested user >>>>> code (is modification of core code, I think). >>>>> >>>>> >>>>> Em seg, 5 de nov de 2018 às 21:31, gjr80 <gjrod...@gmail.com> >>>>> escreveu: >>>>> >>>>>> On Tuesday, 6 November 2018 01:57:22 UTC+10, Jonis Maurin Ceará wrote: >>>>>>> >>>>>>> Content of /tmp/weather.data: >>>>>>> >>>>>>> rainRate=0.0 >>>>>>> windSpeed=10.0466685247 >>>>>>> windGust=16.3395133004 >>>>>>> pressure=28.0709227 >>>>>>> outTemp=84.2 >>>>>>> outHumidity=71.1999969482 >>>>>>> windDir=0.0 >>>>>>> UV=1.59 >>>>>>> VIS=554 >>>>>>> >>>>>> >>>>>> OK, so dateTime is not being overridden by your source data (for >>>>>> fileparse driver the default is for the dateTime field to be set from >>>>>> the >>>>>> system time). >>>>>> >>>>>> But the problem is that this errors ocours even with simulator on >>>>>>> fresh install.... >>>>>>> >>>>>> >>>>>> There must be more to this. What do you mean by 'simulator on fresh >>>>>> install'. A fresh install of weeWX using the simulator I presume, but >>>>>> what >>>>>> about your database? You were using MySQL so a new weeWX install does >>>>>> not >>>>>> necessarily mean a clean database, whereas a new install using SQLite >>>>>> does >>>>>> erase the database. My apologies if your situation is very clear to you, >>>>>> but you have used two drivers, two different database engines and two >>>>>> versions of weeWX so it is not very clear to me exactly what your >>>>>> current >>>>>> setup is. >>>>>> >>>>>> Gary >>>>>> >>>>>> -- >>>>>> You received this message because you are subscribed to a topic in >>>>>> the Google Groups "weewx-user" group. >>>>>> To unsubscribe from this topic, visit >>>>>> https://groups.google.com/d/topic/weewx-user/llOh8p8emYY/unsubscribe. >>>>>> To unsubscribe from this group and all its topics, send an email to >>>>>> weewx-user+...@googlegroups.com. >>>>>> For more options, visit https://groups.google.com/d/optout. >>>>>> >>>>> -- >>>> You received this message because you are subscribed to a topic in the >>>> Google Groups "weewx-user" group. >>>> To unsubscribe from this topic, visit >>>> https://groups.google.com/d/topic/weewx-user/llOh8p8emYY/unsubscribe. >>>> To unsubscribe from this group and all its topics, send an email to >>>> weewx-user+...@googlegroups.com. >>>> For more options, visit https://groups.google.com/d/optout. >>>> >>> -- >> You received this message because you are subscribed to a topic in the >> Google Groups "weewx-user" group. >> To unsubscribe from this topic, visit >> https://groups.google.com/d/topic/weewx-user/llOh8p8emYY/unsubscribe. >> To unsubscribe from this group and all its topics, send an email to >> weewx-user+...@googlegroups.com <javascript:>. >> For more options, visit https://groups.google.com/d/optout. >> > -- 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 weewx-user+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
