2009/6/17 hiral <hiralsmaill...@gmail.com>: > Hi Simon, > > I looked into it but couldn't find the exact reason for my bug. > > If you have any idea please let me know.
Sorry, other than the link, I can not help. > > Also I would appreciate, if you can let me know what does this error mean > in terms of btree/pager module of sqlite.... > >>> sqlite> PRAGMA integrity_check; >>> *** in database main *** >>> Page 5275 is never used >>> wrong # of entries in index sqlite_autoindex_<table_name>_1 Other than that the db is corrupt, I could not say. If I ever get a corrupted db (from users with unsafe environments), I extract whatever data it is possible to extract ( see .dump in sqlite3 command line utility), and reconstruct a new db using that data. It has not seemed worthwhile trying to analyse/repair a corrupt db. Identifying where the db has been corrupted will not necessarily indicate the event that caused it. > Thank you. > -Hiral Rgds, Simon _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
