Need a dummy user record example for Kobo Aura 3.3.0

Karen Myers · 08-28-2014, 01:22 PM

I'm at the end (I hope) of a sideload firmware issue for Kobo Aura 3.3.0, and I need to supply a dummy user record to bypass the registration process (else my device ceases to be recognizable to Windows). I'm not enough of an SQL maven to properly supply the record for the "user" table in KoboReader.sqlite, but I do have an example of the 3.3.0 installation (pre-registration) record as a model.

Could anyone supply me with proper "dummy" content to use instead? (9 fields: __DeviceID and FacebookAuthToken are blank)

Field Value

UserID dec75cef-493f-4da1-af8d-d7a7183fa3e5
UserKey 0a0e4b93-68fd-455a-b716-039e7c973dce
UserDisplayName demobundle06_13@kobo.com
UserEmail demobundle06_13@kobo.com
__DeviceID
FacebookAuthToken
HasMadePurchase false
IsOneStoreAccount FALSE
IsChildAccount FALSE

Definitions

UserID TEXT NOT NULL
UserKey TEXT NOT NULL
UserDisplayName TEXT
UserEmail TEXT
__Device ID TEXT
FacebookAuthToken TEXT
HasMadePurchase BIT DEFAULT FALSE
IsOneStoreAccount BIT DEFAULT FALSE
IsChildAccount BIT DEFAULT FALSE

Karen Myers · 08-28-2014, 01:51 PM

Alright, I'm lame, I know (hey, I predate SQL by quite a bit). For the sake of anyone who follows this, here's a record which works for the User table:

INSERT INTO "user" VALUES('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa','aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa','xxxx@xxxx.xxx','xxxx@xxxx.xxx','a', 'a','FALSE','FALSE','FALSE');

08-28-2014, 01:22 PM	#1
Karen Myers Member Posts: 13 Karma: 10 Join Date: Aug 2014 Device: Kobo Aura	Need a dummy user record example for Kobo Aura 3.3.0 I'm at the end (I hope) of a sideload firmware issue for Kobo Aura 3.3.0, and I need to supply a dummy user record to bypass the registration process (else my device ceases to be recognizable to Windows). I'm not enough of an SQL maven to properly supply the record for the "user" table in KoboReader.sqlite, but I do have an example of the 3.3.0 installation (pre-registration) record as a model. Could anyone supply me with proper "dummy" content to use instead? (9 fields: __DeviceID and FacebookAuthToken are blank) Field Value UserID dec75cef-493f-4da1-af8d-d7a7183fa3e5 UserKey 0a0e4b93-68fd-455a-b716-039e7c973dce UserDisplayName demobundle06_13@kobo.com UserEmail demobundle06_13@kobo.com __DeviceID FacebookAuthToken HasMadePurchase false IsOneStoreAccount FALSE IsChildAccount FALSE Definitions UserID TEXT NOT NULL UserKey TEXT NOT NULL UserDisplayName TEXT UserEmail TEXT __Device ID TEXT FacebookAuthToken TEXT HasMadePurchase BIT DEFAULT FALSE IsOneStoreAccount BIT DEFAULT FALSE IsChildAccount BIT DEFAULT FALSE Last edited by Karen Myers; 08-28-2014 at 01:37 PM. Reason: Field definitions

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Aura HD Kobo Glo/Aura/Aura HD future firmware feature request thread	arspr	Kobo Reader	25	03-26-2015 05:19 AM
Dymo tape fix for eBay Kobo Aura and Aura HD covers	RobertJSawyer	Kobo Reader	2	02-10-2014 10:34 AM
Canadian shoppers discount on kobo aura and aura hd	eejit	Deals and Resources (No Self-Promotion or Affiliate Links)	4	11-28-2013 01:43 AM
Using a dummy Kobo account	Lynx-lynx	Kobo Reader	4	12-29-2012 07:00 AM
Can I create am empty record that refers back to another record?	ficbot	Calibre	1	10-13-2011 09:20 AM

08-28-2014, 01:51 PM	#2
Karen Myers Member Posts: 13 Karma: 10 Join Date: Aug 2014 Device: Kobo Aura	Alright, I'm lame, I know (hey, I predate SQL by quite a bit). For the sake of anyone who follows this, here's a record which works for the User table: INSERT INTO "user" VALUES('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa','aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa','xxxx@xxxx.xxx','xxxx@xxxx.xxx','a', 'a','FALSE','FALSE','FALSE');