On 12 Jun 2018, at 11:20pm, skywind mailing lists <mailingli...@skywind.eu> 
wrote:

> when I load my database into sqlite3 and run an integrity check I only get 
> the error message: Error: database disk image is malformed
> 
> I do not get any further information. What causes this simple error message?

It means that there's no obvious cause.  Which usually means that rather than a 
tiny detail being wrong (a single row pointer points to the wrong row) a big 
important thing is wrong (a page belongs to an index when it should belong to a 
table).

However, this is often caused by the database not being closed properly. Which 
suggests the database was written on a small device with no warning of quit 
(e.g. mobile phone) rather than a computer with a 'Quit' command.

So copy the database to a computer, and use the shell tool to make a trivial 
change to it, for example create a new table.  Then quit the shell tool 
properly with ".quit".

Then reopen the database and do another integrity check.  Does it still report 
the same error ?

Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to