View Single Post
Old 05-19-2015, 12:44 AM   #9
Ken Maltby
Wizard
Ken Maltby ought to be getting tired of karma fortunes by now.Ken Maltby ought to be getting tired of karma fortunes by now.Ken Maltby ought to be getting tired of karma fortunes by now.Ken Maltby ought to be getting tired of karma fortunes by now.Ken Maltby ought to be getting tired of karma fortunes by now.Ken Maltby ought to be getting tired of karma fortunes by now.Ken Maltby ought to be getting tired of karma fortunes by now.Ken Maltby ought to be getting tired of karma fortunes by now.Ken Maltby ought to be getting tired of karma fortunes by now.Ken Maltby ought to be getting tired of karma fortunes by now.Ken Maltby ought to be getting tired of karma fortunes by now.
 
Ken Maltby's Avatar
 
Posts: 4,466
Karma: 6900052
Join Date: Dec 2009
Location: The Heart of Texas
Device: Boox Note2, AuraHD, PDA,
Quote:
Originally Posted by davidfor View Post
What columns are you talking about? The user table is:
Code:
CREATE TABLE user(
UserID TEXT NOT NULL,
UserKey TEXT NOT NULL,
UserDisplayName TEXT,
UserEmail TEXT,
___DeviceID TEXT,
FacebookAuthToken TEXT,
HasMadePurchase BIT DEFAULT FALSE, 
IsOneStoreAccount BIT DEFAULT FALSE, 
IsChildAccount BIT DEFAULT FALSE, 
RefreshToken TEXT, 
AuthToken TEXT, 
AuthType TEXT,
PRIMARY KEY (UserID))
I don't see anything there that looks to be related to the firmware version. And I checked a few older versions. No columns have been removed, so, so I can't see what you are referring to.
I said Kobo has added columns, over time with the firmware updates.

My boilerplate on this:

If you just want to read your ebooks and do not want to use any of the sync features then you can use your Kobo device without registering. [This is what I have done all along. My memory may not be the greatest anymore but even I can find my place in a book I am reading on multiple devices. Sync is not of much use if you read a book from a single device.]

1. The tool you need.


3. This should let you use the sqlitebrowser File>Open database function to find the "KoboReader.sqlite" file in the .kobo folder of your device.

4. Tshering's original description of the procedure:

"there are several explanations at this forum. I cannot find them myself right now. Anyway, in order to initialize the reader without registering you can add a new line to the "user" table of the database. Fill in any fitting values. Depending on your reset firmware version, the number of values varies.
Example for FW 1.9.12:

Code:
INSERT INTO user VALUES ("0", "0", "0", "0", "0");

Example for FW 2.5.0:

Code:
INSERT INTO user VALUES ("0", "0", "0", "0", "0", "0","false")

I think you use the SQLite Database Browser. Right? Open the database file "KoboReader.sqlite". Select "Browse Data" and choose the table "user". Look at line 1 and try to establish whether the values of one of the two examples might fit or whether you have to make some modifications. I guess the second example might be correct for the Mini. Choose Execute SQL, enter the command "INSERT INTO user VALUES ..." and press "Execute query".
--------------------------------------------------------------------------------
tshering"

For my user for AuraHD 3.1.1:

INSERT INTO user VALUES ("0", "0", "0", "0", "0", "0","false","false","false")

You can just type the string you need into the "SQL string:" box in the "Execute SQL" tab.
Then click on the "Execute query" button.

5. After you have a zeroed out user and have saved the file, just restart your device and you should be good to go.

Luck;
Ken

Last edited by Ken Maltby; 05-19-2015 at 12:52 AM.
Ken Maltby is offline   Reply With Quote