Quote:
Originally Posted by davidfor
That means there is a corruption in the database. But, you can recover from that one. You need to rebuild the index. If you get an SQLite management tool, reindex. Some of the tools have an options to do it. Otherwise, you need to run the statement:
Code:
REINDEX sqlite_autoindex_Activity_1
You can do this with SQLiteSpy, SQLite Database Browser or any of the others. |
Hi,
I'm trying to do that but a got the message:
UNIQUE constraint failed: Activity.Id, Activity.Type: reindex sqlite_autoindex_Activity_1
Errors are some
row 26 missing from index sqlite_autoindex_Activity_1
And at the end
wrong # of entries in index sqlite_autoindex_Activity_1
Any clue?
Thanks
------------------------------
Ok, fixed all that, but I still got
Page 258 is never used
Page 259 is never used
Page 260 is never used
Help plz
