[Tickets #6064] FB-URL not found/use wrong query to search FB/URL

[bugs at horde.org]

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: http://bugs.horde.org/ticket/?id=6064
-----------------------------------------------------------------------
 Ticket             | 6064
 Created By         | helmut at 4Schiefer.de
 Summary            | FB-URL not found/use wrong query to search FB/URL
 Queue              | Kronolith
 Version            | HEAD
 Type               | Bug
 State              | Unconfirmed
 Priority           | 1. Low
 Milestone          | 
 Patch              | 
 Owners             | 
-----------------------------------------------------------------------


helmut at 4Schiefer.de (2008-01-03 10:08) wrote:

maybe one additional bug, I'm not sure.
1) Open kronolith, click "add event"
2) click "Edit Attendees"
3) On the next screen: click Address Book
4) Now selected a address book that isn't use for expanding addresses. I
didn't do a
cross check with the other address books
5) Search user with a FB-Url, select it and click "Add to attendees"

=> In the other screen the user is as posible attendee selected but there
is an error:
"No free/busy url found for Uschi at xx.xx"

I entered a free/busy url and a cross check using url shows - It works.

I put some more output in the sql.php an found the following problem.

The search in the address book shows the correct owner_id. So the user is
found and shown.
I think a second select is use to find the free/busy url. This select is
done by the
wrong owner_id so the correct fb-url isn't found an the ug occur.

Appended:
1) Output Horde.log
Jan 01 18:47:16 HORDE [debug] [turba] SQL query by
Turba_Driver_sql::_search(): SELECT
object_id, owner_id, object_type, object_members, object_uid,
object_firstname,
object_lastname, object_middlenames, object_nameprefix, object_namesuffix,
object_alias,
object_bday, object_homestreet, object_homepob, object_homecity,
object_homeprovince,
object_homepostalcode, object_homecountry, object_workstreet,
object_workpob,
object_workcity, object_workprovince, object_workpostalcode,
object_workcountry,
object_tz, object_email, object_homephone, object_workphone,
object_cellphone,
object_fax, object_pager, object_title, object_role, object_company,
object_category,
object_notes, object_url, object_freebusyurl, object_pgppublickey,
object_smimepublickey
FROM turba_objects WHERE (object_email = ? AND owner_id = ?) Values:
Uschi at xxx.xx
51454a2be3707bef919bb3f592e8ceeb      [pid 11838 on line 166 of
"/srv/www/vhosts/main/run/horde/turba/lib/Driver/sql.php"]


2) Select to the database
Query: select object_id,owner_id,object_email,object_freebusyurl from
turba_objects where
object_email like "uschi at xxx.xx"
Result:
28e31276024cba38a544d261ce62636f,helmut,Uschi at xxx.xx       
https://main.xxx.xx/kronolith/fb.php?u=xxx