View Single Post
Old 01-13-2017, 07:13 PM   #18
besucherin
Junior Member
besucherin began at the beginning.
 
Posts: 3
Karma: 10
Join Date: Jan 2017
Device: kobo
Quote:
Originally Posted by CatRovacer View Post
Result of these manipulations depends by version of updates.

What is suitable for an earlier release will not accept a more recent update.

I still listened to comrades here and started the dummy account on kobo com )))
After exercise in editing database tables.
I let mine connect to wifi and it updated before I realized it was a bad idea. After updating, the sqlite commmand returned:

Code:
sqlite> insert into user values ('','','','','','','','','','','','','','','','',' ','');
Error: table user has 19 columns but 18 values were supplied
So, all it needed was an extra ,'' to made it work without registration.
Code:
sqlite> insert into user values ('','','','','','','','','','','','','','','','',' ','','');

The schema for the user table after the update is:

CREATE TABLE user(UserID TEXT NOT NULL,
UserKey TEXT NOT NULL,
UserDisplayName TEXT,
UserEmail TEXT,
___DeviceID TEXT,
FacebookAuthToken TEXT,
HasMadePurchase BIT DEFAULT FALSE,
IsOneStoreAccount BIT DEFAULT FALSE,
IsChildAccount BIT DEFAULT FALSE,
RefreshToken TEXT,
AuthToken TEXT,
AuthType TEXT,
Loyalty BLOB,
IsLibraryMigrated BIT NOT NULL DEFAULT true,
SyncContinuationToken TEXT,
Subscription INT NOT NULL DEFAULT 0,
LibrarySyncType TEXT,
LibrarySyncTime TEXT,
SyncTokenAppVersion TEXT,
PRIMARY KEY (UserID));

Wondering what this loyalty blob is........
Edit: Found the old schema in another thread, the added field is SyncTokenAppVersion.

Last edited by besucherin; 01-13-2017 at 07:48 PM.
besucherin is offline   Reply With Quote