Hi,
as you wish. I have no extra/extended schema in my database.
#####
root@wetter:~# echo "select count(*) from pragma_table_info('archive');" |
sqlite3 /var/tmp/test.sdb
52
#####
vince schrieb am Freitag, 19. Januar 2024 um 08:32:51 UTC+1:
> 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/483c21ff-56b7-49a9-84bb-e2d3442a181cn%40googlegroups.com.
