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+unsubscr...@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.
