Error when trying to get data for the first time

85 views
Skip to first unread message

lilian...@gmail.com

unread,
Sep 26, 2017, 5:27:23 AM9/26/17
to weewx-user
Hi,

After a long long pause, I came back to my weather station to get it connected to my raspberry pi.

I just did a fresh install of raspbian, installed and configured mysql (mariadb), installed and configured weewx.

When I connect the weather station (wmr200) thru usb and restart weewx, here is what I get in syslog (debug=1). The tables have been created by weewx but all tables are empty :

Sep 26 10:37:01 raspberrypi systemd[1]: Stopping LSB: weewx weather system...
Sep 26 10:37:02 raspberrypi weewx[1115]: Stopping weewx weather system: weewx not running....
Sep 26 10:37:02 raspberrypi systemd[1]: Stopped LSB: weewx weather system.
Sep 26 10:37:02 raspberrypi systemd[1]: Starting LSB: weewx weather system...
Sep 26 10:37:04 raspberrypi weewx[1141]: engine: Initializing weewx version 3.7.1
Sep 26 10:37:04 raspberrypi weewx[1141]: engine: Using Python 2.7.13 (default, Jan 19 2017, 14:48:08) #012[GCC 6.3.0 20170124]
Sep 26 10:37:04 raspberrypi weewx[1141]: engine: Platform Linux-4.9.41+-armv6l-with-debian-9.1
Sep 26 10:37:04 raspberrypi weewx[1141]: engine: Locale is 'fr_CH.UTF-8'
Sep 26 10:37:04 raspberrypi weewx[1141]: engine: pid file is /var/run/weewx.pid
Sep 26 10:37:04 raspberrypi weewx[1130]: Starting weewx weather system: weewx.
Sep 26 10:37:04 raspberrypi systemd[1]: Started LSB: weewx weather system.
Sep 26 10:37:04 raspberrypi weewx[1145]: engine: Using configuration file /etc/weewx/weewx.conf
Sep 26 10:37:04 raspberrypi weewx[1145]: engine: debug is 1
Sep 26 10:37:04 raspberrypi weewx[1145]: engine: Initializing engine
Sep 26 10:37:04 raspberrypi weewx[1145]: engine: Loading station type WMR200 (weewx.drivers.wmr200)
Sep 26 10:37:05 raspberrypi weewx[1145]: wmr200: MainThread: I driver version is 3.3.1
Sep 26 10:37:05 raspberrypi weewx[1145]: wmr200: MainThread: I sensor map is {'outTempBatteryStatus': 'battery_status_out', 'outHumidity': 'humidity_1', 'rainRate': 'rain_rate', 'heatindex4': 'heatindex_5', 'rainTotal': 'rain_total', 'rainBatteryStatus': 'battery_status_rain', 'heatindex6': 'heatindex_7', 'extraTemp5': 'temperature_6', 'uvFault': 'uv_fault', 'extraTemp2': 'temperature_3', 'heatindex': 'heatindex_1', 'extraTemp3': 'temperature_4', 'rain24': 'rain_24', 'inHeatindex': 'heatindex_0', 'inTemp': 'temperature_0', 'extraTemp1': 'temperature_2', 'hourRain': 'rain_hour', 'windFault': 'wind_fault', 'windchill': 'windchill', 'clockUnsynchronized': 'clock_unsynchronized', 'extraTemp7': 'temperature_8', 'rain': 'rain', 'forecastIcon': 'forecast_icon', 'pressure': 'pressure', 'extraHumid4': 'humidity_5', 'extraHumid5': 'humidity_6', 'extraHumid2': 'humidity_3', 'extraHumid3': 'humidity_4', 'extraHumid1': 'humidity_2', 'extraTemp6': 'temperature_7', 'heatindex5': 'heatindex_6', 'extraTemp4': 'temperature_5', 'heatindex7': 'heatindex_8', 'altimeter': 'altimeter', 'heatindex1': 'heatindex_2', 'heatindex2': 'heatindex_3', 'heatindex3': 'heatindex_4', 'extraHumid6': 'humidity_7', 'extraHumid7': 'humidity_8', 'windBatteryStatus': 'battery_status_wind', 'UV': 'uv', 'rainFault': 'rain_fault', 'windDir': 'wind_dir', 'outTemp': 'temperature_1', 'windSpeed': 'wind_speed', 'inHumidity': 'humidity_0', 'outTempFault': 'out_fault', 'windGust': 'wind_gust', 'uvBatteryStatus': 'battery_status_uv'}
Sep 26 10:37:05 raspberrypi weewx[1145]: wmr200: MainThread: I Created watchdog thread to poke for live data every 30 seconds
Sep 26 10:37:05 raspberrypi weewx[1145]: wmr200: MainThread: I Created USB polling thread to read block on device
Sep 26 10:37:05 raspberrypi weewx[1145]: wmr200: Thread-2: I USB polling device thread for live data launched
Sep 26 10:37:05 raspberrypi weewx[1145]: wmr200: MainThread: I Reset console device
Sep 26 10:37:06 raspberrypi weewx[1145]: wmr200: Thread-2: I USB polling device thread signaled to start
Sep 26 10:37:06 raspberrypi weewx[1145]: wmr200: MainThread: D Configuration setup
Sep 26 10:37:06 raspberrypi weewx[1145]: wmr200: MainThread: D Log sensor faults: True
Sep 26 10:37:06 raspberrypi weewx[1145]: wmr200: MainThread: D Using PC Time: True
Sep 26 10:37:06 raspberrypi weewx[1145]: wmr200: MainThread: D Erase archive data: False
Sep 26 10:37:06 raspberrypi weewx[1145]: wmr200: MainThread: D Archive interval: 60
Sep 26 10:37:06 raspberrypi weewx[1145]: wmr200: MainThread: D Archive threshold: 604800
Sep 26 10:37:06 raspberrypi weewx[1145]: engine: Loading service weewx.engine.StdTimeSynch
Sep 26 10:37:06 raspberrypi weewx[1145]: engine: Finished loading service weewx.engine.StdTimeSynch
Sep 26 10:37:06 raspberrypi weewx[1145]: engine: Loading service weewx.engine.StdConvert
Sep 26 10:37:06 raspberrypi weewx[1145]: engine: StdConvert target unit is 0x1
Sep 26 10:37:06 raspberrypi weewx[1145]: engine: Finished loading service weewx.engine.StdConvert
Sep 26 10:37:06 raspberrypi weewx[1145]: engine: Loading service weewx.engine.StdCalibrate
Sep 26 10:37:06 raspberrypi weewx[1145]: wmr200: Thread-1: I Started watchdog thread live data
Sep 26 10:37:06 raspberrypi weewx[1145]: engine: Finished loading service weewx.engine.StdCalibrate
Sep 26 10:37:06 raspberrypi weewx[1145]: engine: Loading service weewx.engine.StdQC
Sep 26 10:37:06 raspberrypi weewx[1145]: engine: Finished loading service weewx.engine.StdQC
Sep 26 10:37:06 raspberrypi weewx[1145]: engine: Loading service weewx.wxservices.StdWXCalculate
Sep 26 10:37:06 raspberrypi weewx[1145]: wxcalculate: The following values will be calculated: barometer=prefer_hardware, windchill=hardware, dewpoint=prefer_hardware, appTemp=prefer_hardware, rainRate=hardware, windrun=prefer_hardware, heatindex=hardware, maxSolarRad=prefer_hardware, humidex=prefer_hardware, pressure=prefer_hardware, inDewpoint=prefer_hardware, ET=prefer_hardware, altimeter=prefer_hardware, cloudbase=prefer_hardware
Sep 26 10:37:06 raspberrypi weewx[1145]: wxcalculate: The following algorithms will be used for calculations: altimeter=aaNOAA, maxSolarRad=RS
Sep 26 10:37:06 raspberrypi weewx[1145]: engine: Finished loading service weewx.wxservices.StdWXCalculate
Sep 26 10:37:06 raspberrypi weewx[1145]: engine: Loading service weewx.engine.StdArchive
Sep 26 10:37:06 raspberrypi weewx[1145]: engine: Archive will use data binding wx_binding
Sep 26 10:37:07 raspberrypi weewx[1145]: engine: Record generation will be attempted in 'hardware'
Sep 26 10:37:07 raspberrypi weewx[1145]: engine: The archive interval in the configuration file (300) does not match the station hardware interval (60).
Sep 26 10:37:07 raspberrypi weewx[1145]: engine: Using archive interval of 60 seconds (specified by hardware)
Sep 26 10:37:07 raspberrypi weewx[1145]: engine: Use LOOP data in hi/low calculations: 1
Sep 26 10:37:07 raspberrypi weewx[1145]: manager: Daily summary version is 2.0
Sep 26 10:37:07 raspberrypi weewx[1145]: engine: Using binding 'wx_binding' to database 'weewx'
Sep 26 10:37:07 raspberrypi weewx[1145]: manager: Starting backfill of daily summaries
Sep 26 10:37:07 raspberrypi weewx[1145]: engine: Finished loading service weewx.engine.StdArchive
Sep 26 10:37:07 raspberrypi weewx[1145]: engine: Loading service weewx.restx.StdStationRegistry
Sep 26 10:37:07 raspberrypi weewx[1145]: restx: StationRegistry: Registration not requested.
Sep 26 10:37:07 raspberrypi weewx[1145]: engine: Finished loading service weewx.restx.StdStationRegistry
Sep 26 10:37:07 raspberrypi weewx[1145]: engine: Loading service weewx.restx.StdWunderground
Sep 26 10:37:07 raspberrypi weewx[1145]: restx: Wunderground: Posting not enabled.
Sep 26 10:37:07 raspberrypi weewx[1145]: engine: Finished loading service weewx.restx.StdWunderground
Sep 26 10:37:07 raspberrypi weewx[1145]: engine: Loading service weewx.restx.StdPWSweather
Sep 26 10:37:07 raspberrypi weewx[1145]: restx: PWSweather: Posting not enabled.
Sep 26 10:37:07 raspberrypi weewx[1145]: engine: Finished loading service weewx.restx.StdPWSweather
Sep 26 10:37:07 raspberrypi weewx[1145]: engine: Loading service weewx.restx.StdCWOP
Sep 26 10:37:07 raspberrypi weewx[1145]: restx: CWOP: Posting not enabled.
Sep 26 10:37:07 raspberrypi weewx[1145]: engine: Finished loading service weewx.restx.StdCWOP
Sep 26 10:37:07 raspberrypi weewx[1145]: engine: Loading service weewx.restx.StdWOW
Sep 26 10:37:08 raspberrypi weewx[1145]: restx: WOW: Posting not enabled.
Sep 26 10:37:08 raspberrypi weewx[1145]: engine: Finished loading service weewx.restx.StdWOW
Sep 26 10:37:08 raspberrypi weewx[1145]: engine: Loading service weewx.restx.StdAWEKAS
Sep 26 10:37:08 raspberrypi weewx[1145]: restx: AWEKAS: Posting not enabled.
Sep 26 10:37:08 raspberrypi weewx[1145]: engine: Finished loading service weewx.restx.StdAWEKAS
Sep 26 10:37:08 raspberrypi weewx[1145]: engine: Loading service weewx.engine.StdPrint
Sep 26 10:37:08 raspberrypi weewx[1145]: engine: Finished loading service weewx.engine.StdPrint
Sep 26 10:37:08 raspberrypi weewx[1145]: engine: Loading service weewx.engine.StdReport
Sep 26 10:37:08 raspberrypi weewx[1145]: engine: Finished loading service weewx.engine.StdReport
Sep 26 10:37:08 raspberrypi weewx[1145]: engine: Starting up weewx version 3.7.1
Sep 26 10:37:08 raspberrypi weewx[1145]: engine: Station does not support reading the time
Sep 26 10:37:08 raspberrypi weewx[1145]: wmr200: MainThread: D genStartup() phase getting archive packets since ******* N/A *******     (    N/A   )
Sep 26 10:37:08 raspberrypi weewx[1145]: wmr200: MainThread: I genStartup() Database initialization
Sep 26 10:37:16 raspberrypi weewx[1145]: wmr200: MainThread: I Time drift between host and console in seconds:16
Sep 26 10:37:16 raspberrypi weewx[1145]: wmr200: MainThread: D Queuing live packet rx:1 live_queue_len:1
Sep 26 10:37:26 raspberrypi weewx[1145]: wmr200: MainThread: D Queuing live packet rx:2 live_queue_len:2
Sep 26 10:37:36 raspberrypi weewx[1145]: wmr200: MainThread: D Queuing live packet rx:3 live_queue_len:3
Sep 26 10:37:39 raspberrypi weewx[1145]: wmr200: MainThread: D Queuing archive packet rx:1 archive_queue_len:1
Sep 26 10:37:40 raspberrypi weewx[1145]: wmr200: MainThread: I genStartup() Still receiving archive packets cnt:0 len:1
Sep 26 10:37:40 raspberrypi weewx[1145]: wmr200: MainThread: I Using pc time adjusting archive record time by 16 sec 2014-06-15 17:21:00 CEST (1402845660) => 2014-06-15 17:21:16 CEST (1402845676)
Sep 26 10:37:40 raspberrypi weewx[1145]: wmr200: MainThread: D Initializing Archive Data.rain_total_last to 72.14
Sep 26 10:37:40 raspberrypi weewx[1145]: wmr200: MainThread: D genStartup() Yielding received archive record cnt:1 after requested timestamp:0 pkt_interval:0 pkt:2014-06-15 17:21:16 CEST (1402845676)
Sep 26 10:37:40 raspberrypi weewx[1145]: manager: Added record 2014-06-15 17:21:16 CEST (1402845676) to database 'weewx'
Sep 26 10:37:40 raspberrypi weewx[1145]: engine: Main loop exiting. Shutting engine down.
Sep 26 10:37:40 raspberrypi weewx[1145]: wmr200: Thread-2: I USB polling device thread exiting
Sep 26 10:37:40 raspberrypi weewx[1145]: wmr200: MainThread: I USB polling thread expired
Sep 26 10:37:40 raspberrypi weewx[1145]: wmr200: Thread-1: I Watchdog received shutdown
Sep 26 10:37:40 raspberrypi weewx[1145]: wmr200: Thread-1: I Watchdog thread exiting
Sep 26 10:37:40 raspberrypi weewx[1145]: wmr200: MainThread: I Watchdog thread expired
Sep 26 10:37:40 raspberrypi weewx[1145]: wmr200: MainThread: I Received packet count live:3 archive:1 control:0
Sep 26 10:37:40 raspberrypi weewx[1145]: wmr200: MainThread: I Received bytes:568 sent bytes:40
Sep 26 10:37:40 raspberrypi weewx[1145]: wmr200: MainThread: I Packet archive queue len:0 live queue len:3
Sep 26 10:37:40 raspberrypi weewx[1145]: wmr200: MainThread: W Exiting with packets still in live queue cnt:3
Sep 26 10:37:40 raspberrypi weewx[1145]: wmr200: MainThread: I Driver gracefully exiting
Sep 26 10:37:40 raspberrypi weewx[1145]: engine: Caught unrecoverable exception in engine:
Sep 26 10:37:40 raspberrypi weewx[1145]:     ****  'interval'
Sep 26 10:37:40 raspberrypi weewx[1145]:     ****  Traceback (most recent call last):
Sep 26 10:37:40 raspberrypi weewx[1145]:     ****    File "/usr/share/weewx/weewx/engine.py", line 871, in main
Sep 26 10:37:40 raspberrypi weewx[1145]:     **** engine.run()
Sep 26 10:37:40 raspberrypi weewx[1145]:     ****    File "/usr/share/weewx/weewx/engine.py", line 159, in run
Sep 26 10:37:40 raspberrypi weewx[1145]:     **** self.dispatchEvent(weewx.Event(weewx.STARTUP))
Sep 26 10:37:40 raspberrypi weewx[1145]:     ****    File "/usr/share/weewx/weewx/engine.py", line 223, in dispatchEvent
Sep 26 10:37:40 raspberrypi weewx[1145]:     **** callback(event)
Sep 26 10:37:40 raspberrypi weewx[1145]:     ****    File "/usr/share/weewx/weewx/engine.py", line 508, in startup
Sep 26 10:37:40 raspberrypi weewx[1145]:     **** self._catchup(self.engine.console.genStartupRecords)
Sep 26 10:37:40 raspberrypi weewx[1145]:     ****    File "/usr/share/weewx/weewx/engine.py", line 622, in _catchup
Sep 26 10:37:40 raspberrypi weewx[1145]:     **** origin='hardware'))
Sep 26 10:37:40 raspberrypi weewx[1145]:     ****    File "/usr/share/weewx/weewx/engine.py", line 223, in dispatchEvent
Sep 26 10:37:40 raspberrypi weewx[1145]:     **** callback(event)
Sep 26 10:37:40 raspberrypi weewx[1145]:     ****    File "/usr/share/weewx/weewx/engine.py", line 588, in new_archive_record
Sep 26 10:37:40 raspberrypi weewx[1145]:     **** dbmanager.addRecord(event.record, accumulator=self.old_accumulator)
Sep 26 10:37:40 raspberrypi weewx[1145]:     ****    File "/usr/share/weewx/weewx/manager.py", line 245, in addRecord
Sep 26 10:37:40 raspberrypi weewx[1145]:     **** self._addSingleRecord(record, cursor, log_level)
Sep 26 10:37:40 raspberrypi weewx[1145]:     ****    File "/usr/share/weewx/weewx/manager.py", line 1179, in _addSingleRecord
Sep 26 10:37:40 raspberrypi weewx[1145]:     ****      _weight = self._calc_weight(record)
Sep 26 10:37:40 raspberrypi weewx[1145]:     ****    File "/usr/share/weewx/weewx/manager.py", line 1543, in _calc_weight
Sep 26 10:37:40 raspberrypi weewx[1145]:     ****      weight = 60.0 * record['interval'] if self.version >= '2.0' else 1.0
Sep 26 10:37:40 raspberrypi weewx[1145]:     ****  KeyError: 'interval'
Sep 26 10:37:40 raspberrypi weewx[1145]:     ****  Exiting.

