My guess: You are missing a "COMMIT;" statement. Rainer Lang schrieb am Dienstag, 20. Juni 2023 um 09:21:47 UTC+2:
> at first glance looks ok to me - > but what I would do is: > download and install sqlitebrowser (suso apt-get install sqlitebrowser) > start it in update mode > sudo sqlitebrowser /var/weewx/weewx.sdb > and then go to your time stamp and add the values manually in the database > (don't forget to move the cursor to another field once you have filled in > your new data before pressing the write changes button in the menu: File > --> write changes) > also, check your database entries for rain, they may be in inches, so the > 12.6 mm need to be divided by 25.4 before entering into the database field) > afterwards run wee_database (between the archiving times !) > sudo wee_database --rebuild-daily --date=2023-06-17 > after the next archiving cycle the rain data should show (in the weekly > and monthly view) > you may have to delete the weekly and monthly pictures from your reporting > folder as weewx creates new entries only every half-day or daily for the > longer periods beyond daily. > > Maybe your update worked but only the weekly/monthly pictures and high/low > data were not updated in the report yet > > a restart of weewx should not be needed > > On 20.06.2023 08:04, Δημήτρης Βήχος wrote: > > here is me commands in terminal . trying to plus 12.1 missing mm in 17 > july total rainfall > > metfm@metfm:~$ sudo sqlite3 /var/weewx/weewx.sdb > [sudo] password for metfm: > SQLite version 3.34.1 2021-01-20 14:10:07 > Enter ".help" for usage hints. > sqlite> select datetime, datetime(dateTime, 'unixepoch','localtime'), rain > from archive where dateTime > 1686881600 and dateTime <= 1686981600 > ...> update archive set rain=12.6 where dateTime = 1686975900 > ...> .quit > ...> > metfm@metfm:~$ sudo wee_database --rebuild-daily --from=2023-06-17 > --to=2023-06-17 > [sudo] password for metfm: > Using configuration file /etc/weewx/weewx.conf > Using database binding 'wx_binding', which is bound to database > 'archive_sqlite' > Daily summary for 2023-06-17 will be rebuilt. > Proceed (y/n)? y > Rebuilding daily summaries in database 'weewx.sdb' ... > Processed 276 records to rebuild 1 daily summary in 0.12 seconds > Rebuild of daily summaries in database 'weewx.sdb' complete > metfm@metfm:~$ sudo /etc/init.d/weewx start > Starting weewx (via systemctl): weewx.service. > metfm@metfm:~$ > > something missing? something im doing wrong? the exetra mm never shows in > weewx restarting and updating. > > > > Στις Σάββατο 17 Ιουνίου 2023 στις 12:11:40 μ.μ. UTC+3, ο χρήστης Stefanos > Kalaitzis έγραψε: > >> First find the range of time(epoch) that you want to add the rain >> Enter to weeex.sdb >> >> sudo sqlite3 /home/weewx/archive/weewx.sdb >> >> Then check what values your station recorded >> >> select datetime, datetime(dateTime, 'unixepoch','localtime'), rain from >> archive where dateTime > 1686881600 and dateTime <= 1686981600; >> >> Then correct the time you want >> For example >> >> update archive set rain=1.0 where dateTime = 1686975900; >> >> Then exit the db >> >> .quit >> >> Stop weewx >> >> After all corrections rebuild the data base for that day >> >> >> sudo /home/weewx/bin/wee_database --rebuild-daily --from=2023-06-17 >> --to=2023-06-17 >> >> Start weewx >> >> Thats what i am doing when i have to add some missing mm in my db >> >> >> >> Στις Σάβ, 17 Ιουν 2023, 11:42 ο χρήστης Δημήτρης Βήχος < >> hobbyl...@gmail.com> έγραψε: >> >>> i want like to add some mm to my daily rainfall beacuse after power loss >>> , my console (fine offset) have 10mm above the weewx after the power on >>> again. >>> i had loss 10mm in my daily rain. >>> >>> thank you! >>> >> -- >>> 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+...@googlegroups.com. >>> To view this discussion on the web visit >>> https://groups.google.com/d/msgid/weewx-user/e96ce7e9-1085-46f6-adf4-b82275bf4df4n%40googlegroups.com >>> >>> <https://groups.google.com/d/msgid/weewx-user/e96ce7e9-1085-46f6-adf4-b82275bf4df4n%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+...@googlegroups.com. > > To view this discussion on the web visit > https://groups.google.com/d/msgid/weewx-user/1f9b1e17-6df0-4bc5-93b6-159f33bd1d12n%40googlegroups.com > > <https://groups.google.com/d/msgid/weewx-user/1f9b1e17-6df0-4bc5-93b6-159f33bd1d12n%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/cd17121b-024e-43c6-b460-31438aaf56bfn%40googlegroups.com.
