According to the weewx documentation : Action --reconfigure This action is useful for changing the schema or unit system in your database.
It creates a new database with the same name as the old, except with the suffix _new attached at the end (nominally, weewx.sdb_new if you are using SQLite, weewx_new if you are using MySQL). It then initializes it with the schema specified in weewx.conf. Finally, it copies over the data from your old database into the new database. I followed several years ago this method to add new fields in my weewx database, and it works perfectly. That said,I checked the documentation andI agree that the wee_database --add-column (this option was not available before February 2021...) will do the same, without having to rename the database. I will verify and if OK update the procedure described in my Github. Thanks > Le 18 juil. 2022 à 21:43, 'Peter Fletcher' via weewx-user > <weewx-user@googlegroups.com> a écrit : > > I have never explicitly used the schema management system, but my > understanding is that it is only relevant if you want to create a whole new > blank database using wee_database --create or --reconfigure. You don't appear > to need it if you use other wee_database options to (e.g.) add, drop, or > rename columns. > On Monday, July 18, 2022 at 10:35:03 AM UTC-4 jterr...@gmail.com wrote: > @Peter : if one want to update the database using wee_database, the new > updated schema with the new field is needed. Otherwise, in case of a manual > update of the database structure, the new schema is not needed. > > >> Le 18 juil. 2022 à 16:29, 'Peter Fletcher' via weewx-user >> <weewx...@googlegroups.com >> <applewebdata://61E5A804-25AD-47B7-9410-091307CAF1FA>> a écrit : >> > >> @Jacques: I initially had the same error (or a very similar one) as Jon B >> and had to comment out that last line. I had already manually added the >> sunshine_time field (as well as some others, previously) to my weewx >> database, so it didn't seem to be necessary or useful. My installation also >> did not seem to understand the schema assignment. Do you have a non-default >> extension loaded that enables this? >> >> > >> You received this message because you are subscribed to a topic in the >> Google Groups "weewx-user" group. >> To unsubscribe from this topic, visit >> https://groups.google.com/d/topic/weewx-user/19ylVTRqbh4/unsubscribe >> <https://groups.google.com/d/topic/weewx-user/19ylVTRqbh4/unsubscribe>. >> To unsubscribe from this group and all its topics, send an email to >> weewx-user+...@googlegroups.com >> <applewebdata://61E5A804-25AD-47B7-9410-091307CAF1FA>. > >> To view this discussion on the web visit >> https://groups.google.com/d/msgid/weewx-user/a85805b1-dfe9-41de-9079-56f4a951546bn%40googlegroups.com >> >> <https://groups.google.com/d/msgid/weewx-user/a85805b1-dfe9-41de-9079-56f4a951546bn%40googlegroups.com?utm_medium=email&utm_source=footer>. > > > -- > You received this message because you are subscribed to a topic in the Google > Groups "weewx-user" group. > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/weewx-user/19ylVTRqbh4/unsubscribe > <https://groups.google.com/d/topic/weewx-user/19ylVTRqbh4/unsubscribe>. > To unsubscribe from this group and all its topics, send an email to > weewx-user+unsubscr...@googlegroups.com > <mailto:weewx-user+unsubscr...@googlegroups.com>. > To view this discussion on the web visit > https://groups.google.com/d/msgid/weewx-user/1a4d0ef0-60d3-403c-b15c-bef5f78deda3n%40googlegroups.com > > <https://groups.google.com/d/msgid/weewx-user/1a4d0ef0-60d3-403c-b15c-bef5f78deda3n%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 weewx-user+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/EF5DB825-071B-4CAF-AEA8-E6FE6B889637%40gmail.com.
