samedi 26 décembre 2015

insert data to contacts2.db

Why error in raw_contacts ?

ERROR :

SQLiteManager:
INSERT INTO "raw_contacts" VALUES(1,1,NULL,0,2,1,0,1,0,0,NULL,0,0,NULL,0,2147483647,'09999999999','09999999999',20,NULL,'0','09999999999','#',208,'09999999999','#',208,0,NULL,NULL,NULL,NULL); [ no such collation sequence: PHONEBOOK ]
Exception Name: NS_ERROR_FAILURE
Exception Message: Component returned failure code: 0x80004005 (NS_ERROR_FAILURE) [mozIStorageConnection.createStatement]

SQL statement for INSERT :

INSERT INTO "contacts" 
VALUES(1, 1, NULL, NULL,  NULL, 0, 0, 0, 0, 2147483647, 1, '0r1-1224142414221E16121C1C', NULL, 1448202599930);

INSERT INTO "data" 
VALUES(1, NULL, 5, 1, 0, 0, 0, 0, '09999999999', '2', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO "default_directory" 
VALUES(1);

INSERT INTO "phone_lookup" 
VALUES(1, 1, '09999999999', '5502681');

INSERT INTO "raw_contacts" 
VALUES(1, 1, NULL, 0, 2, 1, 0, 1, 0, 0, NULL, 0, 0, NULL, 0, 2147483647, '09999999999', '09999999999', 20, NULL, '0', '09999999999', '#', 208, '09999999999', '#', 208, 0, NULL, NULL, NULL, NULL);

INSERT INTO "search_index" 
VALUES(1, NULL, NULL, '09999999999');

INSERT INTO "visible_contacts" 
VALUES(1);

Help me please :((

Sorry.My English is not good.

Aucun commentaire:

Enregistrer un commentaire