[turba] Merging of turba_objects table(s)

[Michael Rubinsky]

Quoting lst_hoe02 at kwsoft.de:

> Zitat von ANANT S ATHAVALE <asa at isac.gov.in>:
>
>> Dear List,
>>
>>
>> We currently have two servers running HORDE 3.1.5 and its  
>> applications.  The users on these two systems are different.
>>
>> We are in the process of migration to latest version of HORDE.   
>> During this migration, we want to merge users of both servers.   
>> During this process, I am finding difficulty in merging  
>> turba_object table of both.
>>
>> while inserting data from second server, I get following error.
>>
>> ERROR 1062 (23000) at line 30588: Duplicate entry  
>> '12345678901234567890123450000899' for key 1
>>
>> That is 'object_id' is clashing.  I don't want users loose their  
>> address book during the process of migration.  How can I achieve it?
>
> As far as i know the "object_id" only have to be unique so simply  
> adding the hostname before migration might be a solution.

This is only partially true.  The object_id is used elsewhere to  
identify the object. For example, in contact groups, the  
object_members field contains the object_ids of the contacts in the  
group (the longer story is that the value may be a key made up of the  
source name and the object id) but nevertheless, the object id cannot  
just be changed without checking for and changing it elsewhere. This  
is also complicated by the fact the sources other than sql based  
source may have added a contact from this table, and thus the  
object_id would need to be changed there as well.


Thanks,
mike

--
The Horde Project (www.horde.org)
mrubinsk at horde.org

"Time just hates me. That's why it made me an adult." - Josh Joplin
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: PGP Digital Signature
URL: <http://lists.horde.org/archives/turba/attachments/20090423/9ac4ffa1/attachment.bin>