Tickets :: Comment on [#11972] importing ldif files from Thunderbird fails

* Your Email Address
* Spam protection	Enter the letters below: . ,.__..__.\ /.__. \./ [__]\| \| >< \| \| \| \| \|\|__\|/ \\|__\|
Comment	> That made a difference - now it gets as far as importing, but then > fails due to re-use of object_id. I trashed all my addressbook and > imported the LDIF file - but "1B2M2Y8AsgTpgAmY7PhCfg1" is getting > reused > > There was an error importing the data: QUERY FAILED: Duplicate entry > '1B2M2Y8AsgTpgAmY7PhCfg1' for key 'PRIMARY' INSERT INTO turba_objects > (object_firstname, object_lastname, object_email, owner_id, > object_type, object_uid, object_id) VALUES ('Jason', 'Weinberg', > 'jweinberg@guardianedge.com', 'jhaar', 'Object', > '20130117221807.1B2M2Y8AsgTpgAmY7PhCfg1@whanau.org', > '1B2M2Y8AsgTpgAmY7PhCfg1') > > > After the import (100s of entries in the LDIF file), only the > following 4 entries are in the turba_objects table > > INSERT INTO `turba_objects` VALUES > ('1B2M2Y8AsgTpgAmY7PhCfg1','jhaar','Object','20130117220505.1B2M2Y8AsgTpgAmY7PhCfg1@whanau.org',NULL,'Andrew','ds',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'ds@ds.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); > INSERT INTO `turba_objects` VALUES > ('1B2M2Y8AsgTpgAmY7PhCfg2','jhaar','Object','20130117220617.1B2M2Y8AsgTpgAmY7PhCfg1@whanau.org',NULL,'Ferry','ds',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'ferry.ds@e.ds.nz',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); > INSERT INTO `turba_objects` VALUES > ('1B2M2Y8AsgTpgAmY7PhCfg3','jhaar','Object','20130117220617.1B2M2Y8AsgTpgAmY7PhCfg1@whanau.org',NULL,'ds','Landin',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'sdin@dsd.se',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); > INSERT INTO `turba_objects` VALUES > ('1B2M2Y8AsgTpgAmY7PhCfg4','1B2M2Y8AsgTpgAmY7PhCfg4','Object','20130111051719.1B2M2Y8AsgTpgAmY7PhCfg1@whanau.org',NULL,'Roy','ds','','','','xxx',NULL,NULL,NULL,'2a dfdfd > Place','','Raglan','','','NZ','','','','','','','',NULL,'dsd@ds.org','','','','','','','',NULL,NULL,'','','','','','','',NULL,'','','',NULL,'','skype:xxx','',''); > INSERT INTO `turba_objects` VALUES > ('1B2M2Y8AsgTpgAmY7PhCfg8','jhaar','Object','20130117220712.1B2M2Y8AsgTpgAmY7PhCfg2@whanau.org',NULL,'Support',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'support@guardianedge.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); >
Attachment
Watch this ticket

Saved Queries