- #SQLITESTUDIO CHECK CONSTRAINT FAILED UPDATE#
- #SQLITESTUDIO CHECK CONSTRAINT FAILED PLUS#
- #SQLITESTUDIO CHECK CONSTRAINT FAILED SERIES#
Row 81742 missing from index sqlite_autoindex_content_1 Row 81742 missing from index content_bookid_index You should be able to find the book by running the SQL statement: Removing the book that is causing the problem might fix it.
#SQLITESTUDIO CHECK CONSTRAINT FAILED PLUS#
There is one row for every book plus rows for each ToC entry in the books (with some complications). The content table contains the details of all the books on the device.
The unique constraint error is because there are two rows in the "content" table with the same value in the "ContentID" column. I think the main issue is the error in "sqlite_autoindex_content_1". I am not sure what I'm doing wrong, maybe this is too complicated for my (lack of) skill. So I put back the original version from before I started tinkering with it and I am back to the original 1 error again. Row 81795 missing from index content_bookid_index Row 81794 missing from index sqlite_autoindex_content_1 Row 81794 missing from index content_bookid_index I haven't had this Kobo for very long and am unfamiliar with the various tricks and secrets of using it.
Thanks in advance for any help you can give me. If I cannot fix the database, I think I have to logout/login to recreate a new database (thus losing all my activity data): can I reimport the annotations, datestamps, reading positions / status (new, currently reading.) of the books on the device? I have added columns in Calibre for all the options available in the plugin and exported all of this information so at least in theory it is available. What could have caused this error (how to avoid it in future)? I always safely eject the device before unplugging the usb.Ģ. Can I fix the error(s) in the database somehow? (How?)ġa. I would really like to avoid losing my notes, reading position, and datestamps of loaded / read because that is my preferred sort order, so I have not logged out.ġ. Résultat de l'exécution de la commande 'PRAGMA integrity_check' sur la base de données du dispositif Kobo: But in the meantime I have read quite a lot, made lots of annotations, and added several books which means at this point the last backup is quite out of date. The first time it happened I was in a hurry and everything but the backup seemed to work fine so I crossed my fingers it would resolve itself. And I would prefer to have an up-to-date backup.
#SQLITESTUDIO CHECK CONSTRAINT FAILED SERIES#
But series information does not seem to be written.
#SQLITESTUDIO CHECK CONSTRAINT FAILED UPDATE#
I am still able to load books to the device and Calibre can read all the books already on it, and the plugin appears to continue to update the reading positions, which is why I think it must be a relatively minor error.
Wrong # of entries in index sqlite_autoindex_content_1įile "calibre\gui2\device.py", line 89, in runįile "calibre_", line 200, in do_device_database_backup Wrong # of entries in index content_bookid_index On tree page 56787 cell 0: Rowid 103877 out of order Calibre, version 5.24.0 (win32, embedded-python: True)Įchec à la sauvegarde de la base de données du dispositif: Échoué: Sauvegarde de la base de données du dispositif Kobo en cours
0 kommentar(er)
