If you are able to give me a recipe and some hints, I will do the job. Unfortunately, I don't have years to become a chef (I'm not a programmer) and it is not my job too. I can learn and this is what I'm doing every time.
When I've reinstalled from scratch a new Fresh Debian distribution on my Raspeberry Pi to upgrade the distribution and use a more recent Python language, I've installed it with the minimum. No X11 and useless things, it is just a server. Then I try to find some sqlite manager (a tool like MC for exemple) but I could not find it. They used Mac, PC or X11... I tried to installed a few tools like sqlitebrowser but it did not work. I've give up for now. The other thing I wanted to try is to delete my actual database (just keep it in a safe place, with my 8 years of data. I already lost 2 years of data 8 years ago and I wrote a small script to do a backup... and I learned too) then create a new database with the wview_extended <https://github.com/weewx/weewx/blob/master/bin/schemas/wview_extended.py> reference, then compare the 2 databases (the new and my old one). After, I could add the fields with a sqlite manager, or the new table in my old database. So, I'm hungry but I won't wait too long. I'm busy too with my life. Let me know if my ideas are right, I will try them later. Yves, YMartin.com/meteo Le lundi 17 juillet 2023 à 23 h 36 min 46 s UTC-4, [email protected] a écrit : > 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/f24f2c97-4a1f-4a1b-abee-9ab236402c1cn%40googlegroups.com.
