On 8 Sep 2011, at 2:22pm, Ian Hardingham wrote: > This query works fine: > > SELECT * FROM eloResultTable > > This query returns Error 11 - Database disk image is malformed > > SELECT * FROM eloResultTable ORDER BY elo DESC
Please run "PRAGMA integrity_check;" on the database. You can code it into one of your own apps or use the 'sqlite3' shell tool. <http://www.sqlite.org/pragma.html#pragma_integrity_check> Which API are you using to make changes to the database ? Does your database have any TRIGGERs or FOREIGN KEYs in ? Simon. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