I really don't see what is wrong. I also don't know why the record date is so old (2014-06-15 17:21:16). Maybe an old record in the station's datalogger ?

Thank you for your help

Lilian



mwall

unread,
Sep 26, 2017, 6:28:15 AM9/26/17
to weewx-user


On Tuesday, September 26, 2017 at 5:27:23 AM UTC-4, lilian.robert wrote:

I just did a fresh install of raspbian, installed and configured mysql (mariadb), installed and configured weewx.

When I connect the weather station (wmr200) thru usb and restart weewx, here is what I get in syslog (debug=1). The tables have been created by weewx but all tables are empty :

Sep 26 10:37:01 raspberrypi systemd[1]: Stopping LSB: weewx weather system...
...

Sep 26 10:37:40 raspberrypi weewx[1145]:     ****  KeyError: 'interval'
Sep 26 10:37:40 raspberrypi weewx[1145]:     ****  Exiting.

I really don't see what is wrong. I also don't know why the record date is so old (2014-06-15 17:21:16). Maybe an old record in the station's datalogger ?

this bug has been fixed.

please download the latest wmr200 driver (currently v3.3.4) and replace your wmr200 driver with it.


Lilian ROBERT

unread,
Sep 26, 2017, 6:48:50 AM9/26/17
to weewx...@googlegroups.com

