![]() |
#1 |
Connoisseur
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 92
Karma: 1422
Join Date: Apr 2012
Location: Toronto
Device: kobo glo hd
|
Glo HD and Firmware 4.2.8432
I recently updated to new firmware and it has wiped out My Collections. Kobo Customer Care tells me there is no way to fix this issue but to rebuild Collections. Does anyone know of an easier solution?
Thanks |
![]() |
![]() |
![]() |
#2 |
Guru
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 910
Karma: 270670
Join Date: Jun 2016
Device: Kobo
|
|
![]() |
![]() |
Advert | |
|
![]() |
#3 |
Resident Curmudgeon
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 79,441
Karma: 145491800
Join Date: Nov 2006
Location: Roslindale, Massachusetts
Device: Kobo Libra 2, Kobo Aura H2O, PRS-650, PRS-T1, nook STR, PW3
|
If you use Calibre, all of your side loaded eBooks can be easily fixed. I'm not 100% sure this will work, but it might and if not, there's another solution.
The first thing to do is make sure you are set to Automatic Management. That option can be found in Sending books to device in preferences. With this set, I believe that Calibre will keep the collections in sync. If that doesn't work, send all of your side loaded books to your Kobo and that will work. Any books you've downloaded from Kobo you'll have to handle manually. |
![]() |
![]() |
![]() |
#4 |
Groupie
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 188
Karma: 616200
Join Date: May 2014
Location: Spain
Device: Kobo Forma, Hisense A5
|
I've also lost my collections with this firmware update both in my Kobo Aura (original) and Kobo Aura HD, I had the automatic backups of the TouchExtended Calibre plugin and some knowledge of SQL, but anyway I spent some hours yesterday restoring my Collections and their contents, specially with my Kobo Aura HD, which was the first to be restored, it took much more less with the Aura, once I knew the steps to follow. Not happy, I could have spent those hours reading :-(
|
![]() |
![]() |
![]() |
#5 |
Connoisseur
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 92
Karma: 1422
Join Date: Apr 2012
Location: Toronto
Device: kobo glo hd
|
I figured I had nothing to lose so I did another sync and all my collections were back! I had not stopped the original software download and lengthy library sync before it was finished so not sure why this happened. This second sync took a long time and some of the books in my library had to be downloaded again but no big deal.
It seems strange that the service rep did not know of this as a possible solution. Thanks for input everyone. Last edited by ppowell002; 02-20-2017 at 05:47 PM. |
![]() |
![]() |
Advert | |
|
![]() |
#6 |
Grand Sorcerer
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 24,905
Karma: 47303824
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos
|
For the people who are losing the collections, is this for sideloaded or purchased books? Or both? And have you done a sync recently? And did you the post update sync complete? How was the firmware installed? Manually or from the Kobo server?
And if anyone who this has affected wants to send me a copy of the database from the device, I can have a look and see if there is anything that can be done. You will need to put the file somewhere and send me a PM with a link for me to download. Or send me a PM for an email address to send the file to. |
![]() |
![]() |
![]() |
#7 |
Groupie
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 188
Karma: 616200
Join Date: May 2014
Location: Spain
Device: Kobo Forma, Hisense A5
|
Hi @davidfor:
I solved it myself meddling with the database, but I have the backups, I can send them to you if you like. I have both sideloaded and store purchased books, and some collections had only sideloaded books, but others had both type of books. |
![]() |
![]() |
![]() |
#8 |
Grand Sorcerer
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 24,905
Karma: 47303824
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos
|
Just replied to your PM. I'm interested in what fiddling you did and if I can automate it for others.
|
![]() |
![]() |
![]() |
#9 |
Groupie
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 188
Karma: 616200
Join Date: May 2014
Location: Spain
Device: Kobo Forma, Hisense A5
|
It's difficult to replicate it for others, you don't know what changes they have made between databases. Basically the problem was that both tables, the one with the shelves and the one associating books with shelves where empty, so I just took the rows from shelves table from my backup, completed the information with the new columns and inserted them again in the actual database. Then I took the rows from the ShelvesContent table from my backup and inserted them in the table of the actual database, I don't delete books, so I didn't had to check anything more, and I work with databases in my day job, so it wasn't too difficult, I just had to Google how sqllite treats date and boolean columns 😊
|
![]() |
![]() |
![]() |
#10 |
Grand Sorcerer
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 24,905
Karma: 47303824
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos
|
OK, that means it cannot be fixed easily. Anyone with a backup can do it, but otherwise not.
|
![]() |
![]() |
![]() |
#11 |
Wizard
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 1,010
Karma: 500000
Join Date: Jun 2015
Device: Rocketbook, kobo aura h2o, kobo forma, kobo libra color
|
I've been thinking that a more comprehensive database repair tool would be interesting. Perhaps importing specific sets of data from a backup could be one of those repairs.
Do you have any documentation of what you've discovered about the database schema? I've had enough database corruption issues that I could be motivated to work on a tool that would let me fix it (including deleted books) without logging out and back in. |
![]() |
![]() |
![]() |
#12 |
Groupie
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 188
Karma: 616200
Join Date: May 2014
Location: Spain
Device: Kobo Forma, Hisense A5
|
OK, for those interested I'm going to write a small guide on how to get your collections and content back, but beware, this is not a step by step guide on purpose, because there may be to many different circunstances and you'll have to tweak yourself, so if you are going to follow my instructions, you need to be tech savvy enough to google for a solution if you have a problem, you don't need to be a database expert, but you need the patience to look for a solution. And also the patience to understand my English, cause it's not my native language, so some phrasing it's going to be weird
![]() What you need:
Now we are going to proceed:
Regards |
![]() |
![]() |
![]() |
#13 |
Resident Curmudgeon
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 79,441
Karma: 145491800
Join Date: Nov 2006
Location: Roslindale, Massachusetts
Device: Kobo Libra 2, Kobo Aura H2O, PRS-650, PRS-T1, nook STR, PW3
|
if you side load from Calibre and you are set for Automatic Management, then all you need do is plug your Kobo into the computer with Calibre set for your database. All will be fixed automatically. No need to dive into the database.
This won't fix for manually created collections from download eBooks from Kobo, but if it's not that many of them, recreate the collections and manually move the books into the collections. |
![]() |
![]() |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Kobo GLO and FW 4.2.8432 | adrians | Kobo Reader | 16 | 05-30-2017 01:14 AM |
Instructions for patching firmware 4.2.8432 | GeoffR | Kobo Developer's Corner | 53 | 02-28-2017 01:55 AM |
Kobo H2O and Firmware 4.2.8432 | ElWorm | Kobo Reader | 71 | 02-24-2017 04:30 PM |
Aura One Firmware 4.2.8432 | surquizu | Kobo Reader | 83 | 02-21-2017 05:02 AM |
Firmware 4.2.8432 Dictionaries | JSWolf | Kobo Reader | 4 | 02-12-2017 11:47 AM |