Quote:
Originally Posted by haram
I just tried this on a new kobo touch, after unplugging usb it comes back saying that i need to set up, so it doesn't work.
Maybe the device field have to match the device.
|
You need to look at the number and type of data fields there are in the "user" record. Then you replace the fields with fake data of that type. AlphaNumeric fields can be replaced with zeros (0), true/false are best replaced with false, url can be replaced with zero, as well. The quotation marks are required, in the INSERT INTO line.
This includes Tshering's old post:
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")
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