That works, thank you very much.

Now, weewx is running. In syslog, I can see a lot of lines like this :

Sep 26 12:46:16 raspberrypi weewx[2085]: manager: Added record 2014-06-15 23:34:36 CEST (1402868076) to database 'weewx'
Sep 26 12:46:16 raspberrypi weewx[2085]: manager: Added record 2014-06-15 23:34:36 CEST (1402868076) to daily summary in 'weewx'
Sep 26 12:46:16 raspberrypi weewx[2085]: wmr200: MainThread: D   Queuing live packet rx:95 live_queue_len:95
Sep 26 12:46:17 raspberrypi weewx[2085]: wmr200: MainThread: D   Queuing archive packet rx:370 archive_queue_len:1
Sep 26 12:46:18 raspberrypi weewx[2085]: wmr200: MainThread: I genStartup() Still receiving archive packets cnt:117 len:1
Sep 26 12:46:18 raspberrypi weewx[2085]: wmr200: MainTh

It seems weewx is treating old records from my wmr200. But in database it has only inserted on with dateTime=1402845856 (15/6/2014 à 17:24:16).

Why weewx does not insert all records ?



Le 26. 09. 17 à 12:28, mwall a écrit :
--
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/W2u8w-Z8x9I/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.

mwall

unread,
Sep 26, 2017, 7:02:56 AM9/26/17
to weewx-user


