Also, when using commands such as wee_database in a multi (WeeWX) instance environment you specify which WeeWX config file (and hence which database) you are operating on with the --config command line option, eg:
$ wee_database --config=/home/weewx/my_config.conf --drop-daily This is a concept that weewx-multi users need to be familiar with. Might pay to have a read of the Utilities Guide <http://weewx.com/docs/utilities.htm> for the utilities you need to use. Gary On Friday, 14 January 2022 at 08:56:29 UTC+10 gjr80 wrote: > I'm afraid your going to have to do a bit of self help. If you've taken > the steps to use MySQL/MariaDB there is an expectation you have some level > of familiarity with MySQL/MariaDB. All you are doing is searching your > archive table for values that are clear wrong. > > Something like: > > $ mysql -u root -p > mysql> SELECT * FROM archive WHERE windSpeed>100; > > or limit the fields you are displaying: > > mysql> SELECT datetime,windSpeed FROM archive WHERE windSpeed>100; > > > if you have any replace the 'bad' fields with null: > > mysql> UPDATE archive SET windSpeed=NULL WHERE windSpeed>100; > > Then drop/rebuild the daily summaries as per the wiki page. > > Gary > > On Friday, 14 January 2022 at 08:25:46 UTC+10 [email protected] wrote: > >> I have tried the instruction "old 'bad' data" . But I use the >> mysql-database. To convert the DB ( 1 million records) to a sqlite-DB was >> not succesfull. >> Furthermore run here 2 instances, so no weewx.conf or weewx db but with >> other names ( ecowitt.conf with weewx_eco db etc). >> >> Joachim >> >> gjr80 schrieb am Donnerstag, 13. Januar 2022 um 11:31:40 UTC+1: >> >>> Hi, >>> >>> Have you worked through the Cleaning up old 'bad' data wiki page >>> <https://github.com/weewx/weewx/wiki/Cleaning-up-old-'bad'-data> with >>> an emphasis on the field windSpeed? You most likely do not see the >>> spikes on the Seasons year plots as the Seasons year plots plot a day >>> average value, perhaps you are seeing the spikes on the Belchertown plots >>> because they plot a different aggregate (or perhaps no aggregate at all). >>> >>> Gary >>> >>> On Thursday, 13 January 2022 at 19:44:56 UTC+10 [email protected] >>> wrote: >>> >>>> >>>> Hi, >>>> >>>> how can i delete the two peaks in the berlchertown year chart? >>>> These peaks do not appear in the season year diagram. >>>> [image: wind-belchertown.png][image: wind-season.png] >>>> Joachim >>>> >>> -- 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/6e1e8233-d459-4be2-8ada-60fdbcd9d8efn%40googlegroups.com.
