firmware 2.4.0 and buy now, or how tshering saved my life

paola · 02-28-2013, 10:08 PM

After the update to 2.4.0 I had an issue with kepub.epub files, in that they had disappeared from the shelves, although I could see them in the book list with the option "buy now". DomesticExtremis had the same problem, and it was suggested to re-load the book.

Problem is, I had a lot of annotations I did not want to lose, and whereas by clicking on the "buy now" icon produced a server error, I noticed that if clicking the book cover the book would open as normal, and would remember where you left off next time you opened it. Only, it would not show on the carousel, the cover would not show when sleeping, and the ominous "buy now" won't go away. Also, I wasn't very wise in making the point in a thread dealing with something else entirely.

It turns out that the problem is in the sqlite database, and it can be fixed! I did try to open and explore the "content" tab of the database, but was pathetic enough with the search that I could not even find the right entries. Anyhow tshering fixed it for me - the problem was with the content.UserID, and I just reloaded the "tsheringfied" database. So thanks tshering

I thought I'd open this in case other people are experiencing the problem (or should the problem arise again with future firmware updates). I am not sure I understood exactly what he did, so I'll leave it to him to explain the details.

davidfor · 03-01-2013, 12:43 AM

That's interesting. Do you know what tshering changed?

tshering · 03-01-2013, 04:08 AM

Previously in case of kepub.epub-s , there was an empty value assigned to "content.___UserID". Since FW 2.4.0 the expected value is "kepub_user".
Edit: this concerns only the main entry (the reference to the whole book), not the references to chapters and so on.

tshering · 03-01-2013, 04:41 AM

Maybe this is related to this case. After updating to FW 2.4.0, five Japanese language epubs (not kepubs) did not go to the carousel (I only tried these five Japanese books, other language epubs worked fine.). After synchronizing, four of them were gone from the datebase and from the device. Only the related xml files in the Adobe Digital Editions folder remained there. Unfortunately, I did not backup the database before synchronizing.

davidfor · 03-01-2013, 05:51 AM

I thought the that was something like that for the user. But, I thought it was there for an earlier firmware. I have lots of backup databases, but none with a kepub.epub in them.

Did you update the epubs? A changed file size will cause them to disappear from the device.

tshering · 03-01-2013, 06:56 AM

Quote:

Originally Posted by davidfor

Did you update the epubs? A changed file size will cause them to disappear from the device.

This is the strange thing, I didn't do anything to those files, except for opening them on the device .

DomesticExtremis · 03-02-2013, 01:21 AM

So other than obtaining a 'tscheringified' database, is
there any way I could fix my 'Buy Now' books other than
reloading them i.e.can anyone provide instructions for
fixing up the db?

tshering · 03-02-2013, 11:28 AM

Quote:

Originally Posted by DomesticExtremis

So other than obtaining a 'tscheringified' database, is
there any way I could fix my 'Buy Now' books other than
reloading them i.e.can anyone provide instructions for
fixing up the db?

You can 'DomesticExtremisify' the database by executing the following command against the database:

Code:

UPDATE content SET ___UserID='kepub_user'
WHERE ContentID LIKE 'file:///mnt/%'
AND ContentID LIKE '%kepub.epub%';

