[kronolith] Bad SQL Lookup for Shared Calendars?

[Patrick Lahni]

Hello all,

I'm trying to setup a shared calendar.  Preferences/Datatree are all working
fine via mySQL.  I go into 'My Calendars' and create a new calendar, no
problem.  However, when I go to select to mess with the permissions, another
window opens and says: "054e9f68e16a900dae36194dd211ce27 not found.".  The
calendar was named "PAB".

Investigating further by turning on DEBUG logging, I got the following from
horde.log:

Jul 12 12:50:08 HORDE [debug] [horde] Hook _horde_hook_share_init in application
horde not called. [on line 1378 of
"/home/.okemo/cykotix/precisionautobody.cc/webmail/lib/Horde.php"]
Jul 12 12:50:08 HORDE [debug] [horde] SQL Query by
DataTree_sql::_buildLoadQuery(): SELECT datatree_id, datatree_parents FROM
horde_datatree WHERE datatree_name = ? AND group_uid = ? ORDER BY datatree_id
[on line 179 of
"/home/.okemo/cykotix/precisionautobody.cc/webmail/lib/Horde/DataTree/sql.php"]
Jul 12 12:50:08 HORDE [debug] [horde] SQL Query by
DataTree_sql::_buildLoadQuery(): SELECT datatree_id, datatree_parents FROM
horde_datatree WHERE datatree_name = ? AND group_uid = ? ORDER BY datatree_id
[on line 179 of
"/home/.okemo/cykotix/precisionautobody.cc/webmail/lib/Horde/DataTree/sql.php"]
Jul 12 12:50:08 HORDE [debug] [horde] 054e9f68e16a900dae36194dd211ce27 not
found. [on line 155 of
"/home/.okemo/cykotix/precisionautobody.cc/webmail/lib/Horde/Notification.php"]
Jul 12 12:50:08 HORDE [debug] [horde] SQL Query by DataTree_sql::_load(): SELECT
datatree_id, datatree_name, datatree_parents, datatree_order FROM horde_datatree
WHERE group_uid = 'horde.groups' [on line 117 of
"/home/.okemo/cykotix/precisionautobody.cc/webmail/lib/Horde/DataTree/sql.php"]

It seems to be breaking due to the line 179.  Here is the SQL lookup showing
that 054e9f68e168... exists:

mysql> select datatree_id, group_uid, datatree_name  from horde_datatree where
datatree_name = '054e9f68e16a900dae36194dd211ce27';
+-------------+------------------------+----------------------------------+
| datatree_id | group_uid              | datatree_name                    |
+-------------+------------------------+----------------------------------+
|          12 | horde.shares.kronolith | 054e9f68e16a900dae36194dd211ce27 |
+-------------+------------------------+----------------------------------+

but on line 179 of sql.php, it is looking for '?' in datatree_name and
group_uid.  So is this an issue on my end or a bug?  This was all just
installed fresh using the latest stable packages availble on the horde ftp
today.

TIA!

Patrick

----------------------------------------------------------------
This message was sent using IMP, the Internet Messaging Program.