I've been trying to find a way to fix this issue without having to reset the Kobo entirely. I have no idea what caused the database error; I have only ever used Calibre to load books and haven't had any issues with it before (I use the Kobo program only for updating the device).
When I run an integrity check I get this:
I've tried deleting and recreating the content_bookid_index like I saw suggested on an older thread here, but that doesn't seem to do anything.
I've noticed that this only really seems to be affecting one book at a time (ones that I've added recently - I've got thousands of books and fanfics on the Kobo so I don't know if it's affecting things i Haven't opened in a while), and when I try to open the affected book on the Kobo I get told that it has Adobe DRM on it and I can't open it on the Kobo.
Can anyone think of anything I can do to fix this without a factory reset?
Thanks!
P.S. I really know pretty much nothing about SQL files/editing, I had SQLite Studio and I've downloaded SQL Tools but don't really know how to use it.