View Single Post
Old 06-08-2018, 07:06 AM   #455
jackie_w
Grand Sorcerer
jackie_w ought to be getting tired of karma fortunes by now.jackie_w ought to be getting tired of karma fortunes by now.jackie_w ought to be getting tired of karma fortunes by now.jackie_w ought to be getting tired of karma fortunes by now.jackie_w ought to be getting tired of karma fortunes by now.jackie_w ought to be getting tired of karma fortunes by now.jackie_w ought to be getting tired of karma fortunes by now.jackie_w ought to be getting tired of karma fortunes by now.jackie_w ought to be getting tired of karma fortunes by now.jackie_w ought to be getting tired of karma fortunes by now.jackie_w ought to be getting tired of karma fortunes by now.
 
Posts: 6,254
Karma: 16544692
Join Date: Sep 2009
Location: UK
Device: ClaraHD, Forma, Libra2, Clara2E, LibraCol, PBTouchHD3
Quote:
Originally Posted by davidfor View Post
You might also need to check the __SyncDate column (think that's the name). Somewhere along the way, the Recent sorting seems to have changed to use the maximum of DateLastRead and __SyncDate rather than only using __SyncDate if the DateLastRead was null. I don't think this will have an affect on what you are seeing, but it is something to check.
In case it gives any insight, here is a screenshot of part of the Kobo database's content table. The only 4 books on the device are the top 4 lines. As you can see the ___SyncTime column has the same value for all 4. Shouldn't that column be in timestamp format???
Attached Thumbnails
Click image for larger version

Name:	kobo_content_table.jpg
Views:	443
Size:	240.1 KB
ID:	164377  
jackie_w is offline   Reply With Quote