It should be /var/lib/weewx/archive/weewx.sdb Can you give us a screenshot where the weewx.sdb is??
Στις Τετ, 21 Ιουν 2023, 11:03 ο χρήστης Δημήτρης Βήχος < hobbyline...@gmail.com> έγραψε: > debian installed. also triyng with sudo sqlite3 /var/lib/weewx/weewx.sdb > same thing. > > Στις Τετάρτη 21 Ιουνίου 2023 στις 9:55:34 π.μ. UTC+3, ο χρήστης gjr80 > έγραψε: > >> 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 hobbyl...@gmail.com 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 hobbyl...@gmail.com 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+unsubscr...@googlegroups.com. > To view this discussion on the web visit > https://groups.google.com/d/msgid/weewx-user/88595a49-17a9-4e1f-9fc1-6d884f9f1863n%40googlegroups.com > <https://groups.google.com/d/msgid/weewx-user/88595a49-17a9-4e1f-9fc1-6d884f9f1863n%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/CAERekb-WdE5z5QAY8F_mrS0uz-i6Tm43-xZkpDtyRtjBqWuSXw%40mail.gmail.com.
