BabakFarshchian
commented
11 years ago Thomas, I am not able to recreate this. The only thing I have changed in the DB in the new version is adding default values for all columns. I wrote a test to make sure that defaults are working for Me and it seems they do. I checked with SQLite Database Browser and it shows correct values in the database. We need to look into this together.
If I try to open the initial database (after I install the ubishare) in the sqlite broweser, I get an error triggered by the following exception
org.tmatesoft.sqljet.core.internal.lang.SqlJetParserException: [line 1:127] no viable alternative at input 'PENDING' CREATE TABLE me (_id integer primary key autoincrement, _id_people integer not null default -1,global_id text not null default PENDING,name text not null default UNKNOWN,display_name text not null default UNKNOWN,user_name text not null default UNKNOWN,password text not null default UNKNOWN,creation_date integer not null default (strftime('%s','now')),last_modified_date integer not null default (strftime('%s','now')),account_name text not null default UNKNOWN,account_type text not null default LOCAL,deleted integer not null default 0,dirty integer not null default 0,sync1 text not null default UNKNOWN,sync2 text not null default UNKNOWN,sync3 text not null default UNKNOWN,sync4 integer,sync5 integer,sync6 integer )
I was wondering if the ME table is not being correctly created or populated in the last version. Can you double check that?
BTW, I started working on a sample app to populate the db, but I think that the error I got (when testing it) may be related to a current problem on the db (and I could not browse the db to find more about it)