You can use for this for instance the 'Command Line Shell For SQLite' (http://www.sqlite.org/sqlite.html) or the 'SQLite Database Browser' (http://sourceforge.net/projects/sqlitebrowser/). Both are freeware.
If you are not used to it the browser might be more convenient. Do it on your own risk. If you do it, don't forget to make a pack up copy of the database for safety reasons.

DomesticExtremis · 03-02-2013, 03:42 PM

Ta v. much tschering!
It works. I used Sqliteman (on my linux distro)
(for those less familiar with the kobo innards, like me

,
the database is opened at
KoboReader/.kobo/KoboReader.sqlite).

tshering · 03-02-2013, 04:17 PM

DomesticExtremis,

I am glad it worked for you. Thank you for adding the file location. I did not think of it.

02-28-2013, 10:08 PM	#1
paola Wizard Posts: 2,840 Karma: 5843878 Join Date: Oct 2010 Location: UK Device: Pocketbook Pro 903, (beloved Pocketbook 360 RIP), Kobo Mini, Kobo Aura	firmware 2.4.0 and buy now, or how tshering saved my life After the update to 2.4.0 I had an issue with kepub.epub files, in that they had disappeared from the shelves, although I could see them in the book list with the option "buy now". DomesticExtremis had the same problem, and it was suggested to re-load the book. Problem is, I had a lot of annotations I did not want to lose, and whereas by clicking on the "buy now" icon produced a server error, I noticed that if clicking the book cover the book would open as normal, and would remember where you left off next time you opened it. Only, it would not show on the carousel, the cover would not show when sleeping, and the ominous "buy now" won't go away. Also, I wasn't very wise in making the point in a thread dealing with something else entirely. It turns out that the problem is in the sqlite database, and it can be fixed! I did try to open and explore the "content" tab of the database, but was pathetic enough with the search that I could not even find the right entries. Anyhow tshering fixed it for me - the problem was with the content.UserID, and I just reloaded the "tsheringfied" database. So thanks tshering I thought I'd open this in case other people are experiencing the problem (or should the problem arise again with future firmware updates). I am not sure I understood exactly what he did, so I'll leave it to him to explain the details.

03-01-2013, 04:08 AM	#3
tshering Wizard Posts: 3,489 Karma: 2914715 Join Date: Jun 2012 Device: kobo touch	Previously in case of kepub.epub-s , there was an empty value assigned to "content.___UserID". Since FW 2.4.0 the expected value is "kepub_user". Edit: this concerns only the main entry (the reference to the whole book), not the references to chapters and so on. Last edited by tshering; 03-01-2013 at 04:14 AM.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
PRS-T1 Date / Langage never saved anymore / Settings not saved	Bilbotorm	Sony Reader	10	11-16-2012 12:37 PM
Reading Life Stats - What is Saved at Kobo	paulsalter	Kobo Tablets	1	04-26-2012 01:22 PM
IQ Battery life with repack firmware	UrbanNightmare	PocketBook	4	03-14-2011 01:05 PM
battery life and what to buy next	pwalker8	News	6	05-12-2009 01:33 AM
HELP! Battery Life & Firmware	Mindy	Bookeen	9	09-14-2008 06:13 AM

03-01-2013, 12:43 AM	#2
davidfor 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	That's interesting. Do you know what tshering changed?

03-01-2013, 04:41 AM	#4
tshering Wizard Posts: 3,489 Karma: 2914715 Join Date: Jun 2012 Device: kobo touch	Maybe this is related to this case. After updating to FW 2.4.0, five Japanese language epubs (not kepubs) did not go to the carousel (I only tried these five Japanese books, other language epubs worked fine.). After synchronizing, four of them were gone from the datebase and from the device. Only the related xml files in the Adobe Digital Editions folder remained there. Unfortunately, I did not backup the database before synchronizing.

03-01-2013, 05:51 AM	#5
davidfor 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	I thought the that was something like that for the user. But, I thought it was there for an earlier firmware. I have lots of backup databases, but none with a kepub.epub in them. Did you update the epubs? A changed file size will cause them to disappear from the device.

03-02-2013, 01:21 AM	#7
DomesticExtremis Addict Posts: 243 Karma: 359054 Join Date: Nov 2012 Device: default	So other than obtaining a 'tscheringified' database, is there any way I could fix my 'Buy Now' books other than reloading them i.e.can anyone provide instructions for fixing up the db?

03-02-2013, 03:42 PM	#9
DomesticExtremis Addict Posts: 243 Karma: 359054 Join Date: Nov 2012 Device: default	Ta v. much tschering! It works. I used Sqliteman (on my linux distro) (for those less familiar with the kobo innards, like me , the database is opened at KoboReader/.kobo/KoboReader.sqlite).

03-02-2013, 04:17 PM	#10
tshering Wizard Posts: 3,489 Karma: 2914715 Join Date: Jun 2012 Device: kobo touch	DomesticExtremis, I am glad it worked for you. Thank you for adding the file location. I did not think of it.