MobileRead Forums - View Single Post - Glo Memory Upgrade Mod Guide (With Pictures)

Ken Maltby · 11-29-2014, 09:27 AM

You can do a factory update without having to authenticate with the Kobo server, but you would not be able use the sync features, no loss if you do not have several Kobo ereaders and do not read the same book on all of them, at the same time - And - cannot remember your place in the book you are reading.

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.

2. I agree with David that you should do a "factory reset" before this kind of change in firmware.

3. After the reset it will ask if you want to register using WiFi or your computer - connect your USB cable and select computer. 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 paste the above string 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

Also an old post: Accessible Internal uSD card or this mod

11-29-2014, 09:27 AM	#152
Ken Maltby Wizard Posts: 4,466 Karma: 6900052 Join Date: Dec 2009 Location: The Heart of Texas Device: Boox Note2, AuraHD, PDA,	You can do a factory update without having to authenticate with the Kobo server, but you would not be able use the sync features, no loss if you do not have several Kobo ereaders and do not read the same book on all of them, at the same time - And - cannot remember your place in the book you are reading. 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. 2. I agree with David that you should do a "factory reset" before this kind of change in firmware. 3. After the reset it will ask if you want to register using WiFi or your computer - connect your USB cable and select computer. 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 paste the above string 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 Also an old post: Accessible Internal uSD card or this mod Last edited by Ken Maltby; 11-29-2014 at 09:36 AM.