View Single Post
Old 12-22-2021, 08:04 AM   #2640
compurandom
Wizard
compurandom ought to be getting tired of karma fortunes by now.compurandom ought to be getting tired of karma fortunes by now.compurandom ought to be getting tired of karma fortunes by now.compurandom ought to be getting tired of karma fortunes by now.compurandom ought to be getting tired of karma fortunes by now.compurandom ought to be getting tired of karma fortunes by now.compurandom ought to be getting tired of karma fortunes by now.compurandom ought to be getting tired of karma fortunes by now.compurandom ought to be getting tired of karma fortunes by now.compurandom ought to be getting tired of karma fortunes by now.compurandom ought to be getting tired of karma fortunes by now.
 
Posts: 1,017
Karma: 500000
Join Date: Jun 2015
Device: Rocketbook, kobo aura h2o, kobo forma, kobo libra color
I'm still having problems with my kobo refusing to sync.
I think when calibre side loads news articles to the kobo, subsequent attempts to sync shelf info for those books fails. (At least, I think it is news articles.)

I've found running the following sqlite3 queries before ejecting fixes and/or prevents the issue.

Code:
update shelf set _issynced='true' where _issynced='false';
update ShelfContent set _issynced='true' where _issynced='false';
I don't create new shelves that often, so typically the first line doesn't do anything.

Would it be possible to add an option to this plugin to do something similar so that side loaded books have _issynced set to true when they are newly added?

Maybe a filter so that only certain shelves are marked to sync? (I do add kobo and overdrive books to specific shelves that it would be OK to sync, but probably fine if they are not synced, so I don't care either way on that.)

Since I've been doing this by hand, my sync issues have gone away, at least until I forget and have to reconnect to do it.

Let me know if you'd like me to experiment with this and have suggestions on how to narrow down the problem's exact trigger.

Note also, since this fixes sync, my kobo isn't getting stuck in a sync loop anymore and battery life is better!
compurandom is offline   Reply With Quote