At a guess I would say your sqlite3 commands were never executed due to missing semi-colons at the end of each sqlite3 command line. Your commands are basically fine, but you need to be careful with the datetime/dateTime case in the commands. No need for commits as your are not processing multiple commands as a transaction. When editing the database you do need to be mindful of your database units and make sure you use the same units in your update queries. If using sqlite command line the easiest thing to do is to look at the usUnits field. 1=US customary=inches, 16=Metric=cm, 17=MetricWX=mm. Whether you use sqlite3 or a gui tool like sqlitebrowser does not really matter, just check that your data was changed after you make the change and if using a gui be very careful to not leave any fields with null strings(though this is usually associate with deleting data rather than updating it). FWIW if using sqlite3 I would use this sequence of commands:
$ sqlite3 /home/weewx/archive/weewx.sdb sqlite> SELECT dateTime, datetime(dateTime, 'unixepoch','localtime'), usUnits, rain FROM archive WHERE dateTime > 1686881600 AND dateTime <= 1686981600; sqlite> UPDATE archive SET rain=12.6 WHERE dateTime = 1686975900; sqlite> SELECT dateTime, datetime(dateTime, 'unixepoch','localtime'), usUnits, rain FROM archive WHERE dateTime=1686975900; sqlite> .q $ sudo wee_database --rebuild-daily --date=2023-06-17 In terms of the Seasons skin your updated data may causes changes to rain plots (all except the 'today' plot), the June 2023 and 2023 NOAA format reports and the statistics widget/page. All should come good in time (max 24 hours) provided you update your data sometime this month, but if you want to speed things up delete all your rain plots on your WeeWX machine. If you update your data in say July you will need to delete the June 2023 and 2023 NOAA format reports and all subsequent NOAA format reports to force regeneration. Can't speak for any other skins. Gary On Tuesday, 20 June 2023 at 07:04:56 UTC+1 [email protected] 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 ο χρήστης Δημήτρης Βήχος <[email protected]> έγραψε: 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 [email protected]. 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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/cd9c144d-0583-4e4d-981b-b455b27c09ccn%40googlegroups.com.
