Register Guidelines E-Books Search Today's Posts Mark Forums Read

Go Back   MobileRead Forums > E-Book Readers > Amazon Kindle > Kindle Developer's Corner

Notices

Reply
 
Thread Tools Search this Thread
Old 09-10-2013, 02:35 PM   #1
SampleAndy
Addict
SampleAndy ought to be getting tired of karma fortunes by now.SampleAndy ought to be getting tired of karma fortunes by now.SampleAndy ought to be getting tired of karma fortunes by now.SampleAndy ought to be getting tired of karma fortunes by now.SampleAndy ought to be getting tired of karma fortunes by now.SampleAndy ought to be getting tired of karma fortunes by now.SampleAndy ought to be getting tired of karma fortunes by now.SampleAndy ought to be getting tired of karma fortunes by now.SampleAndy ought to be getting tired of karma fortunes by now.SampleAndy ought to be getting tired of karma fortunes by now.SampleAndy ought to be getting tired of karma fortunes by now.
 
SampleAndy's Avatar
 
Posts: 248
Karma: 644344
Join Date: Oct 2012
Location: Pittsburgh, PA, USA
Device: KPW, KFire HD, KFire, KTD 3g, KT, K4B, K4S, K3g, K3g SO, K2, K1
Lightbulb "kindle (collection) doesn't display some books - Possible cause/fix?"

I've got a kind of weird problem with my Paperwhite. I have a collection which I'm trying to use for the Tempe Brennan books and my series document. The weird thing is that two of the seven books that are counted as being in the collection don't show up in the collection. If I create a new collection and add the seven books, they all show up, and all seven books show up in the root.

The simplest solution is to just delete the old collection and rename the new one, but this has happened before. When you have a large number of books in a collection, it's a little more difficult to even realize you have a problem.

Does anybody have any idea what might be going on? I'm running Firmware 5.3.3 and I've tried using ixtab's Collection Manager. I only mention that because I've had some problems in the past where I'd hidden books in the root and could only find them in the collections. To the best of my limited knowledge, you can't hide books except through some addon.

Thanks

Last edited by twobob; 09-17-2013 at 08:26 AM.
SampleAndy is offline   Reply With Quote
Old 09-10-2013, 02:41 PM   #2
NiLuJe
BLAM!
NiLuJe ought to be getting tired of karma fortunes by now.NiLuJe ought to be getting tired of karma fortunes by now.NiLuJe ought to be getting tired of karma fortunes by now.NiLuJe ought to be getting tired of karma fortunes by now.NiLuJe ought to be getting tired of karma fortunes by now.NiLuJe ought to be getting tired of karma fortunes by now.NiLuJe ought to be getting tired of karma fortunes by now.NiLuJe ought to be getting tired of karma fortunes by now.NiLuJe ought to be getting tired of karma fortunes by now.NiLuJe ought to be getting tired of karma fortunes by now.NiLuJe ought to be getting tired of karma fortunes by now.
 
NiLuJe's Avatar
 
Posts: 5,241
Karma: 5164853
Join Date: Jun 2010
Location: Paris, France
Device: Kindle 2i, 3g, 4, 5w, PW & PW2; Kobo H2O
Quote:
Originally Posted by SampleAndy View Post
The weird thing is that two of the seven books that are counted as being in the collection don't show up in the collection.
Counted how/where?

Quote:
Originally Posted by SampleAndy View Post
If I create a new collection and add the seven books, they all show up, and all seven books show up in the root.
How? From the Kindle UI or CM?


How was the original 'broken' collection built?

Last edited by NiLuJe; 09-10-2013 at 05:49 PM.
NiLuJe is online now   Reply With Quote
 
Advertisement
Old 09-10-2013, 04:02 PM   #3
SampleAndy
Addict
SampleAndy ought to be getting tired of karma fortunes by now.SampleAndy ought to be getting tired of karma fortunes by now.SampleAndy ought to be getting tired of karma fortunes by now.SampleAndy ought to be getting tired of karma fortunes by now.SampleAndy ought to be getting tired of karma fortunes by now.SampleAndy ought to be getting tired of karma fortunes by now.SampleAndy ought to be getting tired of karma fortunes by now.SampleAndy ought to be getting tired of karma fortunes by now.SampleAndy ought to be getting tired of karma fortunes by now.SampleAndy ought to be getting tired of karma fortunes by now.SampleAndy ought to be getting tired of karma fortunes by now.
 
SampleAndy's Avatar
 
