What is sqlite3 weewx.sdb "SELECT name FROM sqlite_master WHERE type = 'table'" ".exit" | grep pm2_5 showing?
What ist sqlite3 weewx.sdb "PRAGMA table_info(archive);" ".exit" | grep pm2_5 showing? If nothing, migrate to wview extended: https://weewx.com/docs/latest/customizing.htm#transfer_database_using_new_schema Yves Martin schrieb am Montag, 17. Juli 2023 um 17:18:23 UTC+2: > It seems the AQI works but not the other variable ... (not all the time). > > I was thinking ... because I'm using an old version of the sqlite database > (from 2016), perhaps the new version did not integrate the new fields? > > How can I check this? > > Yves, > YMartin.com/meteo > > Le lundi 17 juillet 2023 à 11 h 06 min 43 s UTC-4, Yves Martin a écrit : > >> I'm using the Bootstrap for my station with multi-language. Is there some >> incompatibility? >> wview_extended >> <https://github.com/weewx/weewx/blob/master/bin/schemas/wview_extended.py> >> is >> set correctly here, the variables are well defined. >> Is there something I've missed? >> >> Yves, >> YMartin.com/meteo >> >> Le lundi 17 juillet 2023 à 09 h 30 min 04 s UTC-4, John Kline a écrit : >> >>> Jul 17 08:48:48 weewx4-raspi weewx[24741] ERROR weewx.reportengine: >>> **** no such column: pm2_5 >>> >>> On Jul 17, 2023, at 6:12 AM, Yves Martin <[email protected]> wrote: >>> >>> wview_extended >>> <https://github.com/weewx/weewx/blob/master/bin/schemas/wview_extended.py> >>> is >>> correct here. >>> >>> >>> I'm able to show the data on my main page but I've still theses errors... >>> >>> YM >>> >>> Le lundi 17 juillet 2023 à 09 h 01 min 24 s UTC-4, John Kline a écrit : >>> >>>> Please note in the description for this extension: >>>> >>>> “weewx-airlink requires the wview_extended >>>> <https://github.com/weewx/weewx/blob/master/bin/schemas/wview_extended.py> >>>> in >>>> WeeWX 4 that contains pm1_0, pm2_5 and pm10_0 columns.“ >>>> >>>> On Jul 17, 2023, at 5:57 AM, [email protected] <[email protected]> >>>> wrote: >>>> >>>> >>>> >>>> >>>> weedb.NoColumnError: no such column: pm2_5 >>>> Yves Martin schrieb am Montag, 17. Juli 2023 um 14:52:24 UTC+2: >>>> >>>>> Hi, >>>>> >>>>> I've installe the module weewx-airlink ( >>>>> https://github.com/chaunceygardiner/weewx-airlink) for the Davis Air >>>>> Quality, but I have this error : >>>>> >>>>> Jul 17 08:48:42 weewx4-raspi weewx[24741] INFO weewx.imagegenerator: >>>>> Generated 18 images for report Bootstrap in 19.46 seconds >>>>> Jul 17 08:48:42 weewx4-raspi weewx[24741] INFO weewx.reportengine: >>>>> Copied 0 files to /var/www/html/weewx >>>>> Jul 17 08:48:44 weewx4-raspi weewx[24741] INFO user.historygenerator: >>>>> historygenerator.py: Generated 7 tables in 1.20 seconds >>>>> Jul 17 08:48:47 weewx4-raspi weewx[24741] INFO weewx.cheetahgenerator: >>>>> Generated 10 files for report Bootstrap in 5.12 seconds >>>>> Jul 17 08:48:47 weewx4-raspi weewx[24741] INFO weewx.cheetahgenerator: >>>>> Generated 1 files for report lastrain in 0.06 seconds >>>>> Jul 17 08:48:48 weewx4-raspi weewx[24741] INFO weewx.cheetahgenerator: >>>>> Generated 1 files for report AirLinkReport in 0.06 seconds >>>>> Jul 17 08:48:48 weewx4-raspi weewx[24741] INFO user.airlink: >>>>> get_scalar called where record does not contain pm2_5. This is >>>>> unexpected. >>>>> Jul 17 08:48:48 weewx4-raspi weewx[24741] ERROR weewx.reportengine: >>>>> Caught unrecoverable exception in generator >>>>> 'weewx.imagegenerator.ImageGenerator' >>>>> Jul 17 08:48:48 weewx4-raspi weewx[24741] ERROR weewx.reportengine: >>>>> **** no such column: pm2_5 >>>>> Jul 17 08:48:48 weewx4-raspi weewx[24741] ERROR weewx.reportengine: >>>>> **** Traceback (most recent call last): >>>>> Jul 17 08:48:48 weewx4-raspi weewx[24741] ERROR weewx.reportengine: >>>>> **** File "/usr/share/weewx/weewx/xtypes.py", line 101, in >>>>> get_series >>>>> Jul 17 08:48:48 weewx4-raspi weewx[24741] ERROR weewx.reportengine: >>>>> **** aggregate_interval, **option_dict) >>>>> Jul 17 08:48:48 weewx4-raspi weewx[24741] ERROR weewx.reportengine: >>>>> **** TypeError: get_series() got an unexpected keyword argument >>>>> 'SKIN_ROOT' >>>>> Jul 17 08:48:48 weewx4-raspi weewx[24741] ERROR weewx.reportengine: >>>>> **** >>>>> Jul 17 08:48:48 weewx4-raspi weewx[24741] ERROR weewx.reportengine: >>>>> **** During handling of the above exception, another exception >>>>> occurred: >>>>> Jul 17 08:48:48 weewx4-raspi weewx[24741] ERROR weewx.reportengine: >>>>> **** >>>>> Jul 17 08:48:48 weewx4-raspi weewx[24741] ERROR weewx.reportengine: >>>>> **** Traceback (most recent call last): >>>>> Jul 17 08:48:48 weewx4-raspi weewx[24741] ERROR weewx.reportengine: >>>>> **** File "/usr/share/weewx/weedb/sqlite.py", line 39, in >>>>> guarded_fn >>>>> Jul 17 08:48:48 weewx4-raspi weewx[24741] ERROR weewx.reportengine: >>>>> **** return fn(*args, **kwargs) >>>>> Jul 17 08:48:48 weewx4-raspi weewx[24741] ERROR weewx.reportengine: >>>>> **** File "/usr/share/weewx/weedb/sqlite.py", line 233, in >>>>> execute >>>>> Jul 17 08:48:48 weewx4-raspi weewx[24741] ERROR weewx.reportengine: >>>>> **** return sqlite3.Cursor.execute(self, *args, **kwargs) >>>>> Jul 17 08:48:48 weewx4-raspi weewx[24741] ERROR weewx.reportengine: >>>>> **** sqlite3.OperationalError: no such column: pm2_5 >>>>> Jul 17 08:48:48 weewx4-raspi weewx[24741] ERROR weewx.reportengine: >>>>> **** >>>>> Jul 17 08:48:48 weewx4-raspi weewx[24741] ERROR weewx.reportengine: >>>>> **** During handling of the above exception, another exception >>>>> occurred: >>>>> Jul 17 08:48:48 weewx4-raspi weewx[24741] ERROR weewx.reportengine: >>>>> **** >>>>> Jul 17 08:48:48 weewx4-raspi weewx[24741] ERROR weewx.reportengine: >>>>> **** Traceback (most recent call last): >>>>> Jul 17 08:48:48 weewx4-raspi weewx[24741] ERROR weewx.reportengine: >>>>> **** File "/usr/share/weewx/weewx/reportengine.py", line 197, in >>>>> run >>>>> Jul 17 08:48:48 weewx4-raspi weewx[24741] ERROR weewx.reportengine: >>>>> **** obj.start() >>>>> Jul 17 08:48:48 weewx4-raspi weewx[24741] ERROR weewx.reportengine: >>>>> **** File "/usr/share/weewx/weewx/reportengine.py", line 385, in >>>>> start >>>>> Jul 17 08:48:48 weewx4-raspi weewx[24741] ERROR weewx.reportengine: >>>>> **** self.run() >>>>> Jul 17 08:48:48 weewx4-raspi weewx[24741] ERROR weewx.reportengine: >>>>> **** File "/usr/share/weewx/weewx/imagegenerator.py", line 42, >>>>> in >>>>> run >>>>> Jul 17 08:48:48 weewx4-raspi weewx[24741] ERROR weewx.reportengine: >>>>> **** self.gen_images(self.gen_ts) >>>>> Jul 17 08:48:48 weewx4-raspi weewx[24741] ERROR weewx.reportengine: >>>>> **** File "/usr/share/weewx/weewx/imagegenerator.py", line 109, >>>>> in >>>>> gen_images >>>>> Jul 17 08:48:48 weewx4-raspi weewx[24741] ERROR weewx.reportengine: >>>>> **** self.image_dict[timespan][plotname]) >>>>> Jul 17 08:48:48 weewx4-raspi weewx[24741] ERROR weewx.reportengine: >>>>> **** File "/usr/share/weewx/weewx/imagegenerator.py", line 249, >>>>> in >>>>> gen_plot >>>>> Jul 17 08:48:48 weewx4-raspi weewx[24741] ERROR weewx.reportengine: >>>>> **** **option_dict) >>>>> Jul 17 08:48:48 weewx4-raspi weewx[24741] ERROR weewx.reportengine: >>>>> **** File "/usr/share/weewx/weewx/xtypes.py", line 106, in >>>>> get_series >>>>> Jul 17 08:48:48 weewx4-raspi weewx[24741] ERROR weewx.reportengine: >>>>> **** aggregate_interval) >>>>> Jul 17 08:48:48 weewx4-raspi weewx[24741] ERROR weewx.reportengine: >>>>> **** File "/usr/share/weewx/user/airlink.py", line 631, in >>>>> get_series >>>>> Jul 17 08:48:48 weewx4-raspi weewx[24741] ERROR weewx.reportengine: >>>>> **** for record in db_manager.genSql(sql_str, timespan): >>>>> Jul 17 08:48:48 weewx4-raspi weewx[24741] ERROR weewx.reportengine: >>>>> **** File "/usr/share/weewx/weewx/manager.py", line 598, in >>>>> genSql >>>>> Jul 17 08:48:48 weewx4-raspi weewx[24741] ERROR weewx.reportengine: >>>>> **** for _row in _cursor.execute(sql, sqlargs): >>>>> Jul 17 08:48:48 weewx4-raspi weewx[24741] ERROR weewx.reportengine: >>>>> **** File "/usr/share/weewx/weedb/sqlite.py", line 51, in >>>>> guarded_fn >>>>> Jul 17 08:48:48 weewx4-raspi weewx[24741] ERROR weewx.reportengine: >>>>> **** raise weedb.NoColumnError(e) >>>>> Jul 17 08:48:48 weewx4-raspi weewx[24741] ERROR weewx.reportengine: >>>>> **** weedb.NoColumnError: no such column: pm2_5 >>>>> Jul 17 08:48:48 weewx4-raspi weewx[24741] ERROR weewx.reportengine: >>>>> **** Generator terminated >>>>> >>>>> Any idea? >>>>> >>>>> Yves, >>>>> YMartin.com/meteo >>>>> >>>> -- >>>> 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/8ee71df7-dde4-4af2-af2e-bd627d838385n%40googlegroups.com >>>> >>>> <https://groups.google.com/d/msgid/weewx-user/8ee71df7-dde4-4af2-af2e-bd627d838385n%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/79cf0149-4766-4027-8381-36d5a587a763n%40googlegroups.com >>> >>> <https://groups.google.com/d/msgid/weewx-user/79cf0149-4766-4027-8381-36d5a587a763n%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/f3bde09f-21d5-4abf-afc0-858efe370e76n%40googlegroups.com.
