Yes, it stands. However:
- I didn't create the columns for the other data which weewx inserts into the database, I'd expect that those data have their column in the database like the other data which have them - It seems that weewx receives that data from the wmr100 driver, why doesn't it create their database columns for all the data it receives from the driver? or at least weewx, if security suggest not to do it, the user to create the columns with a syslog message Il giorno sabato 25 marzo 2017 22:31:42 UTC+1, Tom Keffer ha scritto: > > Data for plots are taken from the database. So, unless there is a column ' > hourRain' in your schema, it cannot be used in a plot. It can only be > used in the $current tag. > > Stands to reason, if you think about it. > > -tk > > On Sat, Mar 25, 2017 at 12:30 PM, Paolo Benvenuto <[email protected] > <javascript:>> wrote: > >> My wmr100 driver outputs a hourRain field: >> >> {'UV': 'uv', 'outHumidity': 'humidity_1', 'inTempBatteryStatus': >> 'battery_status_0', 'rainBatteryStatus': 'battery_status_rain', >> 'extraTemp2': 'temperature_3', 'outTempBatteryStatus': 'battery_status_1' >> , 'inTemp': 'temperature_0', 'hourRain': 'rain_hour', 'rain': 'rain', >> 'extraHumid6': 'humidity_7', 'pressure': 'pressure', 'extraHumid4': >> 'humidity_5', 'extraHumid5': 'humidity_6', 'extraHumid2': 'humidity_3', >> 'extraHumid3': 'humidity_4', 'extraHumid1': 'humidity_2', 'extraTemp6': >> 'temperature_7', 'extraTemp7': 'temperature_8', 'extraTemp4': >> 'temperature_5', 'extraTemp5': 'temperature_6', 'rainRate': 'rain_rate', >> 'extraTemp3': 'temperature_4', 'extraTemp1': 'temperature_2', >> 'extraHumid7': 'humidity_8', 'extraBatteryStatus2': 'battery_status_3', >> 'extraBatteryStatus3': 'battery_status_4', 'windBatteryStatus': >> 'battery_status_wind', 'extraBatteryStatus1': 'battery_status_2', >> 'extraBatteryStatus6': 'battery_status_7', 'extraBatteryStatus7': >> 'battery_status_8', 'extraBatteryStatus4': 'battery_status_5', >> 'extraBatteryStatus5': 'battery_status_6', 'windDir': 'wind_dir', >> 'outTemp': 'temperature_1', 'windSpeed': 'wind_speed', 'inHumidity': >> 'humidity_0', 'rain24': 'rain_24', 'windGust': 'wind_gust', >> 'uvBatteryStatus': 'battery_status_uv', 'rainTotal': 'rain_total'} >> >> So I put it in my skin: >> >> [[[dayrain]]] >> yscale = None, None, 0.02 >> plot_type = bar >> [[[[rain]]]] >> color = gray >> [[[[hourRain]]]] >> color = black >> >> >> >> However, I get this error: >> >> Mar 25 20:26:19 localhost weewx[31399]: reportengine: Caught >> unrecoverable exception in generator weewx.imagegenerator.ImageGenerator >> Mar 25 20:26:19 localhost weewx[31399]: **** no such column: >> hourRain >> Mar 25 20:26:19 localhost weewx[31399]: **** Traceback (most >> recent call last): >> Mar 25 20:26:19 localhost weewx[31399]: **** File >> "/usr/share/weewx.github.development/weewx/reportengine.py", line 239, in >> run >> Mar 25 20:26:19 localhost weewx[31399]: **** obj.start() >> Mar 25 20:26:19 localhost weewx[31399]: **** File >> "/usr/share/weewx.github.development/weewx/reportengine.py", line 273, in >> start >> Mar 25 20:26:19 localhost weewx[31399]: **** self.run() >> Mar 25 20:26:19 localhost weewx[31399]: **** File >> "/usr/share/weewx.github.development/weewx/imagegenerator.py", line 32, >> in run >> Mar 25 20:26:19 localhost weewx[31399]: **** self.genImages( >> self.gen_ts) >> Mar 25 20:26:19 localhost weewx[31399]: **** File >> "/usr/share/weewx.github.development/weewx/imagegenerator.py", line 145, >> in genImages >> Mar 25 20:26:19 localhost weewx[31399]: **** >> aggregate_interval=aggregate_interval) >> Mar 25 20:26:19 localhost weewx[31399]: **** File >> "/usr/share/weewx.github.development/weewx/manager.py", line 511, in >> getSqlVectors >> Mar 25 20:26:19 localhost weewx[31399]: **** aggregate_type, >> aggregate_interval) >> Mar 25 20:26:19 localhost weewx[31399]: **** File >> "/usr/share/weewx.github.development/weewx/manager.py", line 757, in >> _getSqlVectors >> Mar 25 20:26:19 localhost weewx[31399]: **** for _rec in >> _cursor.execute(sql_str, (startstamp, stopstamp)): >> Mar 25 20:26:19 localhost weewx[31399]: **** File >> "/usr/share/weewx.github.development/weedb/sqlite.py", line 41, in >> guarded_fn >> Mar 25 20:26:19 localhost weewx[31399]: **** raise weedb. >> NoColumnError(e) >> Mar 25 20:26:19 localhost weewx[31399]: **** NoColumnError: no >> such column: hourRain >> Mar 25 20:26:19 localhost weewx[31399]: **** Generator >> terminated >> >> Is it a bug or am I missing something? >> >> -- >> 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] <javascript:>. >> 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.
