[dev] how to debug address completion?

[Michael J Rubinsky]

Quoting Sebastian Birnbach <birnbacs at gmail.com>:

> Im still trying to debug the address completion in webmail's compose window.
>
> I made sure the correct address book and all fields (name, company) are
> selected in the user prefs.
>
> I traced the Ajax call in the web server's access log:
>
> Sep 14 09:51:18 max HORDE: [turba] SQL  (0,0013s)       SELECT object_id,
> object_type, object_members, object_nameprefix,         object_firstname,
> object_lastname, object_namesuffix, object_company    FROM turba_objects
> WHERE ((LOWER(object_nameprefix) LIKE     LOWER('%buch%') OR
> LOWER(object_firstname) LIKE LOWER('%buch%') OR      LOWER(object_lastname)
> LIKE LOWER('%buch%') OR          LOWER(object_namesuffix) LIKE
> LOWER('%buch%')) OR       LOWER(object_company) LIKE LOWER('%buch%')) [pid
> 14917 on line 321 of "/usr/local/share/pear/Horde/Db/Adapter/Mysqli.php"]
>
> Using the CLI to the mySQL database for that call returns a valid result:
>
> mysql> SELECT object_id, object_type, object_members, object_nameprefix,
>       object_firstname, object_lastname, object_namesuffix, object_company
>    FROM turba_objects WHERE ((LOWER(object_nameprefix) LIKE
> LOWER('%buch%') OR LOWER(object_firstname) LIKE LOWER('%buch%') OR
>  LOWER(object_lastname) LIKE LOWER('%buch%') OR
>  LOWER(object_namesuffix) LIKE LOWER('%buch%')) OR
> LOWER(object_company) LIKE LOWER('%buch%'))
>     -> ;
> +-------------------------+-------------+----------------+-------------------+------------------+-----------------+-------------------+----------------+
> | object_id               | object_type | object_members |
> object_nameprefix | object_firstname | object_lastname | object_namesuffix
> | object_company |
> +-------------------------+-------------+----------------+-------------------+------------------+-----------------+-------------------+----------------+
> | hCZggvr9yZlBnS_bHbSbIw2 | Object      | NULL           |
>   | Thomas           | Buchholz        | NULL              | BSH
>  |
> +-------------------------+-------------+----------------+-------------------+------------------+-----------------+-------------------+----------------+
> 1 row in set (0.00 sec)
>
>
> However, I notice that the search in question does not retrieve the
> person's email address.
>
> This does not seem right to me: what I am interested in is exactly the
> email adress while the fetched fields seem of far lesser interest. What is
> the intended behavior of the auto-complete feature, is the user supposed to
> see a list of retrieved persons and prompted to select one so that the
> email address gets fetched in a separate AJAX call?
>
> Any ideas?

What does your turba backends configuration look like for the address  
book in question? I.e., what email fields are configured?


>
>
>   Sebastian
>
>
>
>
>
> 2016-08-29 14:54 GMT+02:00 Michael J Rubinsky <mrubinsk at horde.org>:
>
>>
>> Quoting Sebastian Birnbach <birnbacs at gmail.com>:
>>
>> Address completion in IMP Webmail does not work on my system. After
>>> entering 3 characters I get a brief indication of action (a tiny spinning
>>> globe in the composition window) but no address gets found ever. I wonder
>>> if this is JS or server side functionality and how I could go about
>>> debugging this.
>>>
>>> I am using a global shared address book and no user is allowed a private
>>> address book. Where do I look first?
>>>
>>
>> Start by ensuring the correct address book(s) are selected in IMP's
>> Address Book preference. Check the server and/or horde logs for errors, you
>> can also check the JS console of the browser and/or use something like
>> Firebug to view the ajax requests to see if that shows you anything useful.
>>
>>
>>
>>> Kind regards
>>>
>>>   Sebastian
>>> --
>>> dev mailing list
>>> Frequently Asked Questions: http://wiki.horde.org/FAQ
>>> To unsubscribe, mail: dev-unsubscribe at lists.horde.org
>>>
>>
>>
>>
>> --
>> mike
>> The Horde Project
>> http://www.horde.org
>> https://www.facebook.com/hordeproject
>> https://www.twitter.com/hordeproject
>>
>> --
>> dev mailing list
>> Frequently Asked Questions: http://wiki.horde.org/FAQ
>> To unsubscribe, mail: dev-unsubscribe at lists.horde.org
>>
> --
> dev mailing list
> Frequently Asked Questions: http://wiki.horde.org/FAQ
> To unsubscribe, mail: dev-unsubscribe at lists.horde.org



-- 
mike
The Horde Project
http://www.horde.org
https://www.facebook.com/hordeproject
https://www.twitter.com/hordeproject
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 2007 bytes
Desc: S/MIME Signature
URL: <https://lists.horde.org/archives/dev/attachments/20160914/6671e702/attachment.bin>