The problem might have arrived on 5th December - but did you zeroise or nullify ALL the wrong values ?? Maybe you missed one or more.
The simplest is to check the archive table with something like SELECT dateTime, rain from archive where rain > 100; (or some other appropriate value) Then UPDATE archive set rain = 0 where rain > 100; (or as appropriate) Then check by repeating SELECT dateTime, rain from archive where rain > 100; you should get none returned this time Then drop daily Then backfill daily On Friday, 16 December 2016 09:44:54 UTC+2, Marc Aubry wrote: > I just rebuilt the daily table just in case. but i had already deleted > this values in archive and daily table few days ago. > i did have wait long enough because this problem arrive on the 5th of > december and i remove the data from mysql on the 6th of december s, so i > assume that the report have been rebuilt since. > i have just finish to rebuilt the table (which is long because i have > imported my previous cumulus data since 2014) but the monthly report still > show > Rain Total 33554688.5 mm > > the html are deleted at each reboot because i 'm using a ram disk to save > my sd card so this disk is remounted at each boot. > what did i do wrong ? > > thanks > > On Friday, December 16, 2016 at 2:14:01 PM UTC+7, Andrew Milner wrote: >> >> If the wrong value(s) are in daily tables and you want to rebuild the >> daily tables from the archive then yes, you can rebuild by using drop and >> backfill. >> >> If the database is correct the problem may just be that you need to wait >> a while - the yearly html page is only built once a day (at midnight) - and >> you can force a regeneration by deleting the .html. Likewise the monthly >> is only generated every three hours (I think), but can be forced by >> deleting the monthly .html file >> >> >> >> On Friday, 16 December 2016 08:02:35 UTC+2, Marc Aubry wrote: >> >>> thanks for your reply >>> do i have to do >>> wee_database --drop-daily >>> before >>> wee_database --backfill-daily >>> >>> ?????? >>> >>> >>> On Friday, December 16, 2016 at 9:20:35 AM UTC+7, Tom Keffer wrote: >>>> >>>> Rebuild the daily summaries >>>> <http://weewx.com/docs/utilities.htm#Action_--drop-daily>. >>>> >>>> -tk >>>> >>>> On Thu, Dec 15, 2016 at 6:11 PM, Marc Aubry <[email protected]> wrote: >>>> >>>>> hi >>>>> i have a wrong total rain value on the monthly and year report. >>>>> for the 05th december 2016 it show 33554455 mm of rain. >>>>> http://web.cubadak-paradisovillage.com/weather/NOAA/NOAA-2016-12.txt >>>>> http://web.cubadak-paradisovillage.com/weather/month.html >>>>> http://web.cubadak-paradisovillage.com/weather/year.html >>>>> >>>>> i have already corrected the value in the mysql database for the >>>>> archive table and archiveday_rain table. >>>>> this 33m of rain does'nt appear in the graph. >>>>> what did i missed here ????? >>>>> >>>>> thanks >>>>> >>>>> *weewx 3.6.2-1* >>>>> *rapberry pi 2* >>>>> *misol WH2310* >>>>> *http://web.cubadak-paradisovillage.com/weather* >>>>> <http://web.cubadak-paradisovillage.com/weather> >>>>> >>>>> >>>>> >>>>> -- >>>>> 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]. >>>>> For more options, visit https://groups.google.com/d/optout. >>>>> >>>> >>>> -- 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]. For more options, visit https://groups.google.com/d/optout.
