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 <[email protected]> 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 <[email protected]> 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 >>> [email protected]. >>> 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 > [email protected]. > 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 [email protected]. For more options, visit https://groups.google.com/d/optout.
