[Tickets #6058] Re: Move Contact to the wrong field

[bugs at horde.org]

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

Ticket URL: http://bugs.horde.org/ticket/?id=6058
-----------------------------------------------------------------------
 Ticket             | 6058
 Updated By         | helmut at 4Schiefer.de
 Summary            | Move Contact to the wrong field
 Queue              | Turba
 Version            | HEAD
 Type               | Bug
 State              | Feedback
 Priority           | 1. Low
 Milestone          | 
 Patch              | 
 Owners             | 
-----------------------------------------------------------------------


helmut at 4Schiefer.de (2007-12-31 14:35) wrote:

Thanks for your reply.
Some more Information: I user mysql as the datastore and  use the
sources.php 1.91 from the cvs. I didn't change anything in sources.php. My
prefs are in LDAP

1) I create a new address book using turba gui. 
2) I open an existing address book using turba gui
3) I select an entry of the address book and then I click  move
4) Entry moved form one address book to another.

Following are the records of the database:
Query:
select * from turba_objects where object_email like "xxx at xx.de";
Before move:
ec6fde91074aff8567c65d52bb64494c,51454a2be3707bef919bb3f592e8ceeb,	Object,20070617120112.6m2wo7h6rq0w at xx.xx.de,'',Schiefer,'',xxx at xx.de,StreetXXXX5,'',+492213555555,'','','','','','','','',https://xxx.xxx.xx/kronolith/fb.php?u=xxx	,xxxx,Frau,Cologne,NRW,12345,'','','','','','','','','','',2001-03-15,'','','','','',Europe/Berlin,'','',''	

After move:
b2e324c0f86ae9e34e386c3a5f9c5384,helmut,Object,20070617120112.6m2wo7h6rq0w at xx.xx.de	,'','','',xxx at xx.de,StreetXXXX5,'',+492213555555,'','','','','','','','',https://xxx.xxx.xx/kronolith/fb.php?u=xxx	,xxxx,Frau,Cologne,NRW,12345,'','','','','','','','','','',2001-03-15,'',Schiefer,'','','',Europe/Berlin	,'','',''
	 	  	 


Following is the conf.php from turba:
<?php
/* CONFIG START. DO NOT CHANGE ANYTHING IN OR AFTER THIS LINE. */
// $Horde: turba/config/conf.xml,v 1.21 2007/10/16 16:14:48 mrubinsk Exp
$
$conf['menu']['import_export'] = false;
$conf['menu']['apps'] = array();
$conf['client']['addressbook'] = 'localsql';
$conf['shares']['source'] = 'localsql';
$conf['comments']['allow'] = true;
$conf['documents']['type'] = 'horde';
/* CONFIG END. DO NOT CHANGE ANYTHING IN OR BEFORE THIS LINE. */

Following is the discribe of the table: 
field	type	null	key	default	extra
object_id	varchar(32)	 	PRI	 	 
owner_id	varchar(255)	 	MUL	 	 
object_type    varchar(255)	 	 	Object	 
object_uid	varchar(255)	YES	 	 	 
object_members	blob	YES	 	 	 
object_lastname	varchar(255)	YES	MUL	 	 
object_alias	varchar(32)	YES	 	 	 
object_email	varchar(255)	YES	MUL	 	 
object_homestreet	varchar(255)	YES	 	 	 
object_workstreet	varchar(255)	YES	 	 	 
object_homephone	varchar(25)	YES	 	 	 
object_workphone	varchar(25)	YES	 	 	 
object_cellphone	varchar(25)	YES	 	 	 
object_fax	varchar(25)	YES	 	 	 
object_title	varchar(255)	YES	 	 	 
object_company	varchar(255)	YES	 	 	 
object_notes	text	YES	 	 	 
object_pgppublickey	text	YES	 	 	 
object_smimepublickey	text	YES	 	 	 
object_freebusyurl	varchar(255)	YES	 	 	 
object_firstname	varchar(255)	YES	MUL	 	 
object_nameprefix	varchar(255)	YES	 	 	 
object_homecity	varchar(255)	YES	 	 	 
object_homeprovince	varchar(255)	YES	 	 	 
object_homepostalcode	varchar(255)	YES	 	 	 
object_homecountry	varchar(255)	YES	 	 	 
object_workcity	varchar(255)	YES	 	 	 
object_workprovince	varchar(255)	YES	 	 	 
object_workpostalcode	varchar(255)	YES	 	 	 
object_workcountry	varchar(255)	YES	 	 	 
object_pager	varchar(25)	YES	 	 	 
object_role	varchar(255)	YES	 	 	 
object_category	varchar(80)	YES	 	 	 
object_photo	blob	YES	 	 	 
object_phototype	varchar(10)	YES	 	 	 
object_bday	varchar(10)	YES	 	 	 
object_url	varchar(255)	YES	 	 	 
object_middlenames	varchar(255)	YES	 	 	 
object_namesuffix	varchar(32)	YES	 	 	 
object_homepob	varchar(10)	YES	 	 	 
object_workpob	varchar(10)	YES	 	 	 
object_tz	varchar(32)	YES	 	 	 
object_geo	varchar(255)	YES	 	 	 
object_logo	blob	YES	 	 	 
object_logotype	varchar(10)	YES	 	

Hope this help 	 







> I cannot reproduce this.  Can you provide more information? What 
> sources you are moving between (what the backend for each source is) 
> etc...  Also, check the map array for each of these sources in 
> sources.php
>