View Single Post
Posts: 49 | Thanked: 7 times | Joined on Sep 2010
#1
i have tried to manipulate the el-v1.db manually and tried to use the update query as bellow:

INSERT INTO Events
VALUES(63,3,11,1275483743,1275483734,1275483741,1, 0,0,0,0,'ring/tel/ring','<SelfHandle>','Nokia',NULL,'test message','Nokia');


i have added the above values according to this:

TABLE Events (id INTEGER PRIMARY KEY,service_id INTEGER NOT NULL,event_type_id INTEGER NOT NULL,storage_time INTEGER NOT NULL,start_time INTEGER NOT NULL,end_time INTEGER,is_read INTEGER DEFAULT 0,outgoing BOOL DEFAULT 0,flags INTEGER DEFAULT 0,bytes_sent INTEGER DEFAULT 0,bytes_received INTEGER DEFAULT 0,local_uid TEXT,local_name TEXT,remote_uid TEXT,channel TEXT,free_text TEXT,group_uid TEXT)

but when i go to conversations, the name of the sender is "NULL" and when trying to access it, it says "unable to access the conversation null" or whatsoever.

im trying disperately to get my old messages imported into my new N900 but no luck
I wish if somebody can pin point what im missing here in this query??