[imp] Auto-completion for address book not displayed when composing email.

[Bruno Costacurta]

Hello,

I added two email fields to the Turba.
It works fine and the setup of the address book within IMP seems OK.
The SQL query produced by auto-completion for Turba address works fine  
too (as the query executed manually on the MySQL database return  
correctly the address book record).

The problem is nothing is displayed.
How this display of email from address book is supposed to work when  
composing a new email ?
Thanks.

Hereafter the Turba query during auto-completion in the Horde log :
....
2013-01-21T20:23:14+01:00 DEBUG: HORDE [turba] SQL  (0.0001s)
	SELECT * FROM turba_sharesng_users WHERE user_uid = 'bruno' AND
	  (perm_4 = 1) [pid 10022 on line 806 of  
"/usr/share/php/Horde/Db/Adapter/Base.php"]
2013-01-21T20:23:14+01:00 DEBUG: HORDE [turba] SQL  (0.0001s)
	SELECT g.group_uid AS group_uid, g.group_name AS group_name FROM
	  horde_groups g, horde_groups_members m WHERE m.user_uid = 'bruno' AND
	  g.group_uid = m.group_uid ORDER BY g.group_name [pid 10022 on line  
806 of "/usr/share/php/Horde/Db/Adapter/Base.php"]
2013-01-21T20:23:14+01:00 DEBUG: HORDE [turba] SQL  (0.0001s)
	SELECT DISTINCT * FROM turba_sharesng s WHERE share_owner = 'bruno' OR
	  perm_creator_4 = 1 OR perm_default_4 = 1 ORDER BY share_id ASC [pid  
10022 on line 806 of "/usr/share/php/Horde/Db/Adapter/Base.php"]
2013-01-21T20:23:14+01:00 DEBUG: HORDE [turba] SQL  (0.0001s)
	SELECT object_id, object_type, owner_id, object_members,
	  object_firstname, object_lastname, object_email FROM turba_objects
	  WHERE (owner_id = 'bruno' AND (LOWER(object_workemail) LIKE
	  LOWER('%Techi%') OR LOWER(object_homeemail) LIKE LOWER('%Techi%')))  
[pid 10022 on line 806 of "/usr/share/php/Horde/Db/Adapter/Base.php"]
2013-01-21T20:23:14+01:00 DEBUG: HORDE [turba] SQL  (0.0022s)
	SHOW FIELDS FROM `turba_objects` [pid 10022 on line 806 of  
"/usr/share/php/Horde/Db/Adapter/Base.php"]
2013-01-21T20:23:14+01:00 DEBUG: HORDE [horde] Max memory usage:  
9437184 bytes [pid 10022 on line 543 of  
"/usr/share/php/Horde/Registry.php"]

...

Hereafter briefly the two added fields :

in backends.local.php :
...
'workEmail' => 'object_workemail',
'homeEmail' => 'object_homeemail',
...

in attributes.local.php :
...
$attributes['homeEmail'] = array(
        'label' => _("Home Email"),
        'type' => 'email',
        'required' => false,
        'params' => array('allow_multi' => false, 'size' => 50,  
'maxlength' => 50,'strip_domain' => false, 'link_compose' => true)
);
$attributes['workEmail'] = array(
        'label' => _("Work Email"),
        'type' => 'email',
        'required' => false,
        'params' => array('allow_multi' => false, 'size' => 50,  
'maxlength' => 50,'strip_domain' => false, 'link_compose' => true)
);
...

-- 
Linux Counter # 353844
https://linuxcounter.net/user/353844.html