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

[Jan Schneider]

Zitat von Bruno Costacurta <techie at costacurta.org>:

> 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

http://bugs.horde.org/ticket/10913
-- 
Jan Schneider
The Horde Project
http://www.horde.org/