[Tickets #6064] Re: 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
 Updated By         | helmut at 4Schiefer.de
 Summary            | FB-URL not found/use wrong query to search FB/URL
 Queue              | Kronolith
 Version            | HEAD
 Type               | Bug
 State              | Feedback
 Priority           | 1. Low
 Milestone          | 
 Patch              | 
 Owners             | 
-----------------------------------------------------------------------


helmut at 4Schiefer.de (2008-01-03 17:15) wrote:

I've download CVS Head with Version 1.241 of api.php.

Sorry, the problem exists as described.  Also I see the same message
"Error retrieving free/busy information for Uschi at 4Schiefer.de: No
free/busy url found for Uschi at 4xxx.xx"

As you see - kronolith do a search of two of the three address books, but
the used entry is in the third one.

Horde.log
========
Jan 03 22:45:59 HORDE [debug] [kronolith] Failed to load translation file
for driver Germany with locale en_US [pid 7481 on line 61 of
"/srv/www/vhosts/main/run/horde/kronolith/lib/Driver/holidays.php"]
Jan 03 22:45:59 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 7481 on line 166 of
"/srv/www/vhosts/main/run/horde/turba/lib/Driver/sql.php"]
Jan 03 22:45:59 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 8bd13b40a3b6da0618e9f7f39179578d     
[pid 7481 on line 166 of
"/srv/www/vhosts/main/run/horde/turba/lib/Driver/sql.php"]
Jan 03 22:45:59 HORDE [debug] [kronolith] SQL search by helmut: query =
"SELECT vfb_serialized FROM kronolith_storage WHERE vfb_email=? AND
(vfb_owner=? OR vfb_owner='')" [pid 7481 on line 140 of
"/srv/www/vhosts/main/run/horde/kronolith/lib/Storage/sql.php"]





> Can you see if what I just commited fixed this for you?
>
>
http://cvs.horde.org/diff.php?f=turba%2Flib%2Fapi.php&r1=1.240&r2=1.241&t=unified
>
>