Quote:
Originally Posted by davidfor
As the error is happening while importing the data, it will be because the BookmarkID is already in the table and you are adding a second. The BookmarkID is generated for each entry and looks to be a GUID. Generating the same on two devices would be pretty surprising. It is most likely for a purchased book. These are synced between the devices. In the CSV, the entries for the sideloaded books will have the VolumeID starting with "file:///". If the VolumeID does not start with that, it is for a purchased book. If you delete all the entries in the file that are not for your sideloaded books, then it should remove the potential duplicates.
|
This is my fault, I tried to import data into a table which already contained the same data... I thought it would be replaced. A bit stupid of me. I deleted all the data from the table and then imported it again and then it worked perfectly.
Quote:
Originally Posted by davidfor
Updating the firmware won't affect this error. But, there is a slight chance that it could cause problems with the upgrade. Some firmware upgrades alter the tables by adding columns. It's possible that this could fail because of the error. It would depend on what firmware you are currently running and hence what changes need to be made. As the error is with the content table, it could be a problem if this needs to be changed. I'd probably wait to do the upgrade until you sort everything else out.
|
Thanks I will wait then.
I think now I've got everything figured out that I want to do.
Am I missing any steps?
- verify all books on device are matched to books in Calibre library ; if necessary, match missing books
- eject device so Kobo can update the database
- export tables in csv using SQLiteStudio : Bookmarks, Shelf, ShelfContent, WordList (done)
- backup (manual copy) damaged database just in case (done)
- make a copy of the entire Books partition just in case, VERY IMPORTANT FOR CUSTOM DICTIONARIES, etc. (done)
- add tag in Calibre to all books on device so I know which ones to restore just in case
- on device, logout then login
- (if necessary) send books from Calibre to device
- using the plugin, update the metadata of the books on the device (read dates/status, sent date, collections...)
- import the saved bookmarks, etc. to the table from the csv file using SQLiteStudio
- copy back custom dictionaries, Kobo eReader.conf file (word list), analytics.conf
Thank you again for all your help, I really appreciate it.