Re: [weewx-user] Adding a new type to an SQLite DB

Ah good, makes sense indeed. Please ignore my last message with the error message. > On 19 Apr, 2021, at 20:13, Tom Keffer wrote: > > Vince is right that you need V4.5. > > But, your command is also wrong. Review the docs for wee_database >

Re: [weewx-user] Adding a new type to an SQLite DB

Thanks. Upgrade to 4.5.1 went fine, but this command throws an error which puzzles me: /home/weewx $ sudo bin/wee_database --add-column=energy_total --type=REAL --config=archive/envoy.sdb Traceback (most recent call last): File "bin/wee_database", line 1138, in main() File

Re: [weewx-user] Adding a new type to an SQLite DB

Vince is right that you need V4.5. But, your command is also wrong. Review the docs for wee_database . The --config option selects a *configuration file*, such as weewx.conf, not a database. The --binding option selects the

Re: [weewx-user] Adding a new type to an SQLite DB

and —config takes a weewx.conf (not a weewx.sdb) as its arg > On 20 Apr 2021, at 5:57 am, vince wrote: > > Your weewx is too old. You need to update to 4.5.0 or later according to the > release notes at https://github.com/weewx/weewx/releases > > >

Re: [weewx-user] Adding a new type to an SQLite DB

Your weewx is too old. You need to update to 4.5.0 or later according to the release notes at https://github.com/weewx/weewx/releases On Monday, April 19, 2021 at 11:38:54 AM UTC-7 weatherl...@gmail.com wrote: > I am asking just that but I can’t see how —binding might work > > When I

Re: [weewx-user] Adding a new type to an SQLite DB

I am asking just that but I can’t see how —binding might work When I installed the Envoy drive, it still uses wx_binding when in creates envoy.sdb So I tried: In /home/weewx: sudo bin/wee_database --add-column=energy_total --config=archive/envoy.sdb And it throws an error: wee_database:

[weewx-user] Adding a new type to an SQLite DB

>From the WeeWx docs: > Adding a new type to an existing database > Here's how you would add the observation type electricity (from the example > Adding a second data source > ) to an existing > database by using wee_database: > >