I'm running into a problem with the delete script. When I try to run this statement:
Code:
DELETE FROM com_palm_pim_Person WHERE id=31885837205535;
I get the error:
"no such collation sequence: LOCALIZED_SECONDARY"
Does anyone know sqlite well enough to help with this. Until this is fixed, you will have to delete duplicate contacts from your Pre manually, one by one 
Here's the schema for com_palm_pim_Person
Code:
CREATE TABLE com_palm_pim_Person (prefix TEXT, firstName TEXT, middleName TEXT, lastName TEXT, nickname TEXT, suffix TEXT, companyName TEXT, pictureLoc TEXT, pictureLocSquare TEXT, pictureLocBig TEXT, ringtoneLoc TEXT, messagingRingtoneLoc TEXT, ringtoneName TEXT, messagingRingtoneName TEXT, contactCount INTEGER, displayText TEXT, isVIP INTEGER, isMe INTEGER, launcherId TEXT, backupID INTEGER, sortKey TEXT, imAvailability INTEGER, reminder TEXT, id INTEGER PRIMARY KEY, _class_id INTEGER, _mod_num INTEGER, _flags INTEGER, sortKeyIntl TEXT COLLATE LOCALIZED_SECONDARY);
CREATE INDEX sortKeyIntl_idx_com_palm_pim_Person ON com_palm_pim_Person (sortKeyIntl);
CREATE TRIGGER com_palm_pim_Person_contacts_delete_trigger AFTER DELETE ON com_palm_pim_Person BEGIN UPDATE com_palm_pim_Contact SET _mod_num = (SELECT * FROM _CurrentModificationNumber_view), com_palm_pim_Person_id = NULL WHERE com_palm_pim_Person_id = OLD.id; END;
CREATE TRIGGER com_palm_pim_Person_insert_sequence_trg AFTER INSERT ON com_palm_pim_Person BEGIN UPDATE _ClassSequence SET number = (NEW.id & 1099511627775) WHERE id = 31; END;