It's not impossible, but I'd be surprised if there are any WeeWX installations using Sqlite 2. It was phased out nearly 5 years before the first version of WeeWX!
On Tue, Jan 19, 2021 at 8:44 AM [email protected] < [email protected]> wrote: > Hello, > Your error message is the one I receive when I try to use a sqlite3 file > with sqlite2 or vice et versa. > Use the command "file xxx.sdb" to find the type of sqlite [2/3] it is, > and verify which sqlite you are using. > The command "sqlite -version" return the version as expected. Be careful > that "sqlite" (no 2 neither3) is sometimes associated with one or the > other. There is not much difference between them, except that they store > the data in different format that are 100% incompatible!. Much better to > always call the version explicitly. > In the (very improbable) case that your sdb file is in the wrong format, > you can easily change it to the right one by dumping the data using the > corresponding version of sqlite ( .output MyData.sql <cr> .dump) to write > the data in readable format, then reading back with the correct sqlite > (Most probably sqlite3 < MyData.sql). > Regards, Paul > > > > > Le Tuesday, January 19, 2021 à 4:20:59 AM UTC+1, vince a écrit : > >> On Monday, January 18, 2021 at 6:47:09 PM UTC-8 [email protected] wrote: >> >>> Now when I try to copy the unpacked sdb and pick up where I left off I >>> get a message that the file is not a database. I have tried a couple of >>> archives from Dec and Jan. All seem to be no good. I did notice that when >>> I reinstalled weewx it is now version 4.3.0. Could I be dealing with a >>> system version mismatch in the file or is there something wrong with my >>> backup process. >>> >> >> Very likely a backup process issue, although the steps you mentioned >> looked good to me. >> >> We'd need to see some actual logs or terminal errors to know for certain >> what you're actually seeing. >> >> I guess what I'd do is: >> >> - grab a recent backup, copy it to a scratch directory >> - uncompress it to a .sdb file >> - run 'file' against the .sdb file >> - If it shows up as a sqlite3 db, then you can validate it with the >> sqlite3 utility. >> >> >> Good output looks like.... >> >> # file weewx.sdb >> weewx.sdb: SQLite 3.x database, last written using SQLite version 3026000 >> >> # echo "pragma integrity_check" | sqlite3 weewx.sdb >> ok >> >> >> -- > 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/2357efa0-741b-41bd-9724-5080eb29a73cn%40googlegroups.com > <https://groups.google.com/d/msgid/weewx-user/2357efa0-741b-41bd-9724-5080eb29a73cn%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/CAPq0zED_Rcx4u-4H5C2PS3n5bwGE_DmbqaLrNirPVCd3m%3DG5Zw%40mail.gmail.com.
