If you are hungry and someone prepared lunch for you, served it, and started feeding you, you'll stay hungry, unless you swallow.
Yves Martin schrieb am Montag, 17. Juli 2023 um 23:11:25 UTC+2: > Hi Michael, > > It is empty as I use the same db from my old weewx to version 4.10.2 and > when I migrate to python 3.7.3. > > sqlite> .open weewx.sdb > sqlite> > sqlite> SELECT name FROM sqlite_master WHERE type = 'table'" ".exit" | > grep pm2_5 > ...> > ...> SELECT name FROM sqlite_master WHERE type = 'table'" ".exit" | > grep pm2_5 > ...> PRAGMA table_info(archive);" ".exit" | grep pm2_5 > ...> > ...> > > (...) > > I will need some help with this one. > > How I convert my actual database with the new one? > > My setting is like this in weewx.conf : > > [DataBindings] > > [[wx_binding]] > # The database must match one of the sections in [Databases]. > # This is likely to be the only option you would want to change. > database = archive_sqlite > # The name of the table within the database > table_name = archive > # The manager handles aggregation of data for historical summaries > manager = weewx.wxmanager.WXDaySummaryManager > # The schema defines the structure of the database. > # It is *only* used when the database is created. > schema = schemas.wview.schema > > [[forecast_binding]] > database = forecast_sqlite > > (...) > > How I use : wview_extended > <https://github.com/weewx/weewx/blob/master/bin/schemas/wview_extended.py> > ? > > YM > Le lundi 17 juillet 2023 à 14 h 17 min 32 s UTC-4, [email protected] a > écrit : > >> 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/b1324b94-c7e7-4a37-8fd5-ac42a9a328f3n%40googlegroups.com.
