Hi, thanks for the tip. I removed the old reports in
/var/www/html/weewx Reinstalled 5.2.0 (openSUSE 15.6 repos) Noticed that my weewx.conf was still # Do not modify this. It is used when installing and updating weewx. version = 4.10.2 Fixed that with the new weewx.conf from the 5.2.0 install # This configuration file was created by ... version = 5.2.0 As per https://www.weewx.com/docs/5.2/usersguide/where/ I set the skins to the absolute path on my system [StdReport] # Where the skins reside, relative to WEEWX_ROOT SKIN_ROOT = /usr/share/weewx/weewx_data/skins # Where the generated reports should go, relative to WEEWX_ROOT HTML_ROOT = /var/www/html/weewx The web page runs again (also had an Apache issue to resolve) but the Monthly reports still show the gaps as prevoius, example: MONTHLY CLIMATOLOGICAL SUMMARY for Nov 2025 NAME: Cary, NC USA ELEV: 348 feet LAT: 35-47.90 N LONG: 078-50.46 W TEMPERATURE (F), RAIN (in), WIND SPEED (mph) HEAT COOL AVG MEAN DEG DEG WIND DOM DAY TEMP HIGH TIME LOW TIME DAYS DAYS RAIN SPEED HIGH TIME DIR --------------------------------------------------------------------------------------- 01 02 03 04 05 06 07 08 09 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 42.6 52.1 14:30 32.9 00:00 22.4 0.0 0.00 0.9 15.0 16:30 338 28 36.7 46.2 14:00 28.8 07:30 28.3 0.0 0.00 0.9 18.0 10:30 329 29 34.9 45.5 14:00 23.9 07:00 30.1 0.0 0.00 0.3 9.0 10:30 98 30 44.9 54.9 13:00 36.8 02:00 20.1 0.0 0.25 0.1 7.0 14:00 304 --------------------------------------------------------------------------------------- 39.3 54.9 30 23.9 29 100.8 0.0 0.25 0.5 18.0 28 338 That data had been showing on the other system (which was mostly a mirror as this one) One thing I do notice though is before I was only seeing Monthly Data up to May 2023, now I see it 27 Dec 2024. I working on learning the sqlite syntax.... I assume the above command is a generic example... On Tuesday, January 20, 2026 at 4:22:24 PM UTC-5 Tom Keffer wrote: > Not a lot of information here, but assuming you're running the Seasons > report, and assuming that by "Monthly report" you mean the NOAA reports, > one thing you could try is deleting all of the generated files and let > WeeWX recreate them. This will ensure that what you're seeing is what is > truly in the database. > > As for seeing what records are in the database, that could be a very long > list indeed --- perhaps hundreds of thousands or even millions of records. > For a shorter summar, you could ask it for which months it has any record > at all. Assuming that you are using SQLite and that you have the tool > "sqlite3" installed, use it to look inside the database. Assuming that you > did a package install (not pip), then this would look like: > > *sqlite3 /var/lib/weewx/weewx.sdb* > sqlite> *select distinct > strftime("%Y-%m",dateTime,'unixepoch','localtime') from archive;* > sqlite> *.quit* > > Depending on how long you've been using your database, this could a > hundred lines or so. > > If you want even finer detail and wish to see which days have data, you > could do > > sqlite> *select distinct date(dateTime,'unixepoch','localtime') from > archive;* > > But be prepared, this could list thousands of lines. > > I've made a lot of assumptions above. If any are wrong come back with more > information. > > -tk > > On Mon, Jan 19, 2026 at 9:34 PM Jim Wilkerson <[email protected]> wrote: > >> I recent had an event where I needed to move my weewx database to a >> different drive. >> >> I had first started the backup system, which had not been up since about >> May 2023. >> >> Once I copied the database over to the new location and restarted weewx, >> all starts but when I look in the web UI the Monthly Reports show no data >> from 28 May 2023 (the last time the system was apparently up, until 25 Nov >> 2025/ >> >> How can I list the database records to make sure they are intact, then >> get the historical data to be viewable once more on the Web UI reports? >> >> Weewx version 5.2.0 >> openSUSE LEAP 15.6 >> >> <code> >> # weectl database check >> Using configuration file /etc/weewx/weewx.conf >> Checking daily summary tables version... >> Daily summary tables are at version 4.0. >> Interval Weighting Fix is not required.</code> >> >> -- >> 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/4d2b261f-4c39-428f-92f4-4b804e9562cfn%40googlegroups.com >> >> <https://groups.google.com/d/msgid/weewx-user/4d2b261f-4c39-428f-92f4-4b804e9562cfn%40googlegroups.com?utm_medium=email&utm_source=footer> >> . >> > -- 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/efaf76d1-664c-402c-91e7-30a1fd03a116n%40googlegroups.com.
