05-20-2012, 12:40 PM | #16 |
E bookworm
Posts: 358
Karma: 2013666
Join Date: Jul 2010
Location: Ontario, Canada
Device: Sony PRS T1,Android Tablet, I phone
|
It seems that almost all of the problems posted here can be traced back to "syncing" problems of one sort or another, the solution is... DON'T SYNC use simple drag-n-drop to load books, use your device to create collections/sort books and access library/stores/dropbox
is your books collection so complicated that you really need "tags" etc ??? THe internal memory can handle 2000+ books ... do you really need an sd card (except for backup)... if you keep it simple it's unlikely you will encounter most of the problems posted here |
05-20-2012, 01:04 PM | #17 | |
Wizard
Posts: 2,888
Karma: 5875940
Join Date: Dec 2007
Device: PRS505, 600, 350, 650, Nexus 7, Note III, iPad 4 etc
|
Quote:
There are many people who have complex collections (not being monomaniac about a certain genre/type to the exclusion of all others) with many differing types of books. As for 2,000 books in IM so why an SD card... well, lots of people don't just regard the eReader as a portable books (or 2 etc) but as a portable library so that they can choose to read whatever attracts their fancy at that moment rather than having to decide in advance, what they are going to have with them... I've got nearly 25K of books, magazines and articles on my eReader and it works fine... for example, I love having a pocket library and it works perfectly... it also means that you can easily move your books from one reader to another with no problems... Last edited by elcreative; 05-20-2012 at 08:42 PM. |
|
Advert | |
|
05-20-2012, 07:00 PM | #18 | |
Connoisseur
Posts: 89
Karma: 485235
Join Date: Aug 2011
Location: Asia
Device: KK 3G, KT 3G, KPW, Odyssey HD, T1, 350, Glo, Mini, Aura HD, KPW2 3G
|
Quote:
|
|
05-25-2012, 09:39 PM | #19 | |
Junior Member
Posts: 2
Karma: 10
Join Date: May 2012
Location: Germany
Device: Sony PRS-T1
|
Quote:
Yes, it is not a perfect solution but a fix that doesn't take too much time or effort. |
|
05-25-2012, 10:56 PM | #20 | |
....
Posts: 1,547
Karma: 18068960
Join Date: May 2012
Device: ....
|
Quote:
So, thanks to Tuttle and for your feedback I may give the SQL query a go - only dithering on that for my part because I assume it is not a one shot solution, adding further books to the card may again corrupt the collections. |
|
Advert | |
|
05-26-2012, 06:02 PM | #21 |
....
Posts: 1,547
Karma: 18068960
Join Date: May 2012
Device: ....
|
Am now also just using the SQL query work around on the card books.db.
|
05-28-2012, 05:57 AM | #22 | |
Member
Posts: 11
Karma: 12584
Join Date: Oct 2011
Device: Sony PRS-T1
|
Quote:
It would theoretically be possible to set up a trigger in the database to automatically clean up the collections table every time a row is added, but that could potentially slow down syncing a lot, depending on exactly how the collection management is implemented. |
|
05-28-2012, 07:50 AM | #23 |
Grand Sorcerer
Posts: 6,171
Karma: 16228536
Join Date: Sep 2009
Location: UK
Device: Kobo: KA1, ClaraHD, Forma, Libra2, Clara2E. PocketBook: TouchHD3
|
If I remember correctly what Kolenka (the calibre/PRST1 guru) said, the problem begins when you first use the SD card. The book ids in the books.db file on the SD card are supposed to be large numbers (10-digit) beginning with 4 and the internal memory book ids are low numbers starting at 0 (or 1???). The problem arises when books on the SD card are erroneously assigned a low number by the T1 and it then gets very confused.
If you can delete all the books on the SD card which have been assigned 'wrong' ids leaving at least one book with a 'correct' id then you should have no further problems as long as you don't delete the SD card books.db file. However, I should say that I don't use an SD card so I haven't tested the above for myself. |
05-30-2012, 05:20 PM | #24 |
Enthusiast
Posts: 49
Karma: 107174
Join Date: Mar 2012
Device: PB631, PB741, PB840
|
A solution to this might be in work, at least a reason has been found.
https://bugs.launchpad.net/bugs/986044 |
06-01-2012, 09:06 PM | #25 | |
....
Posts: 1,547
Karma: 18068960
Join Date: May 2012
Device: ....
|
Quote:
I have not tried to get to the bottom of the issue but for me the couple of times I have looked all the books are numbered correctly in both memories but some collections end up with books in them with correct book ids, correct collection_id, but with some non complying numbers in the content_id field which don't match a real book id. Running the SQL query repairs that, of course, but my experience is that even if one does so or else sets up the card so that all ids on card and memory comply by deleting the books.db on both or reformating both to get a fresh start with complying ids, future adds of books to the card again results in corruption and the "Removing..." lines reappearing. For myself, if I I tire of manually running the SQL query or no better fix appears I may just semi-automate the query with a batch file run from the desktop. |
|
06-01-2012, 09:39 PM | #26 | |
Grand Sorcerer
Posts: 6,171
Karma: 16228536
Join Date: Sep 2009
Location: UK
Device: Kobo: KA1, ClaraHD, Forma, Libra2, Clara2E. PocketBook: TouchHD3
|
Quote:
The good news is that the bug link in the post before yours suggests the problem is actively being worked on and that a solution may be close |
|
06-03-2012, 06:54 AM | #27 |
Enthusiast
Posts: 39
Karma: 9064
Join Date: Jan 2012
Device: Sony PRS-T1, Kobo Aura H20
|
so for a complete noob when it comes to the sql thingy.
how do i run that query? is it just copy the text from the post into the sql program and then update the books db file? i'm sick of reloading my entire library every time i want to add a book thanks Last edited by dillsandwitch; 06-03-2012 at 07:05 AM. Reason: dyslexia :x |
06-03-2012, 08:03 PM | #28 | |
....
Posts: 1,547
Karma: 18068960
Join Date: May 2012
Device: ....
|
Quote:
- With USB cable connection to the T1 open books.db on the card (File>Open Database...) - Copy the SQL query from Tuttle's post and paste it into the top right hand pane - Execute the query (Execute>Execute SQL) That is it done, all "Removing" lines should be removed from collections on the T1. First time around save the query somewhere on your PC for future use (File>Save SQL As...) and next time just open it again (File>Open SQL...) and it will load into the top right pane again ready to be Executed. After running the query, as best as I have seen all the books that have been loaded will remain on the T1 and will also be in their correct collections. So the records removed from books.db seem to be redundant and only serve to confuse the T1. EDIT: I see in the bug reporting from Kolenka's since appeared post it is looking hopeful a fix for implementation in Calibre is close . Last edited by AnotherCat; 06-03-2012 at 09:07 PM. |
|
06-04-2012, 12:32 AM | #29 |
Member
Posts: 16
Karma: 14
Join Date: Apr 2012
Device: Sony PRS-T1
|
Thanks for this info. I got bit by it as well. Just wanted to point out that if you're running Linux you can install sqlite3 from your package manager, mount the SD card from the PRS-T1 or a separate card reader, navigate to the location of books.db in the terminal, execute "sqlite3 books.db", execute
Code:
DELETE FROM collections WHERE content_id NOT IN (select _id FROM books); |
06-04-2012, 07:00 AM | #30 |
Enthusiast
Posts: 39
Karma: 9064
Join Date: Jan 2012
Device: Sony PRS-T1, Kobo Aura H20
|
Thanks AnotherCat I thought that was needed to be done but i didnt wanna screw it up and have to spend 2 hours reloading all my stuff.
does the query need to be done on both the books db, the internal memory or just the sd card one? |
Tags |
sony, sony prs t1 |
Thread Tools | Search this Thread |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Silent Counsel - "Readers will be riveted by this morally complex story." - Booklist | KenIsaacson | Self-Promotions by Authors and Publishers | 18 | 08-31-2013 09:33 AM |
Removing the "Welcome to Kobo" and "Kobo Read On" ePubs | HarleyB | Kobo Reader | 12 | 08-31-2011 09:17 PM |
How to reduce indents without "removing space between paragraphs" | Skydog | Calibre | 5 | 06-05-2010 12:58 AM |