On Tuesday, September 26, 2017 at 6:48:50 AM UTC-4, Lilian ROBERT wrote:

That works, thank you very much.

Now, weewx is running. In syslog, I can see a lot of lines like this :

Sep 26 12:46:16 raspberrypi weewx[2085]: manager: Added record 2014-06-15 23:34:36 CEST (1402868076) to database 'weewx'
Sep 26 12:46:16 raspberrypi weewx[2085]: manager: Added record 2014-06-15 23:34:36 CEST (1402868076) to daily summary in 'weewx'
Sep 26 12:46:16 raspberrypi weewx[2085]: wmr200: MainThread: D   Queuing live packet rx:95 live_queue_len:95
Sep 26 12:46:17 raspberrypi weewx[2085]: wmr200: MainThread: D   Queuing archive packet rx:370 archive_queue_len:1
Sep 26 12:46:18 raspberrypi weewx[2085]: wmr200: MainThread: I genStartup() Still receiving archive packets cnt:117 len:1
Sep 26 12:46:18 raspberrypi weewx[2085]: wmr200: MainTh

It seems weewx is treating old records from my wmr200. But in database it has only inserted on with dateTime=1402845856 (15/6/2014 à 17:24:16).

Why weewx does not insert all records ?


i'm not sure what question you are asking.

