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,279
Karma: 74007256
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: 11,729
Karma: 87663463
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: 11,729
Karma: 87663463
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,195
Karma: 5372239
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. |
05-07-2024, 10:39 AM | #86 | |
Member
Posts: 11
Karma: 10
Join Date: Jan 2022
Device: Kindle
|
Quote:
INSERT INTO user(UserID,UserKey) VALUES('1',''); doesn't seem to work anymore on the Kobo Clara Colour. Also notice that the "empty" database you linked is not really empty, it contains the database structure and even some data. Among the tables is the "DbVersion" table, with a single column "version", and a single rows which equals 125 in your dataset and 175 in my Kobo. So I'm afraid to break it if I put it in, being a later version. |
|
05-07-2024, 11:46 AM | #87 | |
Wizard
Posts: 1,195
Karma: 5372239
Join Date: Jun 2011
Location: Ontario, Canada
Device: Kobo Aura HD
|
Quote:
Open the .kobo/kobo/Kobo eRader.conf file with a file editor that respects Unix Text file format, (Notepad++ recommended for Windows. Note this is something you can download, and is *not* the same the Notepad that comes with Windows.) In the [ApplicationPreferences] section, add the line: SideloadedMode=true Save, eject Kobo, and reboot Kobo. FYI, "Empty" database in this case meant a database that Kobo re-creates if it's deleted, with the blank user added. I meant only empty the sense that there was no account info and no books metadata. |
|
05-07-2024, 07:56 PM | #88 |
Resident Curmudgeon
Posts: 74,703
Karma: 130140792
Join Date: Nov 2006
Location: Roslindale, Massachusetts
Device: Kobo Libra 2, Kobo Aura H2O, PRS-650, PRS-T1, nook STR, PW3
|
The database hack to get full functionality without registering is a really bad idea to try. Two or three times Kobo has brought out a firmware update that totally broke that hack. So you lost everything. Even a backup database would not work. So don't do it. Don't ever do it unless you like starting over.
|
05-07-2024, 08:44 PM | #89 | |
Grand Sorcerer
Posts: 7,251
Karma: 65432101
Join Date: Feb 2009
Device: Kobo Glo HD
|
Quote:
|
|
05-07-2024, 09:01 PM | #90 |
Bibliophagist
Posts: 36,978
Karma: 148318166
Join Date: Jul 2010
Location: Vancouver
Device: Kobo Sage, Libra Colour, Lenovo M8 FHD, Paperwhite 4, Tolino epos
|
Not certain, my notes say was noted in rev 3.19 firmware by multiple users but a added note mentions a similar issue with 4.4 software though no confirmation on that.
So you are willing to setup your Kobo with a manually added fake user knowing that a new firmware revision may cause a factory reset? When current firmware makes it so easy to use SideloadedMode, it seems to be a silly choice. |
|
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 |