Posts: 248
Karma: 644344
Join Date: Oct 2012
Location: Pittsburgh, PA, USA
Device: KPW, KFire HD, KFire, KTD 3g, KT, K4B, K4S, K3g, K3g SO, K2, K1
Thanks for checking in, NiLuJe.
Counted as in the number following the collection name, in both the original interface and the Collections Manager (also counted as in counting the titles within the collection.)

I created the new collection in the original interface. The original one? Sorry, I have no idea.

Something I just found out when I was checking in CM... although both collections show seven books, the two problem books only show up as being in one collection. Doing a long click in CM on the problem books show that they only exist in the NEW collection, that I created today. Last night, I deleted all the books from the 'broken' collection and re-added them, so...

Aside from the checking I have just done now, almost everything has been done from the original interface. Deleted the original five books, added them back with an additional two, created the new collection and added seven books.

Last edited by SampleAndy; 09-10-2013 at 04:03 PM. Reason: added detail as far as where the books were counted.
SampleAndy is offline   Reply With Quote
Old 09-10-2013, 06:00 PM   #4
NiLuJe
BLAM!
NiLuJe ought to be getting tired of karma fortunes by now.NiLuJe ought to be getting tired of karma fortunes by now.NiLuJe ought to be getting tired of karma fortunes by now.NiLuJe ought to be getting tired of karma fortunes by now.NiLuJe ought to be getting tired of karma fortunes by now.NiLuJe ought to be getting tired of karma fortunes by now.NiLuJe ought to be getting tired of karma fortunes by now.NiLuJe ought to be getting tired of karma fortunes by now.NiLuJe ought to be getting tired of karma fortunes by now.NiLuJe ought to be getting tired of karma fortunes by now.NiLuJe ought to be getting tired of karma fortunes by now.
 
NiLuJe's Avatar
 
Posts: 5,241
Karma: 5164853
Join Date: Jun 2010
Location: Paris, France
Device: Kindle 2i, 3g, 4, 5w, PW & PW2; Kobo H2O
@SampleAndy: How do you manage your books?

