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 |
change that might have contributed to server load....
FB-URL even they are not in the kronolith prefs.
thread starts at:
http://lists.horde.org/archives/dev/Week-of-Mon-20071231/022513.html
(uschi@xxx,xx) in the notes before?
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?
in your kronolith prefs?
in your kronolith prefs?
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"]
http://cvs.horde.org/diff.php?f=turba%2Flib%2Fapi.php&r1=1.240&r2=1.241&t=unified
http://cvs.horde.org/diff.php?f=turba%2Flib%2Fapi.php&r1=1.240&r2=1.241&t=unified
here...looking into it.
Sorry, problem allready exist.
State ⇒ Feedback
Priority ⇒ 1. Low
State ⇒ Unconfirmed
Queue ⇒ Kronolith
Summary ⇒ FB-URL not found/use wrong query to search FB/URL
Type ⇒ Bug
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