Have you customised your WeeWX install? You appear to be using a package install so unless you have changed it your WeeWX database should be in /var/lib/weewx not /var/weewx.
Gary On Wednesday, 21 June 2023 at 05:48:19 UTC+1 [email protected] wrote: > the commands with semi-colons. send me (with sudo also and with suo su ) > > metfm@metfm:~$ sudo sqlite3 /var/weewx/weewx.sdb > SQLite version 3.34.1 2021-01-20 14:10:07 > Enter ".help" for usage hints. > sqlite> SELECT dateTime, datetime(dateTime, 'unixepoch','localtime'), > usUnits, rain FROM archive WHERE dateTime > 1686881600 AND dateTime <= > 1686981600; > Error: unable to open database "/var/weewx/weewx.sdb": unable to open > database file > metfm@metfm:~$ > > without semi-colons database open > > 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:~$ > but after restarting weewx no change in database. no 12.6 plus mm who i > needs > Στις Τρίτη 20 Ιουνίου 2023 στις 2:10:28 μ.μ. UTC+3, ο χρήστης gjr80 έγραψε: > >> 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/6ac56b3b-baec-464f-87b2-908ce446a345n%40googlegroups.com.
