I'm using SQLITE 3.5.1 - in Linux, Had Red 7.1, with a single thread application - and 2 different programs accessing the same database. I am getting the following message: SQL error: database disk image is malformed.
I copy the database to windows and run with sqlite and also get the same message. Running the following select command I get the same message: Select * from IDMsg; .... SQL error: database disk image is malformed. Now running the command "PRAGMA integrity_check": sqlite> PRAGMA integrity_check; *** in database main *** Main freelist: 138691677 of 4 pages missing from overflow list starting at 2972 On tree page 322 cell 0: 3 of 4 pages missing from overflow list starting at 297 1 Page 2936 is never used Page 2941 is never used Page 2963 is never used Page 2966 is never used Page 2968 is never used Page 2970 is never used sqlite> Running the VACUUM command the sqlite terminate abnormally (in windows). Any one has some idea what I have to check in my program to avoid corruption in database? What I can do, in my program, in startup, to check if the database is ok? Thanks for the help, Joaquim ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
