Duplicated Shelves

beedaddy · 12-18-2012, 10:34 AM

Hello,

just got the firmware update for my Glo (2.3.1) and noticed this issue:
After using calibre (copyied some books onto the reader, acrivated series support in the kobo module, ...) I realized that some shelves on the Glo have been duplicated. For example, I have two shelves named "Thriller" and in both of them is the same book inside. I'm not able to delete one of the shelves. After removing all of the books inside of them, calibre deletes the shelf. After re-adding the books, most of the shelves are ok, but in one case, a shelf has been duplicated again.

I'm not sure if this has something to do with the new firmware and/or the activated series support of the kobo module, but this is the first time I noticed the problem.

Can someone confirm this? Or have a solution?

Thanks and best regards
beedaddy

PeterT · 12-18-2012, 01:23 PM

Unfortunately it seems to be a Kobo server related issue.

I personally had success with the following approacj.

Attached my Kobo to the PC
Using any tool capable of working on SQLite databases updated the _isdeleted column to true in the Shelf table on all the "old" shelves. I based "old" on the values found in the LastModified column of the same table.

Once these rows had been updated, I did a WiFi sync to Kobo, and then also did a sync (with the Kobo detached) of Kobo Desktop.

Your milage may vary.

Do take backups of the database if you do try this.

DoctorOhh · 12-18-2012, 10:26 PM

You might want to read this thread for info on this problem.

beedaddy · 12-19-2012, 04:02 AM

Thanks to both of you. That helped me much.

brudigia · 12-19-2012, 05:49 AM

Quote:

Originally Posted by beedaddy

Thanks to both of you. That helped me much.

I am the author of the other thread. I have done what has been advised and I can guarantee that if you clean the sqlite tables, you can actually adjust your shelves. And you can safley connect to Calibre.

I can also guarantee that as soon as you reconnect to the desktop app via USB, the mess shall return.

Hopefully they shall soon fix the problem.

Cheers

12-18-2012, 10:34 AM	#1
beedaddy Enthusiast Posts: 33 Karma: 154 Join Date: Oct 2011 Location: Germany Device: Tolino shine	Duplicated Shelves Hello, just got the firmware update for my Glo (2.3.1) and noticed this issue: After using calibre (copyied some books onto the reader, acrivated series support in the kobo module, ...) I realized that some shelves on the Glo have been duplicated. For example, I have two shelves named "Thriller" and in both of them is the same book inside. I'm not able to delete one of the shelves. After removing all of the books inside of them, calibre deletes the shelf. After re-adding the books, most of the shelves are ok, but in one case, a shelf has been duplicated again. I'm not sure if this has something to do with the new firmware and/or the activated series support of the kobo module, but this is the first time I noticed the problem. Can someone confirm this? Or have a solution? Thanks and best regards beedaddy Last edited by beedaddy; 12-19-2012 at 04:04 AM. Reason: typo

12-18-2012, 01:23 PM	#2
PeterT Taking a break; Fed up Posts: 4,438 Karma: 32635230 Join Date: Nov 2007 Location: Toronto Device: Wife: Touch, Arc, Vox Me: Nexus 7, Glo	Unfortunately it seems to be a Kobo server related issue. I personally had success with the following approacj. Attached my Kobo to the PC Using any tool capable of working on SQLite databases updated the _isdeleted column to true in the Shelf table on all the "old" shelves. I based "old" on the values found in the LastModified column of the same table. Once these rows had been updated, I did a WiFi sync to Kobo, and then also did a sync (with the Kobo detached) of Kobo Desktop. Your milage may vary. Do take backups of the database if you do try this. __________________ Peter

12-18-2012, 10:26 PM	#3
DoctorOhh US Navy, Retired Posts: 7,420 Karma: 11289119 Join Date: Feb 2009 Location: North Carolina Device: Nexus 7, Sony PRS-950, Sony PRS-505, PRS-300	You might want to read this thread for info on this problem. __________________ -- Good Reading, Walt -- 20GB of free CLOUD STORAGE: Use this link to sign up for a free 15GB Copy.com cloud storage account and we both get an extra 5GB of free space.

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Implemented, plugin, or so? Duplicated	juliusromo	Calibre	2	12-26-2012 06:51 PM
Duplicated TOC	fe0642	Calibre	1	08-09-2011 07:40 PM
Metadata duplicated in file	TheD0ct0r	Calibre	3	11-30-2010 11:38 PM
Duplicated in Calibre	mdibella	Calibre	7	09-01-2010 09:24 AM
Duplicated Folders	Mick4545	Calibre	2	05-24-2010 12:39 PM

12-19-2012, 04:02 AM	#4
beedaddy Enthusiast Posts: 33 Karma: 154 Join Date: Oct 2011 Location: Germany Device: Tolino shine	Thanks to both of you. That helped me much.


Advertisement Enthusiast