Quote:
Originally Posted by swamp thing
If it is something stored in the database, could one remove it manually? (I don't mind changing the database with an sql tool, I'd like to try that before anything more drastic).
I could not find anything in the database that matches the file name or title, but it's probably in there as a long GUID type string.
|
I haven't looked at the Adobe DRM much, but I had a look today. The tables to look at:
- content - This is the main table that contains details of the books. There should be one row for the book and one row for each chapter. The key is "ContentID".
- volume_shortcovers - One row per chapter in the book. The key is "volumeID".
For what you want, ContentID and volumeID are the same. For sideloaded books they are full path to the book as seen by the device when it is running. ADE puts the books into the "Digital Editions" directory. So, these will look like "file:///mnt/onboard/Digital Editions/Redshirts_0001.epub". The chapter rows in content will start with this. There are other tables with details, but they won't affect this. Deleting these rows should be enough to remove the book from the device library.
The other place to look is in the "Digital Editions" directory. As well as the book, there are some other places that might have something relevant. The subdirectories contain files such as the annotations that shouldn't interfere. "manifest.xml" contains details of he book. Maybe it has a leftover from when the book was originally sent to the device.
The thing I would try is:
- Make sure the rows are removed from the two database tables.
- Remove the book file.
- Edit manifest.xml to make sure it has nothing about the book.
- Remove the traces of the book from the "Digital Editions" directory.
- Restart the device to make sure nothing is cached.
- Connect to the PC and use ADE to send the book again.