View Single Post
Old 08-12-2020, 08:05 AM   #1840
Uncle Robin
Diligent dilettante
Uncle Robin ought to be getting tired of karma fortunes by now.Uncle Robin ought to be getting tired of karma fortunes by now.Uncle Robin ought to be getting tired of karma fortunes by now.Uncle Robin ought to be getting tired of karma fortunes by now.Uncle Robin ought to be getting tired of karma fortunes by now.Uncle Robin ought to be getting tired of karma fortunes by now.Uncle Robin ought to be getting tired of karma fortunes by now.Uncle Robin ought to be getting tired of karma fortunes by now.Uncle Robin ought to be getting tired of karma fortunes by now.Uncle Robin ought to be getting tired of karma fortunes by now.Uncle Robin ought to be getting tired of karma fortunes by now.
 
Uncle Robin's Avatar
 
Posts: 3,662
Karma: 52758936
Join Date: Sep 2019
Location: in my mind
Device: Kobo Sage; Kobo Libra Colour
Quote:
Originally Posted by davidfor View Post
I tend to think that index errors like that are the beginning of the end. But, those indexes are on the AnalyticEvents table, so they won't affect much you are interested in. Compressing the database should fix it. That rebuilds the indexes. Make sure you take a backup of the database before hand, just in case.
Thanks. I backed up the database, compressed it, re-ran the check:
----------------------------------------------------
Result of running 'PRAGMA integrity_check' on database on the Kobo device:


wrong # of entries in index analytics_events_timestamp
wrong # of entries in index sqlite_autoindex_AnalyticsEvents_1
Uncle Robin is offline