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

[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.

Notice: Undefined index: 10 in /home/www/mail/horde-
cvs/horde/horde/lib/Category.php on line 441

Notice: Undefined index: 10 in /home/www/mail/horde-
cvs/horde/horde/lib/Category.php on line 441

Notice: Undefined index: 19 in /home/www/mail/horde-
cvs/horde/horde/lib/Category.php on line 441

Notice: Undefined index: 19 in /home/www/mail/horde-
cvs/horde/horde/lib/Category.php on line 441

Notice: Undefined index: 10 in /home/www/mail/horde-
cvs/horde/horde/lib/Category.php on line 441

Notice: Undefined index: 19 in /home/www/mail/horde-
cvs/horde/horde/lib/Category.php on line 441

Notice: argument passed to unserialize() is not an string 
in /home/www/mail/horde-cvs/horde/horde/kronolith/lib/base.php on line 85

Notice: Undefined index: 10 in /home/www/mail/horde-
cvs/horde/horde/lib/Category.php on line 441

Notice: Undefined index: 10 in /home/www/mail/horde-
cvs/horde/horde/lib/Category.php on line 441

Notice: Undefined index: 19 in /home/www/mail/horde-
cvs/horde/horde/lib/Category.php on line 441

Notice: Undefined index: 19 in /home/www/mail/horde-
cvs/horde/horde/lib/Category.php on line 441

Notice: Undefined index: 10 in /home/www/mail/horde-
cvs/horde/horde/lib/Category.php on line 441

Notice: Undefined index: 19 in /home/www/mail/horde-
cvs/horde/horde/lib/Category.php on line 441

Warning: Invalid argument supplied for foreach() in /home/www/mail/horde-
cvs/horde/horde/kronolith/lib/Kronolith.php on line 297


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