In my case with the same problem, im NOT using the extended schema - it
returns 52.
On Friday 19 January 2024 at 16:32:51 UTC+9 vince wrote:
> Followup on this one - If the original poster can check to see if their
> database uses the old original (small) wview schema that would likely help.
> Easiest way is to look to see how many elements are in the database. One
> way to see how many elements you have in your db would be:
>
> - cp weewx.sdb /var/tmp/test.sdb
> - echo "select count(*) from pragma_table_info('archive');" | sqlite3
> /var/tmp/test.sdb
> - (my db with the extended schema returns "114" as the count)
> - (a db with the original wview schema returns "52" as the count)
>
>
> Switching to the extended schema is a bit of work and takes some time.
> The details are documented at
> http://www.weewx.com/docs/5.0/custom/database/ with the procedure for how
> to switch to the new bigger schema in
> http://www.weewx.com/docs/5.0/custom/database/#reconfigure-using-new-schema
> - but be CAREFUL doing this and ALWAYS work off a copy of your db so if
> anything happens you can revert to a known good db. I've done it so many
> years ago at this point that I'll have to defer to others for pitfalls and
> how they do it, but the links above are how the current docs recommend
> doing so.
>
> Short description to the original Belchertown problem reporters - check
> your db schema. Hopefully that's the pattern of which systems will need to
> take action.
>
>
>
--
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 on the web visit
https://groups.google.com/d/msgid/weewx-user/a9f501bc-35a6-453e-a8ba-a558d7958103n%40googlegroups.com.
