View Single Post
Old 06-24-2014, 04:29 PM   #1
arspr
Dead account. Bye
arspr ought to be getting tired of karma fortunes by now.arspr ought to be getting tired of karma fortunes by now.arspr ought to be getting tired of karma fortunes by now.arspr ought to be getting tired of karma fortunes by now.arspr ought to be getting tired of karma fortunes by now.arspr ought to be getting tired of karma fortunes by now.arspr ought to be getting tired of karma fortunes by now.arspr ought to be getting tired of karma fortunes by now.arspr ought to be getting tired of karma fortunes by now.arspr ought to be getting tired of karma fortunes by now.arspr ought to be getting tired of karma fortunes by now.
 
Posts: 587
Karma: 668244
Join Date: Mar 2011
Device: none
Question Help with corrupted database - Manually fix (easy, please)?

Hi, I've just run the Check Database feature from Kobo Utils plugin in Calibre and my results are the next:
Code:
Result of running 'PRAGMA integrity_check' on database on the Kobo device:


rowid 740 missing from index sqlite_autoindex_AnalyticsEvents_1
rowid 1349 missing from index sqlite_autoindex_AnalyticsEvents_1
rowid 2759 missing from index sqlite_autoindex_AnalyticsEvents_1
rowid 4580 missing from index sqlite_autoindex_AnalyticsEvents_1
rowid 4811 missing from index sqlite_autoindex_AnalyticsEvents_1
rowid 6672 missing from index sqlite_autoindex_AnalyticsEvents_1
rowid 7101 missing from index sqlite_autoindex_AnalyticsEvents_1
rowid 8612 missing from index sqlite_autoindex_AnalyticsEvents_1
rowid 8659 missing from index sqlite_autoindex_AnalyticsEvents_1
rowid 8763 missing from index sqlite_autoindex_AnalyticsEvents_1
rowid 8777 missing from index sqlite_autoindex_AnalyticsEvents_1
rowid 10418 missing from index sqlite_autoindex_AnalyticsEvents_1
rowid 11508 missing from index sqlite_autoindex_AnalyticsEvents_1
rowid 11598 missing from index sqlite_autoindex_AnalyticsEvents_1
rowid 13395 missing from index sqlite_autoindex_AnalyticsEvents_1
rowid 16115 missing from index sqlite_autoindex_AnalyticsEvents_1
rowid 16452 missing from index sqlite_autoindex_AnalyticsEvents_1
rowid 16926 missing from index sqlite_autoindex_AnalyticsEvents_1
rowid 19456 missing from index sqlite_autoindex_AnalyticsEvents_1
rowid 20656 missing from index sqlite_autoindex_AnalyticsEvents_1
rowid 20977 missing from index sqlite_autoindex_AnalyticsEvents_1
rowid 22048 missing from index sqlite_autoindex_AnalyticsEvents_1
rowid 23103 missing from index analytics_events_timestamp
rowid 23131 missing from index analytics_events_timestamp
wrong # of entries in index analytics_events_timestamp
wrong # of entries in index sqlite_autoindex_AnalyticsEvents_1
rowid 26847 missing from index volume_shortcovers_shortcoverId
rowid 26848 missing from index volume_shortcovers_shortcoverId
rowid 26849 missing from index volume_shortcovers_shortcoverId
rowid 26850 missing from index volume_shortcovers_shortcoverId
rowid 26851 missing from index volume_shortcovers_shortcoverId
rowid 26875 missing from index volume_shortcovers_shortcoverId
rowid 26877 missing from index volume_shortcovers_shortcoverId
rowid 26879 missing from index volume_shortcovers_shortcoverId
rowid 27643 missing from index volume_shortcovers_shortcoverId
rowid 27643 missing from index sqlite_autoindex_volume_shortcovers_1
rowid 27644 missing from index sqlite_autoindex_volume_shortcovers_1
wrong # of entries in index volume_shortcovers_shortcoverId
wrong # of entries in index sqlite_autoindex_volume_shortcovers_1
I haven't noticed anything strange in my AuraHD behaviour, and of course I don't know how it has been corrupted.

Is it worth resetting the device? Are these errors important or just trivial? Is there a way to fix them without resetting the device?

(I ask this because resetting it is a big PITA: set up kobo account again, set up wifi again, set up the webbrowser favourites again, possibly downgrade from the 3.3.0 FW I'm going to receive that I don't like because of the web-browser impossible use, re-send all the books from Calibre, etcetera, etcetera)

Hints are really welcomed.
arspr is offline   Reply With Quote