[dev] Re: [cvs] commit: framework/DataTree/DataTree sql.php

[Chuck Hagenbuch]

Quoting Ben Chavet <ben at horde.org>:

> from horde's log:
>
> [trean] DB Error: mismatch: SELECT c.datatree_id, c.datatree_name FROM
> horde_datatree c LEFT JOIN horde_datatree_attributes a1 ON
> a1.datatree_id = c.datatree_id LEFT JOIN horde_datatree_attributes a2
> ON a2.datatree_id = c.datatree_id WHERE c.group_uid = AND
> (((a1.attribute_name = AND a1.attribute_value = ) OR (a1.attribute_name
> = AND a1.attribute_key = AND CASE WHEN CAST(a1.attribute_value AS
> VARCHAR) ~ '^-?[0-9]+$' THEN (CAST(a1.attribute_value AS INTEGER) & 0)
> <> 0 ELSE FALSE END) OR (a1.attribute_name = AND CASE WHEN
> CAST(a1.attribute_value AS VARCHAR) ~ '^-?[0-9]+$' THEN
> (CAST(a1.attribute_value AS INTEGER) & 0) <> 0 ELSE FALSE END) OR
> (a1.attribute_name = AND CASE WHEN CAST(a1.attribute_value AS VARCHAR)
> ~ '^-?[0-9]+$' THEN (CAST(a1.attribute_value AS INTEGER) & 0) <> 0 ELSE
> FALSE END)) AND a2.attribute_name = AND a2.attribute_value = ) AND
> a1.attribute_name = a2.attribute_name GROUP BY c.datatree_id,
> c.datatree_name, c.datatree_order ORDER BY c.datatree_order,
> c.datatree_name, c.datatree_id [DB Error: mismatch] [on line 1101 of
> "/home/ben/pear/Horde/DataTree/sql.php"]

This should be fixed now.

-chuck

-- 
"But she goes not abroad in search of monsters to destroy." - John 
Quincy Adams