Re: [sqlite] Bad Database file

2004-03-05 Thread D. Richard Hipp
Greg Obleshchuk wrote: sqlite> PRAGMA integrity_check; *** in database main *** List of tree roots: invalid page number 24 List of tree roots: invalid page number 23 What would be the reasons for a database to go corrupt? Anyone have any ideas Versions of SQLite prior to 2.8.12 contain bugs that c

[sqlite] Bad Database file

2004-03-05 Thread Greg Obleshchuk
Hi, I just checked a database which was giving me problems using PRAGMA integrity_check; and discovered it was corrupt. sqlite> PRAGMA integrity_check; *** in database main *** List of tree roots: invalid page number 24 List of tree roots: invalid page number 23 What would be the reasons for a da