Hello,
I am running Weewx 4.10.2, catching data from various sensors (433 MHz and
868 MHz), via the user.SDR driver.
All was perfectly working till I decide to add a new temperature/humidity
sensor to the sensor map (extraTemp3 and extraHumid3). See below the sensor
map.
[SDR]
# This section is for the software-defined radio driver.
# The station model, e.g., 'Meade TE923W' or 'TFA Nexus'
model = Bresser WSX3001
# The driver to use
driver = user.sdr
cmd = sudo /usr/local/bin/rtl_433 -f 868.3M -f 433.92M -H 90 -Y
autolevel -s 1024k -R 173 -R 172 -R 42 -M utc -F json
[[sensor_map]]
iroxwindDir = wind_dir.4:None.HidekiWindPacket
iroxwindGust = wind_gust.4:None.HidekiWindPacket
iroxwindSpeed = wind_speed.4:None.HidekiWindPacket
iroxwindBatteryStatus = battery.4:None.HidekiWindPacket
iroxoutTemp = temperature.1:12.HidekiTS04Packet
iroxoutHumidity = humidity.1:12.HidekiTS04Packet
iroxoutBatteryStatus = battery.1:12.HidekiTS04Packet
extraTemp2 = temperature.5:1.HidekiTS04Packet
extraHumid2 = humidity.5:1.HidekiTS04Packet
*extraTemp3 = temperature.2:15.HidekiTS04Packet *# Temp_Cave
* extraHumid3 = humidity.2:15.HidekiTS04Packet* # Hum_Cave
extraBatteryStatus2 = battery.5:1.HidekiTS04Packet
# rain_total = rain_total.4:None.HidekiRainPacket
# rainBatteryStatus = battery.4:None.HidekiRainPacket
outTemp = temperature.43576.Bresser7in1Packet
outHumidity = humidity.43576.Bresser7in1Packet
rain_total = rain_total.43576.Bresser7in1Packet
windDir = wind_dir.43576.Bresser7in1Packet
windSpeed = wind_speed.43576.Bresser7in1Packet
windGust = wind_gust.43576.Bresser7in1Packet
UV = uv.43576.Bresser7in1Packet
radiation = light.43576.Bresser7in1Packet
windBatteryStatus = battery.43576.Bresser7in1Packet
inTemp = temperature.-1859570394.Bresser6in1Packet # capteur
thermo-hygro externe
inHumidity = humidity.-1859570394.Bresser6in1Packet
inTempBatteryStatus = battery.-1859570394.Bresser6in1Packet
I actually succeeded to add a graph of extraTemp3 but I failed to add
extraHumid3. weewx.reportengine gets an "weewx.UnknownType: extraHumid3"
error.
Oct 9 12:35:26 raspberrypi weewx[2125] INFO weewx.manager: Added record
2023-10-09 12:35:00 CEST (1696847700) to database 'weewx.sdb'
Oct 9 12:35:26 raspberrypi weewx[2125] INFO weewx.manager: Added record
2023-10-09 12:35:00 CEST (1696847700) to daily summary in 'weewx.sdb'
Oct 9 12:35:28 raspberrypi weewx[2125] INFO weewx.cheetahgenerator:
Generated 8 files for report SeasonsReport in 2.01 seconds
Oct 9 12:35:29 raspberrypi weewx[2125] ERROR weewx.reportengine: Caught
unrecoverable exception in generator 'weewx.imagegenerator.ImageGenerator'
Oct 9 12:35:29 raspberrypi weewx[2125] ERROR weewx.reportengine:
**** extraHumid3
Oct 9 12:35:29 raspberrypi weewx[2125] ERROR weewx.reportengine:
**** Traceback (most recent call last):
Oct 9 12:35:29 raspberrypi weewx[2125] ERROR weewx.reportengine:
**** File "/usr/share/weewx/weewx/reportengine.py", line 197, in run
Oct 9 12:35:29 raspberrypi weewx[2125] ERROR weewx.reportengine:
**** obj.start()
Oct 9 12:35:29 raspberrypi weewx[2125] ERROR weewx.reportengine:
**** File "/usr/share/weewx/weewx/reportengine.py", line 385, in start
Oct 9 12:35:29 raspberrypi weewx[2125] ERROR weewx.reportengine:
**** self.run()
Oct 9 12:35:29 raspberrypi weewx[2125] ERROR weewx.reportengine:
**** File "/usr/share/weewx/weewx/imagegenerator.py", line 42, in run
Oct 9 12:35:29 raspberrypi weewx[2125] ERROR weewx.reportengine:
**** self.gen_images(self.gen_ts)
Oct 9 12:35:29 raspberrypi weewx[2125] ERROR weewx.reportengine:
**** File "/usr/share/weewx/weewx/imagegenerator.py", line 109, in
gen_images
Oct 9 12:35:29 raspberrypi weewx[2125] ERROR weewx.reportengine:
**** self.image_dict[timespan][plotname])
Oct 9 12:35:29 raspberrypi weewx[2125] ERROR weewx.reportengine:
**** File "/usr/share/weewx/weewx/imagegenerator.py", line 249, in
gen_plot
Oct 9 12:35:29 raspberrypi weewx[2125] ERROR weewx.reportengine:
**** **option_dict)
Oct 9 12:35:29 raspberrypi weewx[2125] ERROR weewx.reportengine:
**** File "/usr/share/weewx/weewx/xtypes.py", line 116, in get_series
Oct 9 12:35:29 raspberrypi weewx[2125] ERROR weewx.reportengine:
**** raise weewx.UnknownType(msg)
Oct 9 12:35:29 raspberrypi weewx[2125] ERROR *weewx.reportengine:
**** weewx.UnknownType: extraHumid3*
Oct 9 12:35:29 raspberrypi weewx[2125] ERROR weewx.reportengine:
**** Generator terminated
Oct 9 12:35:29 raspberrypi weewx[2125] INFO weewx.reportengine: Copied 0
files to /var/www/html/weewx
Oct 9 12:35:32 raspberrypi weewx[2125] INFO weewx.cheetahgenerator:
Generated 11 files for report Belchertown in 3.30 seconds
Oct 9 12:35:32 raspberrypi weewx[2125] INFO weewx.reportengine: Copied 2
files to /var/www/html/weewx/belchertown
I tried to add a column to the database but I got this error :
"weedb.TableExistsError: table archive_day_extraHumid3 already exists" (see
below)
pi@raspberrypi:~ $ wee_database --add-column=extraHumid3
Using configuration file /etc/weewx/weewx.conf
Using database binding 'wx_binding', which is bound to database
'archive_sqlite'
Add new column 'extraHumid3' of type 'REAL' to database (y/n)? y
Traceback (most recent call last):
File "/usr/share/weewx/weedb/sqlite.py", line 39, in guarded_fn
return fn(*args, **kwargs)
File "/usr/share/weewx/weedb/sqlite.py", line 233, in execute
return sqlite3.Cursor.execute(self, *args, **kwargs)
*sqlite3.OperationalError: table archive_day_extraHumid3 already exists*
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/usr/share/weewx/wee_database", line 1168, in <module>
main()
File "/usr/share/weewx/wee_database", line 220, in main
addColumn(config_dict, db_binding, options.add_column, options.type)
File "/usr/share/weewx/wee_database", line 632, in addColumn
dbm.add_column(column_name, column_type)
File "/usr/share/weewx/weewx/manager.py", line 623, in add_column
self._add_column(column_name, column_type, cursor)
File "/usr/share/weewx/weewx/manager.py", line 1136, in _add_column
self._initialize_day_table(column_name, 'scalar', cursor)
File "/usr/share/weewx/weewx/manager.py", line 1130, in
_initialize_day_table
cursor.execute(sql_create_str)
File "/usr/share/weewx/weedb/sqlite.py", line 49, in guarded_fn
raise weedb.TableExistsError(e)
*weedb.TableExistsError: table archive_day_extraHumid3 already exists*
At the opposite, if I try to drop a possible extraHumid3 column, i get the
following :
pi@raspberrypi:~ $ wee_database --drop-column=extraHumid3
Using configuration file /etc/weewx/weewx.conf
Using database binding 'wx_binding', which is bound to database
'archive_sqlite'
Drop column(s) 'extraHumid3' from the database (y/n)? y
This may take a while...
*Cannot DROP 'extraHumid3'; column does not exist.*
Nothing done.
Now, even if I comment the extraTemp3 and extraHumid3 lines in the sensor
map, I still get the same syslog errors.
At that point I am a bit stuck.
Any clue ?
Have a nice day
Pierre-Yves
--
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/31697f77-feca-4821-bcb9-40f7f5cca562n%40googlegroups.com.
