| Summary | free/busy returns wrong values |
| Queue | Kronolith |
| Queue Version | 2.0.3 |
| Type | Bug |
| State | Resolved |
| Priority | 2. Medium |
| Owners | |
| Requester | albisetti (at) elektro-material (dot) ch |
| Created | 06/24/2005 (7323 days ago) |
| Due | |
| Updated | 08/09/2005 (7277 days ago) |
| Assigned | 08/08/2005 (7278 days ago) |
| Resolved | 08/09/2005 (7277 days ago) |
| Github Issue Link | |
| Github Pull Request | |
| Milestone | |
| Patch | No |
New Attachment: week.jpg
very much! There is only a small table allignment problem in the "work
week" and "week" view (see attachment). The day view is ok. The Ticket
#2180can be market as solved.Taken from Chuck Hagenbuch
State ⇒ Feedback
has been rewritten there.
New Attachment: attendees.php.html
Kronolith_FreeBusy_View ($attendee_view) are correct, but the output
does not show any busy listings.
I've saved the HTML output instead of providing a screenshot, in case
this is of any help.
Versions:
<?php define('KRONOLITH_VERSION', 'H3 (2.0.3)') ?>
<?php define('HORDE_VERSION', '3.0.4') ?>
<?php define('TURBA_VERSION', 'H3 (2.0.2)') ?>
output from fb.php?c=username:
--root.vfb--
BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//The Horde Project//Kronolith H3 (2.0.3)//EN
METHOD:PUBLISH
BEGIN:VFREEBUSY
ORGANIZER;CN=root root:MAILTO:root.root@karmoy.kommune.no
DTSTAMP:20050801T121232Z
DTSTART:20050731T220000Z
DTEND:20050830T220000Z
URL:http://webmail2.karmoy.kommune.no/horde/kronolith/fb.php?c=root
FREEBUSY:20050804T100000Z/20050804T150000Z
FREEBUSY:20050811T100000Z/20050811T110000Z
END:VFREEBUSY
END:VCALENDAR
--kurs3.vfb--
BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//The Horde Project//Kronolith H3 (2.0.3)//EN
METHOD:PUBLISH
BEGIN:VFREEBUSY
ORGANIZER;CN=kurs3 kurs:MAILTO:kurs3.kurs@karmoy.kommune.no
DTSTAMP:20050801T121240Z
DTSTART:20050731T220000Z
DTEND:20050830T220000Z
URL:http://webmail2.karmoy.kommune.no/horde/kronolith/fb.php?c=kurs3
FREEBUSY:20050802T100000Z/20050808T100000Z
END:VFREEBUSY
END:VCALENDAR
New Attachment: edit_attendees[1].jpg
included (see below); something doesn't work showing those datas under
"Edit Attendees"
--- user = testzh ---
BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//The Horde Project//Kronolith H3 (2.0.3)//EN
METHOD:PUBLISH
BEGIN:VFREEBUSY
ORGANIZER:MAILTO:testzh@elektro-material.ch
DTSTAMP:20050627T073033Z
DTSTART:20050626T220000Z
DTEND:20050726T220000Z
URL:http://192.168.1.223/horde/kronolith/fb.php?c=testzh
FREEBUSY:20050627T060000Z/20050627T110000Z
FREEBUSY:20050627T130000Z/20050627T160000Z
FREEBUSY:20050704T060000Z/20050704T180000Z
...
END:VFREEBUSY
END:VCALENDAR
--- user = piffaret ---
BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//The Horde Project//Kronolith H3 (2.0.3)//EN
METHOD:PUBLISH
BEGIN:VFREEBUSY
ORGANIZER:MAILTO:piffaretti@elektro-material.ch
DTSTAMP:20050627T073633Z
DTSTART:20050626T220000Z
DTEND:20050726T220000Z
URL:http://192.168.1.223/horde/kronolith/fb.php?c=piffaret
FREEBUSY:20050627T070000Z/20050627T080000Z
FREEBUSY:20050627T100000Z/20050627T110000Z
...
END:VFREEBUSY
END:VCALENDAR
State ⇒ Feedback
include the day you're looking at? Etc. That log snippet you included
is meaningless...
Priority ⇒ 2. Medium
Type ⇒ Bug
Summary ⇒ [BUG] free/busy returns wrong values
Queue ⇒ Kronolith
New Attachment: edit_attendees.jpg
State ⇒ Unconfirmed
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"]