are you saying that weewx has completed its read of historical records, but none (some?) of those records were added?

or are you saying that weewx has started its read of historical records, but you do not see any records?

for the latter, just be patient.

for the former, (and perhaps the latter), you might have to remove the latest n records from the database.  when it does 'catchup' during startup, weewx will only add historical records that are newer than the latest record in the database. 

m

Lilian ROBERT

unread,
Sep 26, 2017, 8:27:27 AM9/26/17
to weewx...@googlegroups.com



Le 26. 09. 17 à 13:02, mwall a écrit :



i'm not sure what question you are asking.

are you saying that weewx has completed its read of historical records, but none (some?) of those records were added?

or are you saying that weewx has started its read of historical records, but you do not see any records?

for the latter, just be patient.

for the former, (and perhaps the latter), you might have to remove the latest n records from the database.  when it does 'catchup' during startup, weewx will only add historical records that are newer than the latest record in the database. 

m

I will try to be clear. It is a fresh install with an "old" station. One hour ago, the archive table was empty. First, I get an error (see my first message). After an updade of the wmr200 driver, I restarted weewx. Immediately, a record (the older ? 15/6/2014 à 17:24:16) appeared in the archive table. Weewx continued (and is always continuing) to treat station's records.

But no more records are inserted in the archive table. My question is why, why the only the first and not the others.

