[Mister L]

Originally Posted by Quoth

Copy the database file to your PC.
Fix it there. Maybe delete the offending row.
Copy it back overwriting original.

Thanks, I tried doing it locally, but i still got the same error on the second command:

Spoiler:

sqlite> REINDEX sqlite_autoindex_content_1;
Error: stepping, UNIQUE constraint failed: content.ContentID (19)

When I tried opening the database in a GUI editor (SQLite Expert Personal) to delete the row 103877, possibly because I have no idea what I am doing, it made it worse:

Spoiler:

Résultat de l'exécution de la commande 'PRAGMA integrity_check' sur la base de données du dispositif Kobo:


*** in database main ***
On tree page 56787 cell 0: Rowid 103877 out of order
row 81794 missing from index content_bookid_index
row 81794 missing from index sqlite_autoindex_content_1
row 81795 missing from index content_bookid_index
wrong # of entries in index sqlite_autoindex_content_1

So I put back the original version from before I started tinkering with it and I am back to the original 1 error again.

I am not sure what I'm doing wrong, maybe this is too complicated for my (lack of) skill.

Plan B: if I logout/login (effectively deleting the database and creating a new one, if I've understood correctly), is there a way to import from Calibre to the Kobo my annotations, collections, reading positions / dates, and statuses? These are all saved in Calibre using the Kobo Utilities plugin.