So, either follow the instructions in the link I posted above or there: https://weewx.com/docs/latest/utilities.htm#Action_--add-column
[email protected] schrieb am Dienstag, 18. Juli 2023 um 05:36:46 UTC+2: > 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/c659ff76-0e71-44ee-9062-22a72d613884n%40googlegroups.com.
