Instructions for switching to the new schema are in https://github.com/weewx/weewx/wiki/Switching-to-the-new-wview_extended-schema.
Since you're using SQLite, ignore anything related to MySQL. On Friday, December 12, 2025 at 8:58:37 AM UTC-8 Pete Geenhuizen wrote: > I started out with wview and switched over to weewx many years ago and > used whatever the default database was and because it worked just continued > to use the same data file and until now I guess didn't worry about any > changes in the structure. > > Now that I'm moving from Rocky 8 to Rocky 9 I now need to install weewx > v5. I would have to loose the 14 years of data that I already have, so I'd > like to keep it if at all possible > > from weewx.conf > > This section defines various databases. > > [Databases] > > # A SQLite database is simply a single file. > [[archive_sqlite]] > database_name = weewx-lc.sdb > database_type = SQLite > > # file weewx-lc.sdb > weewx-lc.sdb: SQLite 3.x database, last written using SQLite version > 3034001 > > So how can/do I upgrade the data to be compatible with v5? > > Thanks > > Pete > On 12/12/25 10:14, '[email protected]' via weewx-user wrote: > > You won't have any success using mysql for querying a sqlite database, so > first things first: what kind of database are you using with WeeWX? > > Pete Geenhuizen schrieb am Freitag, 12. Dezember 2025 um 15:12:31 UTC+1: > >> First off, I know absolutely nothing about databases and haven't install >> anything related to a database, up to now. >> >> Using Thomas' instructions from >> https://github.com/weewx/weewx/wiki/Switching-to-the-new-wview_extended-schema >> >> # mysql command not found, >> >> so I installed mysql-8.0.43-1.el9_6.x86_64 >> >> when I run the command >> >> # mysql> GRANT select, update, create, delete, insert ON weewx_new.* TO >> weewx@localhost; >> >> I ended up with a file called GRANT, but not weewx.sdb_new >> >> So I guess that I'm completely out of my depth with not a clue what to do >> next. >> >> Any pointers on what to do next would be greatly appreciated. >> >> Pete >> >> >> On 12/11/25 16:01, vince wrote: >> >> Try 2 - google groups deleted my previous reply for unknown reasons. >> >> If you have 11 years of old data you likely have the original old wview >> compatible schema so I'd recommend you convert your db to the new >> wview_extended schema and rebuild-daily. There are lots of threads here >> with how to do that using 'weectl database'. In particular, Belchertown >> needs a few elements missing from the old schema. While you can add them >> each manually, it's (to me) easier to just upgrade the db and not need to >> worry it. Regardless, you'll need to rebuild-daily afterward to build the >> summary tables. >> >> Seasons and Belchertown each have their own NOAA trees that need to be >> generated one time on first startup if you didn't pre-seed your output HTML >> tree with previously generated files. That can take some time, once. >> Seasons typically is lightning fast once this is done, so if it took 145 >> seconds the first time, this might have been why. It should speed up after >> the NOAA files for your old data have been generated. >> >> On Thursday, December 11, 2025 at 11:02:19 AM UTC-8 Pete Geenhuizen wrote: >> >>> I downloaded v1.6 several days ago so I guess since then some additional >>> fixes were done, anyway I replaced belchertown.py with the one listed here >>> ad that solved that problem. >>> >>> Once I had everything working I decided to test the configuration by >>> copying over my existing database with 11 years of observations to ensure >>> that once I attached my weather station everything wold work seamlessly, >>> however that is not to be, I now get this error >>> >>> >>> I'm testing this new installation in simulator mode, and have copied my >>> existing database file with, 11 years of observations which I would hate to >>> loose, over to test that everything is working, but unfortunately am now >>> getting this error. >>> >>> Now when I start up weewx I get this database error, more info in the >>> attached log >>> >>> Dec 10 08:56:20 localhost weewxd[1246977]: INFO weewx.engine: Main loop >>> exiting. Shutting engine down. >>> Dec 10 08:56:20 localhost weewxd[1246977]: INFO weewx.engine: Shutting >>> down StdReport thread >>> Dec 10 08:56:40 localhost weewxd[1246977]: ERROR weewx.engine: Unable to >>> shut down StdReport thread >>> Dec 10 08:56:40 localhost weewxd[1246977]: CRITICAL __main__: Database >>> OperationalError exception: database is locked >>> Dec 10 08:56:40 localhost weewxd[1246977]: CRITICAL __main__: **** >>> Waiting 2 minutes then retrying... >>> Dec 10 08:56:41 localhost weewxd[1246977]: INFO weewx.cheetahgenerator: >>> Generated 12 files for report SeasonsReport in 145.34 seconds >>> >>> I found some suggestions on line to fix this but none have worked. >>> >>> Thanks >>> >>> Pete >>> >>> >>> On 12/9/25 16:30, Danny Ciarniello wrote: >>> >>> The uploaded version of belchertown.py looks like the one that comes >>> with the v1.6 release. That version had a number of issues that have since >>> been fixed. Replacing belchertown.py with the one vince pointed to should, >>> hopefully, fix the problem. >>> >>> On Tuesday, December 9, 2025 at 12:48:44 PM UTC-8 vince wrote: >>> >>>> Your weewx.conf works ok versus the uajqq version in github, but the >>>> belchertown.py that you uploaded here looks like it's not that version. >>>> >>>> In the belchertown.py skin you uploaded line 244 is the locale error >>>> if belchertown_debug: >>>> log.error( >>>> * f"Locale: Error using locale >>>> {self.generator.skin_dict["Extras"]["belchertown_locale"]}. "* >>>> f"This locale may not be installed on your >>>> system and you may see unexpected results. " >>>> f"Belchertown skin JavaScript will try to use >>>> this locale. Full error: %{error}" >>>> ) >>>> >>>> But around line 222 (much different) in >>>> https://github.com/uajqq/weewx-belchertown-new/blob/master/bin/user/belchertown.py >>>> >>>> I see: >>>> >>>> if belchertown_debug: >>>> log.error( >>>> f"Error using locale {belchertown_locale}. " >>>> "This locale may not be installed on your >>>> system and you may see unexpected results. " >>>> f"Python could not set the requested locale, >>>> but Belchertown skin JavaScript will attempt to use the provided locale >>>> string. Full error: {error}" >>>> ) >>>> >>>> So my wild guess is you have some hacked/previous/miscellaneous/unknown >>>> version of the forked skin. Perhaps try installing the real one ? >>>> >>>> On Tuesday, December 9, 2025 at 11:47:26 AM UTC-8 Pete Geenhuizen wrote: >>>> >>>>> I downloaded the v1.6 skin from here >>>>> https://github.com/uajqq/weewx-belchertown-new. >>>>> Attached is the output from weectl.debug >>>>> Thanks for your help. >>>>> Pete >>>>> >>>>> >>>>> On 12/9/25 12:40, vince wrote: >>>>> >>>>> "*using the new 1.6 forked version of the Belchertown skin*" - >>>>> without knowing 'which' forked version it might be difficult for people >>>>> to >>>>> help. >>>>> >>>>> How about running "weectl debug" and attaching the output so folks >>>>> can see your setup.... >>>>> >>>>> Based on the error you mention, best guess is you have [ something ] >>>>> with a mismatched number of [ and ] brackets. >>>>> >>>>> On Tuesday, December 9, 2025 at 8:23:25 AM UTC-8 Pete Geenhuizen wrote: >>>>> >>>>>> I trying to update my Rock 8 weewx v4 to Rocky 9 weewx v5 using the >>>>>> new >>>>>> 1.6 forked version of the Belchertown skin. >>>>>> >>>>>> I'm testing this out in simulator mode, and it sees to start fine >>>>>> until >>>>>> it does an update which start with this error >>>>>> >>>>>> ERROR weewx.reportengine: Caught unrecoverable exception in generator >>>>>> 'weewx.cheetahgenerator.CheetahGenerator' >>>>>> >>>>>> ERROR weewx.reportengine: **** f-string: unmatched '[' >>>>>> (belchertown.py, line 244) >>>>>> >>>>>> and goes down hill from there >>>>>> >>>>>> Attached is a copy of the last run.. >>>>>> >>>>>> I have very limited programming skills and zero knowledge of python, >>>>>> so >>>>>> I'm hoping that someone help me fix the problem. >>>>>> >>>>>> Thanks >>>>>> >>>>>> Pete >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> -- >>>>>> Unencumbered by the thought process. >>>>>> -- Click and Clack the Tappet brothers >>>>>> >>>>> -- >>>>> 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/22eccf9d-e3f5-4345-9da5-481f0451d17bn%40googlegroups.com >>>>> >>>>> <https://groups.google.com/d/msgid/weewx-user/22eccf9d-e3f5-4345-9da5-481f0451d17bn%40googlegroups.com?utm_medium=email&utm_source=footer> >>>>> . >>>>> >>>>> >>>>> -- >>>>> Unencumbered by the thought process. >>>>> -- Click and Clack the Tappet brothers >>>>> >>>>> >>>>> -- >>> 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/122a7232-eda2-441b-8d1e-caf3e59c0cc6n%40googlegroups.com >>> >>> <https://groups.google.com/d/msgid/weewx-user/122a7232-eda2-441b-8d1e-caf3e59c0cc6n%40googlegroups.com?utm_medium=email&utm_source=footer> >>> . >>> >>> -- >>> Unencumbered by the thought process. >>> -- Click and Clack the Tappet brothers >>> >>> -- >> 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/9152e81d-b589-4b3a-89de-5a4f57c12645n%40googlegroups.com >> >> <https://groups.google.com/d/msgid/weewx-user/9152e81d-b589-4b3a-89de-5a4f57c12645n%40googlegroups.com?utm_medium=email&utm_source=footer> >> . >> >> -- >> Unencumbered by the thought process. >> -- Click and Clack the Tappet brothers >> >> -- > 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/92a04861-b46c-4bdb-8e6b-a69d52fecb09n%40googlegroups.com > > <https://groups.google.com/d/msgid/weewx-user/92a04861-b46c-4bdb-8e6b-a69d52fecb09n%40googlegroups.com?utm_medium=email&utm_source=footer> > . > > -- > Unencumbered by the thought process. > -- Click and Clack the Tappet brothers > > -- 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/cae7e182-9e53-46f1-bb33-536e520e8ca8n%40googlegroups.com.
