oops - sorry - it is /var/lib/weewx/weewx.sdb if you installed via the packaged installer.
On Sunday, January 10, 2021 at 1:59:42 PM UTC-8 vince wrote: > 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/3dbdab02-f587-426a-b93f-4f7b75d70904n%40googlegroups.com.
