Register Guidelines E-Books Search Today's Posts Mark Forums Read

Go Back   MobileRead Forums > E-Book Software > Calibre > Plugins

Notices

Reply
 
Thread Tools Search this Thread
Old 11-25-2017, 10:35 AM   #1441
stanlefor
Connoisseur
stanlefor can self-interpret dreams as they happen.stanlefor can self-interpret dreams as they happen.stanlefor can self-interpret dreams as they happen.stanlefor can self-interpret dreams as they happen.stanlefor can self-interpret dreams as they happen.stanlefor can self-interpret dreams as they happen.stanlefor can self-interpret dreams as they happen.stanlefor can self-interpret dreams as they happen.stanlefor can self-interpret dreams as they happen.stanlefor can self-interpret dreams as they happen.stanlefor can self-interpret dreams as they happen.
 
Posts: 78
Karma: 20528
Join Date: Oct 2012
Device: kobo touch
Quote:
Originally Posted by davidfor View Post
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

Last edited by stanlefor; 11-25-2017 at 10:54 AM.
stanlefor is offline   Reply With Quote
Advert
Old 11-25-2017, 06: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: 13,663
Karma: 22998798
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo: Touch, Glo, Aura H2O, Glo HD, Aura ONE
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   Reply With Quote
Old 11-29-2017, 08:37 AM   #1443
stanlefor
Connoisseur
stanlefor can self-interpret dreams as they happen.stanlefor can self-interpret dreams as they happen.stanlefor can self-interpret dreams as they happen.stanlefor can self-interpret dreams as they happen.stanlefor can self-interpret dreams as they happen.stanlefor can self-interpret dreams as they happen.stanlefor can self-interpret dreams as they happen.stanlefor can self-interpret dreams as they happen.stanlefor can self-interpret dreams as they happen.stanlefor can self-interpret dreams as they happen.stanlefor can self-interpret dreams as they happen.
 
Posts: 78
Karma: 20528
Join Date: Oct 2012
Device: kobo touch
You're the boss...
stanlefor is offline   Reply With Quote
Reply

Tags
kobo

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
[GUI Plugin] EpubSplit JimmXinu Plugins 209 12-04-2017 02:17 PM
[GUI Plugin] Hyphenate This! SauliusP. Plugins 316 10-15-2017 04:09 PM
[GUI Plugin] KindleUnpack - The Plugin DiapDealer Plugins 403 07-29-2017 02:19 PM
[GUI Plugin] Wordpress frescogamba Plugins 11 04-06-2015 10:09 PM
[GUI Plugin] Plugin Updater **Deprecated** kiwidude Plugins 159 06-19-2011 01:27 PM


All times are GMT -4. The time now is 09:48 AM.


MobileRead.com is a privately owned, operated and funded community.