Meaning where do they come from:
* do you download them from the KS/Archive straight from the device?
* do you sideload them manually (is so, where do they come from, and do you manage the metadata of those somehow?
* do you use Calibre?

[Because if the internal ASIN changed in the metadata, then, yeah, the collection would have lost track of the book. And/or possibly even if the file was renamed/moved somehow, not sure how well the Kindle Catalog/Collection handles that...]
NiLuJe is online now   Reply With Quote
Old 09-10-2013, 07:06 PM   #5
SampleAndy
Addict
SampleAndy ought to be getting tired of karma fortunes by now.SampleAndy ought to be getting tired of karma fortunes by now.SampleAndy ought to be getting tired of karma fortunes by now.SampleAndy ought to be getting tired of karma fortunes by now.SampleAndy ought to be getting tired of karma fortunes by now.SampleAndy ought to be getting tired of karma fortunes by now.SampleAndy ought to be getting tired of karma fortunes by now.SampleAndy ought to be getting tired of karma fortunes by now.SampleAndy ought to be getting tired of karma fortunes by now.SampleAndy ought to be getting tired of karma fortunes by now.SampleAndy ought to be getting tired of karma fortunes by now.
 
SampleAndy's Avatar
 
Posts: 248
Karma: 644344
Join Date: Oct 2012
Location: Pittsburgh, PA, USA
Device: KPW, KFire HD, KFire, KTD 3g, KT, K4B, K4S, K3g, K3g SO, K2, K1
Amazon books are downloaded to Kindle for PC, then imported into Calibre, all others downloaded into a folder with others of that source, (feedbooks, Baen, Gutenberg) and then imported into other libraries in Calibre.

When would the ASIN change? The only thing I remember doing was changing the covers and pushing the books out to the Kindle again. Even so, I'm almost positive that I deleted all the books from the collection and added them again. I would have thought that it would be the next best thing to creating a new collection... I'll try it one more time.

OK... I just deleted all the books from the collection and added them again. No difference. I deleted the problem books from the device (without removing them from the collection) and then reimported them from Calibre. Both collections now show all the books. The immediate symptom is solved, but the problem remains unidentified.

Last edited by SampleAndy; 09-10-2013 at 08:20 PM. Reason: added last paragraph
SampleAndy is offline   Reply With Quote
Old 09-10-2013, 08:26 PM   #6
NiLuJe
BLAM!
NiLuJe ought to be getting tired of karma fortunes by now.NiLuJe ought to be getting tired of karma fortunes by now.NiLuJe ought to be getting tired of karma fortunes by now.NiLuJe ought to be getting tired of karma fortunes by now.NiLuJe ought to be getting tired of karma fortunes by now.NiLuJe ought to be getting tired of karma fortunes by now.NiLuJe ought to be getting tired of karma fortunes by now.NiLuJe ought to be getting tired of karma fortunes by now.NiLuJe ought to be getting tired of karma fortunes by now.NiLuJe ought to be getting tired of karma fortunes by now.NiLuJe ought to be getting tired of karma fortunes by now.
 
NiLuJe's Avatar
 
Posts: 5,241
Karma: 5164853
Join Date: Jun 2010
Location: Paris, France
Device: Kindle 2i, 3g, 4, 5w, PW & PW2; Kobo H2O
@SampleAndy: Hmm. The only thing that comes to mind is the Kindle being very finicky about files being modified from under its feet, so, if you ever do update a book for whatever reason, try deleting it *from the device itself* first.
NiLuJe is online now   Reply With Quote
Old 09-11-2013, 04:01 AM   #7
ixtab
(offline)
ixtab ought to be getting tired of karma fortunes by now.ixtab ought to be getting tired of karma fortunes by now.ixtab ought to be getting tired of karma fortunes by now.ixtab ought to be getting tired of karma fortunes by now.ixtab ought to be getting tired of karma fortunes by now.ixtab ought to be getting tired of karma fortunes by now.ixtab ought to be getting tired of karma fortunes by now.ixtab ought to be getting tired of karma fortunes by now.ixtab ought to be getting tired of karma fortunes by now.ixtab ought to be getting tired of karma fortunes by now.ixtab ought to be getting tired of karma fortunes by now.
 
ixtab's Avatar
 
Posts: 2,903
Karma: 6677559
Join Date: Dec 2011
Device: K3, K4, K5, KPW, KPW2
^What NiLuJe said. It's quite likely that the file ended up getting a new identifier when you modified it. And because the experts at lab126 seem to never have heard about database normalization or referential integrity, it seems quite likely that you ended up with an inconsistent collections database after overwriting the file.

Could you either post here, or -- probably preferrable for privacy reasons -- send me via PM, your collections database (/var/local/cc.db) ? I'd like to take a look at it and see what kind of inconsistencies there are.

Alternatively, you can also do that yourself - the file is a plain SQLite database. The format isn't too hard to understand.

Your best bet to (hopefully) fix this is to export the collections to calibre via CM, then manually delete the /var/local/cc.db, restart the device, import from calibre via CM. And in the future, to prevent this from happening again: make any needed adjustments to files before you start filing them into collections.
ixtab is offline   Reply With Quote
Old 09-11-2013, 01:03 PM   #8
SampleAndy
Addict
SampleAndy ought to be getting tired of karma fortunes by now.SampleAndy ought to be getting tired of karma fortunes by now.SampleAndy ought to be getting tired of karma fortunes by now.SampleAndy ought to be getting tired of karma fortunes by now.SampleAndy ought to be getting tired of karma fortunes by now.SampleAndy ought to be getting tired of karma fortunes by now.SampleAndy ought to be getting tired of karma fortunes by now.SampleAndy ought to be getting tired of karma fortunes by now.SampleAndy ought to be getting tired of karma fortunes by now.SampleAndy ought to be getting tired of karma fortunes by now.SampleAndy ought to be getting tired of karma fortunes by now.
 
SampleAndy's Avatar
 
Posts: 248
Karma: 644344
Join Date: Oct 2012
Location: Pittsburgh, PA, USA
Device: KPW, KFire HD, KFire, KTD 3g, KT, K4B, K4S, K3g, K3g SO, K2, K1
Quote:
Originally Posted by ixtab View Post
...

Your best bet to (hopefully) fix this is to export the collections to calibre via CM, then manually delete the /var/local/cc.db, restart the device, import from calibre via CM. And in the future, to prevent this from happening again: make any needed adjustments to files before you start filing them into collections.
I'd been having some weird problems all along. At one point not too long ago, I gave up and used the feature in CM to [Delete all collections]. I then used [Create collections from directories] and started from there.

If I understand correctly, (meaning guess) these processes just delete all the records from the database and create new ones, but if the database is corrupted, it would still BE corrupted. The only real solution would be to actually delete the database and start from scratch. If I delete the database, will the Kindle automatically create an empty one or do I need to do something else?

Thanks for your help, as always,
Andy
SampleAndy is offline   Reply With Quote
Old 09-11-2013, 01:24 PM   #9
ixtab
(offline)
ixtab ought to be getting tired of karma fortunes by now.ixtab ought to be getting tired of karma fortunes by now.ixtab ought to be getting tired of karma fortunes by now.ixtab ought to be getting tired of karma fortunes by now.ixtab ought to be getting tired of karma fortunes by now.ixtab ought to be getting tired of karma fortunes by now.ixtab ought to be getting tired of karma fortunes by now.ixtab ought to be getting tired of karma fortunes by now.ixtab ought to be getting tired of karma fortunes by now.ixtab ought to be getting tired of karma fortunes by now.ixtab ought to be getting tired of karma fortunes by now.
 
ixtab's Avatar
 
Posts: 2,903
Karma: 6677559
Join Date: Dec 2011
Device: K3, K4, K5, KPW, KPW2
Quote:
Originally Posted by SampleAndy View Post
I'd been having some weird problems all along. At one point not too long ago, I gave up and used the feature in CM to [Delete all collections]. I then used [Create collections from directories] and started from there.

If I understand correctly, (meaning guess) these processes just delete all the records from the database and create new ones, but if the database is corrupted, it would still BE corrupted.
Almost

The "delete all collections" will delete all collections from the database. But it won't delete any "zombie" book entries from it - which is what seems to cause your problem. But I can't tell for sure unless I can take a look at the actual database. So yes, even if you delete all collections, your DB might still contain junk entries. But it's worth giving it a try. In the worst case, you can still delete the entire database afterwards.

Quote:
The only real solution would be to actually delete the database and start from scratch. If I delete the database, will the Kindle automatically create an empty one or do I need to do something else?
Yes, it will re-create it when the framework is restarted. Actually, the database contains information about both books and collections (and the special items, like "archive", too). So it will re-create the DB and populate it only with the books & stuff, but no collections.
ixtab is offline   Reply With Quote
Old 09-11-2013, 01:49 PM   #10
SampleAndy
Addict
SampleAndy ought to be getting tired of karma fortunes by now.SampleAndy ought to be getting tired of karma fortunes by now.SampleAndy ought to be getting tired of karma fortunes by now.SampleAndy ought to be getting tired of karma fortunes by now.SampleAndy ought to be getting tired of karma fortunes by now.SampleAndy ought to be getting tired of karma fortunes by now.SampleAndy ought to be getting tired of karma fortunes by now.SampleAndy ought to be getting tired of karma fortunes by now.SampleAndy ought to be getting tired of karma fortunes by now.SampleAndy ought to be getting tired of karma fortunes by now.SampleAndy ought to be getting tired of karma fortunes by now.
 
SampleAndy's Avatar
 
Posts: 248
Karma: 644344
Join Date: Oct 2012
Location: Pittsburgh, PA, USA
Device: KPW, KFire HD, KFire, KTD 3g, KT, K4B, K4S, K3g, K3g SO, K2, K1
Quote:
Originally Posted by ixtab View Post
...

Could you either post here, or -- probably preferrable for privacy reasons -- send me via PM, your collections database (/var/local/cc.db) ? I'd like to take a look at it and see what kind of inconsistencies there are

....
ixtab has chosen not to receive private messages or may not be allowed to receive private messages. Therefore you may not send your message to him/her.

hmmm...
SampleAndy is offline   Reply With Quote
Old 09-11-2013, 01:51 PM   #11
ixtab
(offline)
ixtab ought to be getting tired of karma fortunes by now.ixtab ought to be getting tired of karma fortunes by now.ixtab ought to be getting tired of karma fortunes by now.ixtab ought to be getting tired of karma fortunes by now.ixtab ought to be getting tired of karma fortunes by now.ixtab ought to be getting tired of karma fortunes by now.ixtab ought to be getting tired of karma fortunes by now.ixtab ought to be getting tired of karma fortunes by now.ixtab ought to be getting tired of karma fortunes by now.ixtab ought to be getting tired of karma fortunes by now.ixtab ought to be getting tired of karma fortunes by now.
 
ixtab's Avatar
 
Posts: 2,903
Karma: 6677559
Join Date: Dec 2011
Device: K3, K4, K5, KPW, KPW2
Quote:
Originally Posted by SampleAndy View Post
ixtab has chosen not to receive private messages or may not be allowed to receive private messages. Therefore you may not send your message to him/her.

hmmm...
Try again now
ixtab is offline   Reply With Quote
Old 09-15-2013, 12:13 AM   #12
SampleAndy
Addict
SampleAndy ought to be getting tired of karma fortunes by now.SampleAndy ought to be getting tired of karma fortunes by now.SampleAndy ought to be getting tired of karma fortunes by now.SampleAndy ought to be getting tired of karma fortunes by now.SampleAndy ought to be getting tired of karma fortunes by now.SampleAndy ought to be getting tired of karma fortunes by now.SampleAndy ought to be getting tired of karma fortunes by now.SampleAndy ought to be getting tired of karma fortunes by now.SampleAndy ought to be getting tired of karma fortunes by now.SampleAndy ought to be getting tired of karma fortunes by now.SampleAndy ought to be getting tired of karma fortunes by now.
 
SampleAndy's Avatar
 
Posts: 248
Karma: 644344
Join Date: Oct 2012
Location: Pittsburgh, PA, USA
Device: KPW, KFire HD, KFire, KTD 3g, KT, K4B, K4S, K3g, K3g SO, K2, K1
Quote:
Originally Posted by NiLuJe View Post
... if you ever do update a book for whatever reason, try deleting it *from the device itself* first.
Thanks to ixtab for checking the database and giving his seal of approval... within limits.

NiLuJe, when you say *from the device itself* do you mean through the device interface, or do you mean just deleting the book from the device whether via the Kindle interface, calibre, Windows Explorer or some other method? When I read the post the first time, I thought it meant delete the book instead of just overwriting it with a new copy, but now I'm starting to wonder.

Thanks again to all!
SampleAndy is offline   Reply With Quote
Old 09-15-2013, 07:33 AM   #13
NiLuJe
BLAM!
NiLuJe ought to be getting tired of karma fortunes by now.NiLuJe ought to be getting tired of karma fortunes by now.NiLuJe ought to be getting tired of karma fortunes by now.NiLuJe ought to be getting tired of karma fortunes by now.NiLuJe ought to be getting tired of karma fortunes by now.NiLuJe ought to be getting tired of karma fortunes by now.NiLuJe ought to be getting tired of karma fortunes by now.NiLuJe ought to be getting tired of karma fortunes by now.NiLuJe ought to be getting tired of karma fortunes by now.NiLuJe ought to be getting tired of karma fortunes by now.NiLuJe ought to be getting tired of karma fortunes by now.
 
NiLuJe's Avatar
 
Posts: 5,241
Karma: 5164853
Join Date: Jun 2010
Location: Paris, France
Device: Kindle 2i, 3g, 4, 5w, PW & PW2; Kobo H2O
I meant from the Kindle's UI
NiLuJe is online now   Reply With Quote
Old 09-17-2013, 07:01 AM   #14
Aeris
Developer's Corner Mascot
Aeris ought to be getting tired of karma fortunes by now.Aeris ought to be getting tired of karma fortunes by now.Aeris ought to be getting tired of karma fortunes by now.Aeris ought to be getting tired of karma fortunes by now.Aeris ought to be getting tired of karma fortunes by now.Aeris ought to be getting tired of karma fortunes by now.Aeris ought to be getting tired of karma fortunes by now.Aeris ought to be getting tired of karma fortunes by now.Aeris ought to be getting tired of karma fortunes by now.Aeris ought to be getting tired of karma fortunes by now.Aeris ought to be getting tired of karma fortunes by now.
 
Aeris's Avatar
 
Posts: 484
Karma: 1277790
Join Date: Sep 2013
Device: Kindle Paperwhite 5.3.4, Kindle Keyboard 3.4
OMG guys, I don't know how to thank you!

I had exatly the same inconsistency problem, and not only for books in collection... 6 books of 359 weren't showing up anywhere! I was going mad.

Then I've deleted the /var/local/cc.db through kindleExplorer app and now it's everything ok! I just have to make collections anew...

I'll try in the future to delete the book from the device before editing them in any way, as you suggest.

Maybe the topic could be renamed in "kindle doens't display some books" or anything helpful to be found easily from other users, it's quite critical!

Last edited by Aeris; 09-17-2013 at 07:44 AM.
Aeris is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Troubleshooting Hidden/missing books on Kindle Paperwhite EvanRules Amazon Kindle 0 06-29-2013 05:47 AM
Navigating the E-Books Collection Taylor514ce Feedback 8 05-20-2008 09:20 PM


All times are GMT -4. The time now is 04:39 PM.


MobileRead.com is a privately owned, operated and funded community.