[Tickets #2180] NEW: [BUG] free/busy returns wrong values

Fri Jun 24 00:25:24 PDT 2005

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: http://bugs.horde.org/ticket/?id=2180
-----------------------------------------------------------------------
 Ticket             | 2180
 Created By         | albisetti at elektro-material.ch
 Summary            | [BUG] free/busy returns wrong values
 Queue              | Kronolith
 Version            | 2.0.3
 State              | Unconfirmed
 Priority           | 2. Medium
 Type               | Bug
 Owners             | 
+New Attachment     | edit_attendees.jpg
-----------------------------------------------------------------------

albisetti at elektro-material.ch (2005-06-24 00:25) wrote:

free/busy shows for "all attendees" only free "possible meeting 
times" (on green), no busy informations (on red) are shown

- free/busy URL fields in addressbook (2.0.2, local MySQL) is configured for
all attendees
- Kronolith add events works fine (datatree backend is configured)
- Horde version 3.0.4
- kronolith_usage tables in MySQL is empty

Log from debug modus:

Jun 23 10:19:37 HORDE [debug] [kronolith] SQL Query by 
DataTree_sql::getByAttributes(): SELECT c.datatree_id, c.datatree_name 
FROM horde_datatree c LEFT JOIN horde_datatree_attributes a1 ON 
a1.datatree_id = c.datatree_id WHERE c.group_uid = ? AND 
(a1.attribute_name = ? AND a1.attribute_value \& ?)   GROUP BY 
c.datatree_id, c.datatree_name, c.datatree_order ORDER BY 
c.datatree_order, c.datatree_name, c.datatree_id [on line 979 of 
"/var/www/html/horde/lib/Horde/DataTree/sql.php"]