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/c2e9a508-7c9c-4398-b43e-a37465e6b6b1n%40googlegroups.com.
