Tickets :: Comment on [#12480] Autocomplete includes all addresses for a user where any of them match

* Your Email Address
* Spam protection	Enter the letters below: .___. __ . ..__ [__ \| / `\|_/ [__) [___\|___\__.\| \\|
Comment	> I got it... > > I see this when typing "simona" in for AC: > > 2013-07-25T10:56:12+00:00 DEBUG: HORDE [turba] SQL (0.0023s) > SELECT object_id, object_type, owner_id, object_members, > object_lastname, object_firstname, object_middlenames, > object_namesuffix, object_email FROM turba_objects WHERE (owner_id = > 'simon' AND ((LOWER(object_lastname) LIKE LOWER('%simona%') OR > LOWER(object_firstname) LIKE LOWER('%simona%') OR > LOWER(object_middlenames) LIKE LOWER('%simona%') OR > LOWER(object_namesuffix) LIKE LOWER('%simona%')) OR > LOWER(object_email) LIKE LOWER('%simona%') OR LOWER(object_email2) > LIKE LOWER('%simona%') OR LOWER(object_email3) LIKE > LOWER('%simona%'))) [pid 12252 on line 558 of > "/usr/share/pear/Horde/Db/Adapter/Base.php"] > 2013-07-25T10:56:12+00:00 DEBUG: HORDE [turba] LDAP query by > Turba_Driver_ldap::_search(): user = simon, root = > ou=shared_addressbook,dc=simonandkate,dc=lan (ldap.simonandkate.lan); > filter = "(\|(cn=simona)(mail=simona))"; attributes = "dn, > turbaType, turbaMembers, cn, mail, sn"; deref = "0" ; sizelimit = > 200 [pid 12252 on line 195 of > "/var/www/horde/turba/lib/Driver/Ldap.php"] > > The "aquenta" email address that is being returned in the graphic > attached to this ticket is located in SQL object_email only, not in > LDAP at all. > > Manually executing that SQL statement shows me that the script is > matching the "simona" as LIKE against object_email2 for Katie (where > that address resides), but then the SELECT statement is only > returning object_email, which contains the aquenta email address. > > If I exclude the LDAP directory from the search, I see object_email > returned for the two SQL address book entries that match: > > Mine, where object_email is simon AT simonandkate.net, and katie's > where it is AT aquenta..., thus returning an email address that does > not match the search query. So I have no way of auto-completing > Katie's simonandkate email address unless I move it to object_email > instead of object_email2, despite that AC actually searches them all > for matches. > > >
Attachment
Watch this ticket

Saved Queries