After move from 5.0 to 5.3, can't use old modified schema

[messyp...@gmail.com]

I have already googled and searched this forum for how to solve this problem and wasn't able to find it. Some background is needed:

Some years ago I added a sensor to detect lake height, and at the Weewx 4.7.1 era time I thought I needed to add Lake Elevation ("LakeElev"). I remember doing something to extend the schema, and the database browser indeed showed the last column labeled "LakeElev". It was working fine. For years.  It continued to work fine when I had to rebuild my RPI4 because the memory card was damaged (lightning, I'm guessing). That was about 2 years ago. Rebuilt it, added things, and stuck my old weewx.sdb in there and (I wont mention the struggle with owfs but eventually got them working again) and the .sdb was logging all the parameters correctly. This was weewx 5.0.

Ffwd to the other day. Lightning struck nearby. Pi continued to appear working, until 2 days later I rebooted it, it's boot section of the USB stick was corrupted; I had backup of most things so started to rebuild. Got the pi up w/ latest os (trixie), added the stuff I needed, then did a fresh complete install of weewx 5.3.1 with the Davis plugged into the TTYUSB0, it was reading / catching up / logging, everything looked good then I remembered I this data didn't have Lake Data, so stopped weewx, replaced the .sdb with the previous .sdb, and all weewx did was throw errors about can't write to a read-only database (I made sure it was permissioned properly, I can think of no reason weewx wouldn't archive to it). So I put the new .sdb in and it continued to update, and at least weewx would archive to it. 

So now I've gotten my extensions.py incorporated where it reads cpu temps from some processors on the network and puts them in the correct places in the .sdb, and of course reads the lake elevation, tries to put it in "LakeElev" but it doesn't exist. 

I forgot how I added LakeElev column years ago, and something tells me the correct way to do that has evolved anyway. 

So my question revolved around how do I get the LakeElev column into my .sdb so my extensions.py will place them there? 

I'm enclosing copy of extensions.py and weewx.conf (I haven't reinstalled my owfs hat yet, so no mention of owfs in the .conf)

I did read "Upgrade Guide" as Tom mentioned to someone, it mentions 

"import schemas.wview_extended" must be replaced by 

"import weewx.schemas.wview_extended", I had neither in the extensions.py so I don't know how it worked with 5.0, and now I don't understand where the new statement is supposed to go. Or how I add that column to my short weewx.sdb.

-- Thank you --

[Vince Skahan]

https://www.weewx.com/docs/5.3/utilities/weectl-database/#add-a-new-observation-type-to-the-database perhaps ?

[messyp...@gmail.com]

That added the column. I'm wondering if that's what I did 3 years ago. Sorry I forgot.

What about the "import weewx.schemas.wview_extended" question? I still don't know exactly where that would go, or, how it works in my installation or if it's even necessary.

Thanks.

[John Smith]

 it mentions "import schemas.wview_extended" must be replaced by 

"import weewx.schemas.wview_extended"

Check your weewx.conf file 

--
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 weewx-user+...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/weewx-user/48ed9627-fa14-4356-9519-19ce1983f691n%40googlegroups.com.

[Messy Potamia]

>
> Check your weewx.conf file
I see it's already there.
Okay. Thanks.

> You received this message because you are subscribed to a topic in the Google Groups "weewx-user" group.
> To unsubscribe from this topic, visit https://groups.google.com/d/topic/weewx-user/OEwP6wJ8n1I/unsubscribe.
> To unsubscribe from this group and all its topics, send an email to weewx-user+...@googlegroups.com.
> To view this discussion visit https://groups.google.com/d/msgid/weewx-user/CAGTinV5ne9PiyF-J5uS_mAbqZBbSwp8sUGeo6rceNUOxOASq7w%40mail.gmail.com.