Sep 26 13:54:55 raspberrypi weewx[2085]: wmr200: MainThread: D   adjust_rain rain_total:72.14 Archive Data.rain_total_last:72.14 rain_interval:0.00
Sep 26 13:54:55 raspberrypi weewx[2085]: wmr200: MainThread: D genStartup() Yielding received archive record cnt:396 after requested timestamp:1402948906 pkt_interval:60 pkt:2014-06-17 04:38:26 CEST (1402972706)
Sep 26 13:54:55 raspberrypi weewx[2085]: manager: Added record 2014-06-17 04:38:26 CEST (1402972706) to database 'weewx'
Sep 26 13:54:56 raspberrypi weewx[2085]: manager: Added record 2014-06-17 04:38:26 CEST (1402972706) to daily summary in 'weewx'
Sep 26 13:54:56 raspberrypi weewx[2085]: wmr200: MainThread: D   Queuing archive packet rx:2090 archive_queue_len:1
Sep 26 13:54:56 raspberrypi weewx[2085]: wmr200: MainThread: I genStartup() Still receiving archive packets cnt:396 len:1
Sep 26 13:54:56 raspberrypi weewx[2085]: wmr200: MainTh

Thanks

Thomas Keffer

unread,
Sep 26, 2017, 8:58:09 AM9/26/17
to weewx-user
If you do not have it already, install the utility sqlite3

sudo apt-get install sqlite3

Then check the database

sqlite3 /var/lib/weewx/weewx.sdb
sqlite> select dateTime, datetime(dateTime,'unixepoch','localtime') from archive;

This will show you what records are in the database.

-tk

To unsubscribe from this group and all its topics, send an email to weewx-user+unsubscribe@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+unsubscribe@googlegroups.com.

Lilian ROBERT

unread,
Sep 26, 2017, 9:22:37 AM9/26/17
to weewx...@googlegroups.com
I am using mysql, not sqlite. But I retried and now, I can see the records in the archive table...

I don't know what changed but I probably missed something, sorry.


Thank you for your help



Le 26. 09. 17 à 14:57, Thomas Keffer a écrit :
To unsubscribe from this group and all its topics, send an email to weewx-user+...@googlegroups.com.
Reply all
Reply to author
Forward
0 new messages