[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