[kronolith] Error in SQL query (Or my table structure?)

[Mike Cochrane]

> ----- Message from mccallum@forge.com.au ---------
> 
> Hi!!
> 
> I'm running the latest CVS version of everything, and I'm getting an error as
> specified below. This is across the top of the Horde Summary Page above the
> top
> menu bar:
> 
> The error also appears across the top of the Calendar page with the same
> error.
> (I'm guessing the "SELECT 0" SQL is incorrectly generated.

We may not need it, but it's still correct SQL and does work. What you didn't
tell us was what database you are using? I don't have a problem with the code on
mysql.

- Mike :-)

> And I get this in the Log file :
> 
> Sep 27 13:47:42 HORDE [debug] [kronolith] SELECT 0, category_id,
> category_parents FROM horde_categories WHERE category_name = 'kronolith' AND
> group_uid = 'horde.shares' [on line 151 of "/home/www/mail/horde-
> cvs/horde/horde/lib/Category/sql.php"]
> 
> Sep 27 13:47:42 HORDE [debug] [kronolith] SELECT category_id, category_name,
> category_parents FROM horde_categories WHERE (category_parents LIKE ':1%' OR
> category_id = 1) AND group_uid = 'horde.shares' [on line 181
> of "/home/www/mail/horde-cvs/horde/horde/lib/Category/sql.php"]
> 
> Sep 27 13:47:42 HORDE [debug] [kronolith] SELECT 0, category_id,
> category_parents FROM horde_categories WHERE category_name = 'kronolith' AND
> group_uid = 'horde.groups' [on line 151 of "/home/www/mail/horde-
> cvs/horde/horde/lib/Category/sql.php"]
> 
> Sep 27 13:47:42 HORDE [debug] [kronolith] SELECT category_id, category_name,
> category_parents FROM horde_categories WHERE (category_parents LIKE ':3%' OR
> category_id = 3) AND group_uid = 'horde.groups' [on line 181
> of "/home/www/mail/horde-cvs/horde/horde/lib/Category/sql.php"]
> 
> Sep 27 13:47:42 HORDE [debug] [kronolith] SELECT 0, category_id,
> category_parents FROM horde_categories WHERE category_name = 'kronolith' AND
> group_uid = 'horde.perms' [on line 151 of "/home/www/mail/horde-
> cvs/horde/horde/lib/Category/sql.php"]
> 
> Sep 27 13:47:42 HORDE [debug] [kronolith] SELECT category_id, category_name,
> category_parents FROM horde_categories WHERE (category_parents LIKE ':5%' OR
> category_id = 5) AND group_uid = 'horde.perms' [on line 181
> of "/home/www/mail/horde-cvs/horde/horde/lib/Category/sql.php"]
> 
> Sep 27 13:47:42 HORDE [debug] [kronolith] SELECT 0, category_id,
> category_parents FROM horde_categories WHERE category_name = 'kronolith' AND
> group_uid = 'horde.shares' [on line 151 of "/home/www/mail/horde-
> cvs/horde/horde/lib/Category/sql.php"]
> 
> Sep 27 13:47:42 HORDE [debug] [kronolith] SELECT category_id, category_name,
> category_parents FROM horde_categories WHERE (category_parents LIKE ':1%' OR
> category_id = 1) AND group_uid = 'horde.shares' [on line 181
> of "/home/www/mail/horde-cvs/horde/horde/lib/Category/sql.php"]
> 
> Sep 27 13:47:42 HORDE [debug] [kronolith] SELECT category_data FROM
> horde_categories WHERE category_id = 9 AND group_uid = 'horde.shares' [on
> line
> 404 of "/home/www/mail/horde-cvs/horde/horde/lib/Category/sql.php"]
> 
> 
> 
> 
> Platform Info
> =================
> Red Hat 7.3
> Apache/1.3.23 (Unix)  (Red-Hat/Linux) mod_ssl/2.8.7 OpenSSL/0.9.6b DAV/1.0.3
> PHP/4.2.2 mod_perl/1.26 mod_jk/1.1.0
>
> ----- End message from mccallum@forge.com.au -----