[turba] Merging of turba_objects table(s)
Michael Rubinsky
mrubinsk at horde.org
Thu Apr 23 15:54:02 UTC 2009
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>
More information about the turba
mailing list