This error can be misleading. The problem could also be caused by an unknown aggregation type. Look through your [ImageGenerator] section of the Belchertown skin and make sure there isn't a typo or something for "aggregate_type".
On Mon, Oct 9, 2023 at 6:29 AM Pierre-Yves <[email protected]> wrote: > 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 > <https://groups.google.com/d/msgid/weewx-user/31697f77-feca-4821-bcb9-40f7f5cca562n%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- 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/CAPq0zEBFDSZkzbWXQsbk10iJ%2B8Jcv55A%2BhWePLrMY50GKDFibA%40mail.gmail.com.
