> This query works fine: > SELECT * FROM eloResultTable > This query returns Error 11 - Database disk image is malformed > SELECT * FROM eloResultTable ORDER BY elo DESC > Any ideas?
REINDEX eloResultScore; should help you. Pavel On Thu, Sep 8, 2011 at 9:22 AM, Ian Hardingham <[email protected]> wrote: > Hey guys. > > I have this table: > > eloResultTable (id INTEGER PRIMARY KEY AUTOINCREMENT, player TEXT, elo > FLOAT) > > (I also happen to have this index: CREATE INDEX IF NOT EXISTS eloResultScore > ON eloResultTable (elo DESC)) > > This query works fine: > > SELECT * FROM eloResultTable > > This query returns Error 11 - Database disk image is malformed > > SELECT * FROM eloResultTable ORDER BY elo DESC > > Any ideas? > > Thanks, > Ian > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
