On 13 Feb 2017, at 6:55pm, Jeff B. <[email protected]> wrote: > Should have read up on integrity_check before posting the results... I > re-worked my tool and here is the output: > > > pragma integrity_check; > > *** in database main *** > On tree page 11 cell 0: Rowid 424 out of order > wrong # of entries in index sqlite_autoindex_messages_priority_1 > **2 rows returned**
Just like they said, your index is corrupt. Unfortunately it’s an automatic index so you can’t easily remake it. And you have a password-protected database and maybe you can’t use the shell tool on it. Make a backup copy of the database file, just in case. Then try the VACUUM command. Then to the integrity_check thing again. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
