Cannot open databases with WAL journal mode.

pvanek / sqliteman

http://sqliteman.com/

160 stars 58 forks source link

Cannot open databases with WAL journal mode. #18

Open anaili opened 8 years ago

anaili commented 8 years ago

Starting by sqlite 3.7.0 ( https://www.sqlite.org/releaselog/3_7_0.html ) a new "Write-Ahead Log" option (hereafter referred to as "WAL") has been introduced. It seems that sqliteman is not able to load databases with this journal mode. I'm getting an error saying "unable to open or create file . It is probably not a database". I've attached a sample database file to reproduce the issue, you have just to open it using sqliteman. SampleWAL.zip

rparkins999 commented 7 years ago

This issue may be fixed in rparkins999/sqliteman. At least it opens SampleWAL.sqlite and finds 44 tables, although none of them seems to contain any data.