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

[noreply at bugs.horde.org]

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: http://bugs.horde.org/ticket/11972
------------------------------------------------------------------------------
  Ticket             | 11972
  Updated By         | jhaar-horde at whanau.org
  Summary            | importing ldif files from Thunderbird fails
  Queue              | Turba
  Version            | Git master
  Type               | Bug
  State              | Resolved
  Priority           | 2. Medium
  Milestone          |
  Patch              |
  Owners             | Jan Schneider
------------------------------------------------------------------------------


jhaar-horde at whanau.org (2013-01-17 22:21) wrote:

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 at guardianedge.com', 'jhaar', 'Object',  
'20130117221807.1B2M2Y8AsgTpgAmY7PhCfg1 at 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 at 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 at 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 at 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 at 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 at 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 at 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 at whanau.org',NULL,'Roy','ds','','','','xxx',NULL,NULL,NULL,'2a dfdfd  
Place','','Raglan','','','NZ','','','','','','','',NULL,'dsd at ds.org','','','','','','','',NULL,NULL,'','','','','','','',NULL,'','','',NULL,'','skype:xxx','','');
INSERT INTO `turba_objects` VALUES  
('1B2M2Y8AsgTpgAmY7PhCfg8','jhaar','Object','20130117220712.1B2M2Y8AsgTpgAmY7PhCfg2 at 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 at 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);