is there another possibility but exporting and importing the data to get rid of: SQL error: database disk image is malformed ?
here the details of the error and the commands we used. but we are not sure why exporting works and vacuum should not work. we used sqlite 3.6.10, solaris. # sqlite3 trac.db sqlite> PRAGMA integrity_check; *** in database main *** Page 39762: sqlite3BtreeInitPage() returns error code 11 On tree page 39768 cell 0: 2nd reference to page 39762 Page 39763 is never used Page 39764 is never used Page 39765 is never used Page 39766 is never used Page 39767 is never used SQL error: database disk image is malformed sqlite> vacuum; SQL error: database disk image is malformed # sqlite3 trac.db .dump .quit >> trac.db.dump # mv trac.db trac.db.orig # sqlite3 trac.db < trac.db.dump _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
