|
Yeah, there's a Windows bug with the file_path column.
The driver sets:
Sony_Reader\media\books\Adams, Douglas\Mostly Harmless.epub
The T1 wants:
Sony_Reader/media/books/Adams, Douglas/Mostly Harmless.epub
So the T1 removes the books the driver added (since the path doesn't exist), and then adds its own when scanning the media. That's what is causing books to drop out of collections, and is very likely behind the duplication as well. Since the driver's path doesn't match the database.
I thought the book's "lpath" (local path) would be using *nix path separators, not the OS' path separator. At least that is what the code looked like it did. Looks like I was wrong.
I can piece together a fix for that tonight.
Sony, Sony, Sony... what the heck did you do? I also see a 7 hour discrepancy in the modified time of the files. Looks like when the T1 re-added the books, it set the modified_date to a unix timestamp in local time for the device. The driver sets it to the UTC unix timestamp.
Yet, the added_order column is in the same format, but UTC. Sony get's the facepalm award from me for inconsistent database design.
|