Quote:
Originally Posted by compurandom
I've had that problem for more than a year. I probably renamed a whole bunch of collections at once. Any suggestions how to fix it without manually deleting a couple hundred collections from the device?
It just gets stuck in "Checking for updates".
|
Not really. I believe the issue I had was because some things are case sensitive and some are not. The way calibre manages the collections should match the way it is done through the UI, but, the case sensitivity, or using extended character sets might not match perfectly. I haven't played enough with that side of things for a while. Calibre has been doing a good job of this and it was only when I posted a list of my collections and someone asked why they looked like that, that I decided it was time to make them more consistent.
You can try what @cycojesus did. But, that doesn't completely remove the collections. They will disappear from the device, but, they will probably be synced back to the device later. But, the complete cleanup might fix it as the "bad" collections won't be there.
I would not delete the records, but would mark them for deletion. This would be:
Code:
UPDATE Shelf SET _IsDeleted = 'true', LastModified = CURRENT_TIMESTAMP;
UPDATE ShelfContent SET _IsDeleted = 'true', DateModified = CURRENT_TIMESTAMP;
After that, when you sync, it should delete the collections from the server. And if you have other devices, a sync will remove the collections from them as well. Then you can start fresh.
If you are using calibre for collection management, turn that off until you have done the above. You can connect for other reasons and make sure you get a couple of syncs to the Kobo server to make sure it is working. And if it doesn't work, we'll have to look at what else it could be. This solved the big problem I was having, but, I feel like there may be something else. But, I don't have a pattern yet.