You spelled it wrong - it's /var/lib/weewx.sdb You might also need to preface your command with 'sudo'
On Sunday, January 10, 2021 at 1:50:24 PM UTC-8 [email protected] wrote: > I have already read this thread. But I did not succeed. As written I have > installed sqlite3 but I can't get very far.... > > > linaro@MyServer:~$ sqlite3 /var/weewx/weedwx.sdb > SQLite version 3.11.0 2016-02-15 17:29:24 > Enter ".help" for usage hints. > sqlite> select dateTime, datetime(dateTime, 'unixepoch', 'localtime'), > interval from archive where interval<=0; > Error: unable to open database "/var/weewx/weedwx.sdb": unable to open > database file > linaro@MyServer:~$ > > vince schrieb am Sonntag, 10. Januar 2021 um 22:10:14 UTC+1: > >> On Sunday, January 10, 2021 at 11:46:15 AM UTC-8 [email protected] wrote: >> >>> Jan 10 20:28:11 MyServer python2[28539]: weewx[28539] CRITICAL >>> __main__: **** IntervalError: Non-positive value for record field >>> 'interval': 0 >>> Jan 10 20:28:11 MyServer python2[28539]: weewx[28539] CRITICAL >>> __main__: **** Exiting. >>> >>> >>> >> >> There was just another thread about this a day or two ago. You have to >> do a little cleanup of your database to remove some odd old records. >> >> See https://groups.google.com/g/weewx-user/c/cPTRWVE2lBE/m/ejDCU-WMBgAJ >> for details.... >> >> > -- 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/46f79fe7-0a74-42ac-a66f-a22cc8512ac3n%40googlegroups.com.
