Pete - this came up only 7 days ago in an extended thread. See https://groups.google.com/g/weewx-user/c/6zJCXEte-js/m/eSITjnCwCAAJ for the howto. Be sure to copy your existing db and work off a temporary copy while doing this just in case.
On Friday, December 12, 2025 at 9:05:16 AM UTC-8 Danny Ciarniello wrote: > 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/056fdef0-9436-4820-8e6e-e86cfbc19435n%40googlegroups.com.
