Zitat von Bruno Costacurta <tec...@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/
--
imp mailing list
Frequently Asked Questions: http://wiki.horde.org/FAQ
To unsubscribe, mail: imp-unsubscr...@lists.horde.org
