MobileRead Forums - View Single Post - Libra How to fix a (minor?) database error?

davidfor · 12-01-2021, 09:22 PM

As the database errors are in only indexes, I am surprise the compress did not fix it. What you can do is use a SQLite database management tool to rebuild the indexes. If you run the following, it should fix it:

Code:

REINDEX content_bookid_index;
REINDEX sqlite_autoindex_content_1;

12-01-2021, 09:22 PM	#2
davidfor Grand Sorcerer Posts: 24,905 Karma: 47303824 Join Date: Jul 2011 Location: Sydney, Australia Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos	As the database errors are in only indexes, I am surprise the compress did not fix it. What you can do is use a SQLite database management tool to rebuild the indexes. If you run the following, it should fix it: Code: REINDEX content_bookid_index; REINDEX sqlite_autoindex_content_1;