01-29-2017, 06:53 AM | #76 | ||
Enthusiast
Posts: 48
Karma: 854254
Join Date: Nov 2016
Device: none
|
Quote:
Yes do know is the original fields, the thing is that I did the inserting by trial and error so I pasted the original table for help. I am not a sqlite haxxor, I only copy paste :/ Quote:
danke for your concerns |
||
01-29-2017, 11:05 AM | #77 |
Grand Sorcerer
Posts: 12,119
Karma: 73448614
Join Date: Nov 2007
Location: Toronto
Device: Nexus 7, Clara, Touch, Tolino EPOS
|
I wonder if it would be more release independent to use the other form of the INSERT statement, ie
INSERT INTO "user" (<list of columns>) VALUES(<list of values>) This has the benefit of being independent of schema changes. Sent from my Nexus 7 using Tapatalk |
Advert | |
|
09-15-2017, 03:17 PM | #78 |
Junior Member
Posts: 4
Karma: 10
Join Date: Sep 2017
Device: Kobo Glod HD
|
As the number of columns and their names may change over time as probably noted in this thread, it is a bit of a pain to do the registration "hack" to fill them all out.
While looking to do this from my Linux machine I installed `sqliteman` as its description offered a GUI for administrating and developing for SQLite databases. EDIT: Use method outlined further down One of the features I hadn't counted on was being able to right click on the "users" table and choose "populate" from the list and having the tool automatically craft a query to insert data to fill all the columns. I didn't have to modify anything and could just click "Insert" and after ejecting and unplugging (I chose register with desktop to start), it complained about the data format, but bypassed the registration screen and put me at the "Home" screen. I may play around with it a bit and see if not choosing "autonumber" for the user column avoids the error, but this is probably the easiest way to describe to a non-technical user without creating a data map that might get outdated with every update. EDIT: Upon further testing having random data in all the fields was bad, but adding a new row defaults everything to <null> and then only editing the first two fields that have "NOT NULL" constraints, iirc UserName and UserKey, and "committing" the changes (you get prompted to do so if you just attempt to close sqliteman with changes) resolved the error after I unmounted and unplugged and didn't require any further messing around with the database. Last edited by dragon788; 09-15-2017 at 06:43 PM. Reason: Found a better way |
02-03-2018, 08:38 PM | #79 |
Connoisseur
Posts: 91
Karma: 10
Join Date: Feb 2014
Location: Long Island, NY
Device: Aura, N514KUBKKEP, 4.7.10.413
|
This is the 'user' table for the Kobo I just bought (firmware 4.7.10.413). Should anything be left alone to prevent messing up the device? Also, the fourth post in this thread states that one also needs to downgrade to firmware 1.9.16 in order for this hack to work. Is that true?
Last edited by u238110; 02-06-2018 at 04:09 PM. |
11-26-2019, 09:56 PM | #80 |
Member
Posts: 12
Karma: 10
Join Date: Nov 2019
Device: none
|
Has anybody had success doing this with a Libra? Got to the homepage successfully after editing KoboReader.sqlite users, but can't view the My Books page.
|
Advert | |
|
04-04-2022, 12:53 PM | #81 |
Junior Member
Posts: 2
Karma: 10
Join Date: Apr 2022
Device: Kobo Libra 2
|
Hi,
On my brand new Kobo Libra 2 (4.31.xx) : - UserID : 1 - UserKey : My first name - AnnotationsMigrated : true (or 1) - Everything else : default (null, true/false, ...) Without AnnotationsMigrated=true a damn nag screen appears. |
04-04-2022, 01:41 PM | #82 |
the rook, bossing Never.
Posts: 10,799
Karma: 83992605
Join Date: Jun 2017
Location: Ireland
Device: All 4 Kinds: epub eink, Kindle, android eink, NxtPaper11
|
Just turn on WiFi once.
Register with any imaginary or real email. Kobo doesn't send you email (unless you use their bookshop) nor do they pass on the email address. Tested with five Kobos since 2017. |
04-04-2022, 02:07 PM | #83 | |
Junior Member
Posts: 2
Karma: 10
Join Date: Apr 2022
Device: Kobo Libra 2
|
Quote:
Same when I tried to create a Kobo account. Anyway, I didn't know about your technique, and finally that's what made me want to tinker this reader. So : - The user friendly technique: activate the wifi and create an account with a fake email, - The technique for tinkerers: modify directly the database of the reader. |
|
04-05-2022, 06:22 AM | #84 |
the rook, bossing Never.
Posts: 10,799
Karma: 83992605
Join Date: Jun 2017
Location: Ireland
Device: All 4 Kinds: epub eink, Kindle, android eink, NxtPaper11
|
Or a real one. I used real ones created for the purpose. No spam or emails from Kobo on them ever. The email address only matters if you use the Kobo online bookstore to buy.
|
04-05-2022, 12:34 PM | #85 |
Wizard
Posts: 1,140
Karma: 5061953
Join Date: Jun 2011
Location: Ontario, Canada
Device: Kobo Aura HD
|
You don't have to include every field.. only 2 of them are needed. This SQL command has worked for a very, very long time.
INSERT INTO user(UserID,UserKey) VALUES('1',''); If using Sqlite: sqlite3 KoboReader.sqlite "INSERT INTO user(UserID,UserKey) VALUES('1','');" But the easy way to do this, without connecting to wifi, and without using SQL commands, is to simply copy a blank database into the .kobo directory. I've attached one to this message, unzip and copy to your kobo, then reboot. |
Thread Tools | Search this Thread |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Can't detect or connect to Kobo reader | GFH | Devices | 4 | 02-28-2012 09:20 AM |
Kobo Touch will not connect to Calibre | robmfrenette | Kobo Reader | 7 | 01-01-2012 06:56 PM |
Touch Kobo Touch defective after 3 months and Kobo Customer Support useless | shaf | Kobo Reader | 5 | 12-04-2011 05:10 PM |
Kobo Touch not disconnecting properly from Calibre OR Kobo Desktop - Windows 7 | JBlyth | Devices | 1 | 08-03-2011 06:50 AM |
How to de-activate Sony Reader from Connect? | bluearchtop | Sony Reader | 5 | 01-31-2008 06:53 PM |