Thank you vince. That makes sense. These are the columns of table archive? Are you using mariadb/mysql? Could you please post the result of "describe archive;" then.
Could somebody please post a script to upgrade a mariadb from v4 to v5? Is there a migration guide describing this step? Is it sufficient to add these columns? vince schrieb am Donnerstag, 4. Dezember 2025 um 18:15:34 UTC+1: > If your weewx was fast with v4 and it is very slow with v5, you are very > likely trying to display something in a skin that is calculated yet not an > element in the db. This is a change that occurred in v5. > > The schema definition in the db only creates new columns if you are > 'creating' a 'new' database, if I remember correctly. > > - Your database has 53 items in the archive record. That means you > are using the old 'small' schema. > - My db has 114 items in the archive record. That means I am using the > newer wview-extended schema. > > Your db is missing the following elements that were added in the > wview-extended schema. > > appTemp appTemp1 > batteryStatus1 batteryStatus2 batteryStatus3 batteryStatus4 batteryStatus5 > batteryStatus6 batteryStatus7 batteryStatus8 > cloudbase > co > co2 > dewpoint1 > extraHumid3 extraHumid4 extraHumid5 extraHumid6 extraHumid7 extraHumid8 > extraTemp4 extraTemp5 extraTemp6 extraTemp7 extraTemp8 > forecast > hailBatteryStatus > heatindex1 > humidex humidex1 > illuminance > inDewpoint > lightning_distance lightning_disturber_count lightning_energy > lightning_noise_count lightning_strike_count luminosity > maxSolarRad > nh3 > no2 > noise > o3 > pb > pm1_0 pm10_0 pm2_5 > signal1 signal2 signal3 signal4 signal5 signal6 signal7 signal8 > snow snowBatteryStatus snowDepth snowMoisture snowRate > so2 > uvBatteryStatus > windrun > > > On Thursday, December 4, 2025 at 7:49:30 AM UTC-8 Zed wrote: > >> The differences in Seasons/skin.conf are: >> >> 8c8 >> < SKIN_VERSION = 5.2.0 >> --- >> > SKIN_VERSION = 4.9.1 >> 29c29 >> < # If you have a Google Analytics GA4 tag, uncomment and edit the >> next line, and >> --- >> > # If you have a Google Analytics ID, uncomment and edit the next >> line, and >> 31c31 >> < #googleAnalyticsId = G-ABCDEFGHI >> --- >> > #googleAnalyticsId = UA-12345678-1 >> 269c269 >> < time_length = 27h >> --- >> > time_length = 97200 # 27 hours >> 350c350 >> < aggregate_interval = 1h >> --- >> > aggregate_interval = hour >> 359c359 >> < aggregate_interval = 1h >> --- >> > aggregate_interval = hour >> 384c384 >> < aggregate_interval = 1h >> --- >> > aggregate_interval = hour >> 410c410 >> < aggregate_interval = 1h >> --- >> > aggregate_interval = hour >> 488c488 >> < aggregate_interval = 1d >> --- >> > aggregate_interval = day >> 496c496 >> < aggregate_interval = 1d >> --- >> > aggregate_interval = day >> 521c521 >> < aggregate_interval = 1d >> --- >> > aggregate_interval = day >> 546c546 >> < aggregate_interval = 3h >> --- >> > aggregate_interval = 10800 # 3 hours >> 625c625 >> < aggregate_interval = 1d >> --- >> > aggregate_interval = day >> 633c633 >> < aggregate_interval = 1d >> --- >> > aggregate_interval = day >> 658c658 >> < aggregate_interval = 1d >> --- >> > aggregate_interval = day >> 683c683 >> < aggregate_interval = 1d >> --- >> > aggregate_interval = day >> 762c762 >> < aggregate_interval = 1w >> --- >> > aggregate_interval = week >> 770c770 >> < aggregate_interval = 1w >> --- >> > aggregate_interval = week >> 795c795 >> < aggregate_interval = 1w >> --- >> > aggregate_interval = week >> >> >> Tom Keffer schrieb am Donnerstag, 4. Dezember 2025 um 16:35:39 UTC+1: >> >>> Yes, reports that use derived types can be slow if the type is not in >>> the database. The Belchertown skin has this problem because of its use of >>> type 'appTemp'. However, the Seasons skin does not do this. (Unless, of >>> course, you extended it.) >>> >>> The declaration for schema >>> >>> schema = schemas.wview_extended.schema >>> >>> does not make any difference. It's only used when the database is >>> created. >>> >>> What type of Raspberry Pi are you using? I've used everything from an >>> RPi Zero on with no problem, but it will be slow. >>> >>> These performance problems can be difficult to diagnose. I would suggest >>> commenting out the template declarations in Seasons/skin.conf one by one >>> until you find the culprit. >>> >>> -tk >>> >>> >>> >>> >>> >>> >>> On Thu, Dec 4, 2025 at 6:28 AM Zed <[email protected]> wrote: >>> >>>> Is the report generation dependent from the database layout? >>>> What makes you think, 3rd party templates are in use? >>>> >>>> There is a difference in "schema" in weewx.conf: >>>> Before (v4.9.1): >>>> >>>> [DataBindings] >>>> [[wx_binding]] >>>> database = archive_mysql >>>> table_name = archive >>>> manager = weewx.manager.DaySummaryManager >>>> schema = schemas.wview_extended.schema >>>> >>>> Now (v5.2.0): >>>> >>>> [DataBindings] >>>> [[wx_binding]] >>>> database = archive_mysql >>>> table_name = archive >>>> manager = weewx.manager.DaySummaryManager >>>> schema = weewx.schemas.wview_extended.schema >>>> >>>> Could this cause this issue? >>>> John Smith schrieb am Donnerstag, 4. Dezember 2025 um 14:51:36 UTC+1: >>>> >>>>> On Fri, 5 Dec 2025 at 00:38, Zed <[email protected]> wrote: >>>>> >>>>>> how can i check the columns? Attached please find the db-columns >>>>>> currently defined. >>>>>> >>>>> >>>>> I have no direct experience with using 3rd party templates, but you'd >>>>> have to look for things in the template(s) that have no corresponding >>>>> columns in the DB, especially for things like monthly or yearly stats >>>>> etc... >>>>> >>>>> When debugging things in general you should disable everything, and >>>>> then turn features back on one by one until you hit the same behaviour. >>>>> >>>> -- >>>> >>> 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/4ad2d41d-1343-4daa-9443-4bf567c2435fn%40googlegroups.com >>>> >>>> <https://groups.google.com/d/msgid/weewx-user/4ad2d41d-1343-4daa-9443-4bf567c2435fn%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/d7254eb9-dde1-4dd5-a102-a2315701ad8an%40googlegroups.com.
