[kronolith] calendar not displaying events - sql syntax error

Brian Bonnough brian.bonnough at ce.gatech.edu
Fri Jun 20 08:00:54 PDT 2003


I'm using the CVS HEAD version of Horde, Kronolith, IMP, Nag, and Mnemo. The
calendar does not display events (although it does display tasks).

I'm using a postgres database (7.2.3) which does get populated with calendar
event information.  Identites are locked to only allow the Default Identity
to be used.

The following error message occurs in the log file associated with
kronolith, mnemo, and nag:

Jun 20 10:34:54 HORDE [error] [kronolith] DB Error: syntax error: SELECT
DISTINCT a.category_id, c.category_name FROM horde_category_attributes a
LEFT JOIN horde_categories c ON a.category_id = c.category_id WHERE
c.group_uid = 'horde.shares.kronolith' AND ((attribute_name = 'owner' AND
attribute_value = 'bb198') OR (attribute_name = 'perm_users' AND
attribute_key = 'bb198' AND CASE WHEN CAST(attribute_value AS VARCHAR)
SIMILAR TO '(-[0-9]+|[0-9]+)' THEN (CAST(attribute_value AS INTEGER) & 8)
<> 0 ELSE FALSE END) OR (attribute_name = 'perm_default' AND CASE WHEN
CAST(attribute_value AS VARCHAR) SIMILAR TO '(-[0-9]+|[0-9]+)' THEN
(CAST(attribute_value AS INTEGER) & 8) <> 0 ELSE FALSE END))
[nativecode=ERROR:  parser: parse error at or near "similar"

Any help tracking the cause of this problem down is greatly appreciated.

--
Brian Bonnough, CISSP
System Support Specialist II
Civil and Environmental Engineering
Georgia Institute of Technology


More information about the kronolith mailing list