Quote:
Originally Posted by davidfor
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