https://www.weewx.com/docs/5.3/utilities/weectl-database/#add-a-new-observation-type-to-the-database perhaps ?
On Thursday, June 4, 2026 at 2:04:30 PM UTC-7 [email protected] wrote: > 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 -- > -- 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 visit https://groups.google.com/d/msgid/weewx-user/2764e902-0439-447b-afcd-d908146e6f49n%40googlegroups.com.
