[turba] One More bug? - FB-URL not found
Helmut Schiefer
Helmut at 4Schiefer.de
Tue Jan 1 20:56:24 UTC 2008
Hello guys,
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
----------------------------------------------------------------
This message was sent using IMP, the Internet Messaging Program.
More information about the turba
mailing list