View Single Post
Old 11-25-2017, 05:42 PM   #1442
davidfor
Grand Sorcerer
davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.
 
Posts: 24,905
Karma: 47303824
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos
Quote:
Originally Posted by stanlefor View Post
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
How did you fix the above?
Quote:
Page 258 is never used
Page 259 is never used
Page 260 is never used

Help plz
Do a compress of the database. That exports and reimports the data and should fix problems like these. It will also fix the issues with indexes.
davidfor is offline