View Single Post
Old 09-03-2013, 04:58 PM   #34
mahal48
Connoisseur
mahal48 has a certain pleonastic somethingmahal48 has a certain pleonastic somethingmahal48 has a certain pleonastic somethingmahal48 has a certain pleonastic somethingmahal48 has a certain pleonastic somethingmahal48 has a certain pleonastic somethingmahal48 has a certain pleonastic somethingmahal48 has a certain pleonastic somethingmahal48 has a certain pleonastic somethingmahal48 has a certain pleonastic somethingmahal48 has a certain pleonastic something
 
Posts: 76
Karma: 18534
Join Date: Jun 2013
Location: U.K.
Device: Kobo Glo, Nexus 7(2013)
Ok here we go, a couple of observations and questions.

In the solution to the duplicate shelves problem, "davidfor" suggested editing the SQLite database on the Kobo. I followed this advice (by changing "_IsDeleted" to "true" for each record in the Shelf table) and was successful in deleting the duplicate shelves on my Glo. At the moment I have no shelves on my Glo and am holding off to putting them on again until Kobo sorts out the synch problem on its' servers.

I have two questions relating to this now and it is all about the database structure and editing entries.

Firtsly, the "Shelf" table still contains data for each record of the duplicate shelves. Why is this when there are no shelves showing on my Glo? Why wasn't the data for each record of the duplicate shelf deleted in the database? Or is this the data that is still being held on the Kobo server?

Secondly, the next table below "Shelf" is "ShelfContent" This holds no records, plus, the column titles are not the same in number, some are missing. I thought there would have been a correlation between the two. So, what is the difference between these two tables and why does the "ShelfContent" contain no data?


Apologies if my database terminology is loose and incorrect. Thanks in advance.
mahal48 is offline   Reply With Quote