On Saturday, May 1, 2021 at 8:24:12 AM UTC-7 [email protected] wrote:
> * i copied producton weewx.sdb to dev/test (different host) > weewx-gw1000.sdb, > * in which i dropped lots of columns and renamed others (using > wee_database —drop-columns and —rename-column respectively) > * then i dropped daily summaries (using wee_database —drop-daily). > * when i try to rebuild daily summaries (using wee_database > —rebuild-daily), it reports a failure that a daily table already (still) > exists - this table corresponds to a column that i did *not* alter > > before doing —drop-daily i also deleted the content of a number of columns > (obviously not the dropped ones) using sql clause of form ‘update table set > altimeter = NULL, heatindex = NULL;’, preparatory to doing a —calc-missing > after some new values were to be loaded into core columns such as outTemp > and outHumidity > > You are changing so much (why ?) in a seemingly random order that I'd suggest starting over. - take your working database and make a copy - drop daily on the copy - rebuild daily on the copy - it should work If you just want to start over completely, dump your archive table only and restore it to a new db name. Then run rebuild-daily against that. That should definitely work unless you somehow messed up the schema in all your fiddling around. Make one change at a time. -- 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/c8eaf581-e2ee-4e9b-82a6-224233ed5cc4n%40googlegroups.com.
