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 <gjroder...@gmail.com> 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+unsubscr...@googlegroups.com. > 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.