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