View Single Post
Old 03-02-2013, 11:28 AM   #8
tshering
Wizard
tshering ought to be getting tired of karma fortunes by now.tshering ought to be getting tired of karma fortunes by now.tshering ought to be getting tired of karma fortunes by now.tshering ought to be getting tired of karma fortunes by now.tshering ought to be getting tired of karma fortunes by now.tshering ought to be getting tired of karma fortunes by now.tshering ought to be getting tired of karma fortunes by now.tshering ought to be getting tired of karma fortunes by now.tshering ought to be getting tired of karma fortunes by now.tshering ought to be getting tired of karma fortunes by now.tshering ought to be getting tired of karma fortunes by now.
 
Posts: 3,489
Karma: 2914715
Join Date: Jun 2012
Device: kobo touch
Quote:
Originally Posted by DomesticExtremis View Post
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.
tshering is offline   Reply With Quote