[horde] Please help me, my Kronolith calendars are missing!

Paul Wagland paul at kungfoocoder.org
Wed Sep 1 15:03:12 PDT 2004


As of a few days ago, all of my calendars in Kronolith have just broken. All of
the pages that try to reference my calendars say something like:
---
Notice: Undefined index: paul in /usr/local/share/horde/kronolith/lib/Driver.php
on line 1008

Fatal error: Call to a member function on a non-object in
/usr/local/share/horde/kronolith/lib/Driver.php on line 1009
---
(Taken from the horde overview page)

At first I just figured that this was the risk of living on the edge...
sometimes you get cut, but this has been been going for a few days now... so...

When I do a "select * from kronolith_events" I can see all of my events, and
some of them have a calendar_id of 'paul'. I have no entries in my
kronolith_storage table.

Now, I understand why line 1008 of Driver.php fails, it is because
$GLOBALS['all_calendars'] does not have the 'paul' value. It doesn't seem to
have any values. In fact, when it tries to get the list of calendars from the
database I get this error:

Sep 02 00:00:56 HORDE [error] [kronolith] DB Error: unknown error: SELECT
a1.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 = 'horde.shares.kronolith' AND ((a1.attribute_name = 'owner' AND
a1.attribute_value = 'paul') OR (a1.attribute_name = 'perm_users' AND
a1.attribute_key = 'paul' AND CASE WHEN CAST(a1.attribute_value AS VARCHAR) ~
'^-?[0-9]+$' THEN (CAST(a1.attribute_value AS INTEGER) & 2) <> 0 ELSE FALSE
END) OR (a1.attribute_name = 'perm_creator' AND CASE WHEN
CAST(a1.attribute_value AS VARCHAR) ~ '^-?[0-9]+$' THEN
(CAST(a1.attribute_value AS INTEGER) & 2) <> 0 ELSE FALSE END) OR
(a1.attribute_name = 'perm_default' AND CASE WHEN CAST(a1.attribute_value AS
VARCHAR) ~ '^-?[0-9]+$' THEN (CAST(a1.attribute_value AS INTEGER) & 2) <> 0
ELSE FALSE END))  AND a1.attribute_name = a1.attribute_name GROUP BY
a1.datatree_id ORDER BY c.datatree_order, c.datatree_name, c.datatree_id
[nativecode=ERROR:  column "c.datatree_name" must appear in the GROUP BY clause
or be used in an aggregate function] [on line 906 of
"/usr/local/share/horde/kronolith/lib/Kronolith.php"]



Does anyone know how I can fix this?

Thanks in advance,
Paul



More information about the horde mailing list