6.0.0-beta1
10/17/25

[#6064] FB-URL not found/use wrong query to search FB/URL
Summary FB-URL not found/use wrong query to search FB/URL
Queue Kronolith
Queue Version HEAD
Type Bug
State Not A Bug
Priority 1. Low
Owners mrubinsk (at) horde (dot) org
Requester helmut (at) 4schiefer (dot) de
Created 01/03/2008 (6497 days ago)
Due
Updated 01/04/2008 (6496 days ago)
Assigned 01/03/2008 (6497 days ago)
Resolved 01/04/2008 (6496 days ago)
Github Issue Link
Github Pull Request
Milestone
Patch No

History
01/04/2008 08:21:39 PM Michael Rubinsky State ⇒ Not A Bug
 
01/04/2008 08:21:08 PM Michael Rubinsky Comment #9 Reply to this comment

[Show Quoted Text - 9 lines]
You can try updating turba/lib/api.php again, I reverted an earlier 
change that might have contributed to server load....
Maybe it is in enhancement to search all selectable address books for
FB-URL even they are not in the kronolith prefs.
We just had a discussion about this on the dev@horde.org list. The 
thread starts at:



http://lists.horde.org/archives/dev/Week-of-Mon-20071231/022513.html
One question more: Can you delete the complete email address
(uschi@xxx,xx) in the notes before?
Sorry.  That's not something I'm able to do.


01/04/2008 07:25:23 PM helmut (at) 4schiefer (dot) de Comment #8 Reply to this comment
That's my misunderstanding. I think the kronolith prefs are only for 
the default search and auto expanding names, because there is a button 
"address book" in the atteendee screen and the third address book can 
be browsed although it isn't in selected in the prefs.



After I added the third address book the FB-URL was found (I've seen 
it in horde.log, not in the Web Front End) the dialog runs forever and 
I must restart the Apache Server.  Any sugestions? I'll debug this 
problem in the next days.



Maybe it is in enhancement to search all selectable address books for 
FB-URL even they are not in the kronolith prefs.



One question more: Can you delete the complete email address 
(uschi@xxx,xx) in the notes before?



Thanks for your help?
Are you sure that you have the third address book selected to be used
in your kronolith prefs?
01/04/2008 04:14:45 PM Michael Rubinsky Assigned to Michael Rubinsky
 
01/04/2008 03:10:40 PM Michael Rubinsky Comment #7 Reply to this comment
Are you sure that you have the third address book selected to be used 
in your kronolith prefs?
01/03/2008 10:15:40 PM helmut (at) 4schiefer (dot) de Comment #6 Reply to this comment
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@4Schiefer.de: No 
free/busy url found for Uschi@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@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@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
01/03/2008 08:53:58 PM Michael Rubinsky Comment #5 Reply to this comment
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




01/03/2008 08:26:49 PM Michael Rubinsky Comment #4 Reply to this comment
I can confirm that there is indeed something else going on 
here...looking into it.
01/03/2008 07:22:11 PM helmut (at) 4schiefer (dot) de Comment #3 Reply to this comment
I've download latest code of turba and kronolith.

Sorry, problem allready exist.
Wasn't this a duplicate of something Mike R. already fixed?
01/03/2008 04:41:13 PM Chuck Hagenbuch Comment #2
State ⇒ Feedback
Reply to this comment
Wasn't this a duplicate of something Mike R. already fixed?
01/03/2008 03:08:26 PM helmut (at) 4schiefer (dot) de Comment #1
Priority ⇒ 1. Low
State ⇒ Unconfirmed
Queue ⇒ Kronolith
Summary ⇒ FB-URL not found/use wrong query to search FB/URL
Type ⇒ Bug
Reply to this comment
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@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@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@xxx.xx"

Result:

28e31276024cba38a544d261ce62636f,helmut,Uschi@xxx.xx         
https://main.xxx.xx/kronolith/fb.php?u=xxx

Saved Queries