Tickets :: Comment on [#8608] Wrong datatype "?" to "unsigned bigint" in datatree. \lib\Horde\DataTree\sql.php

* Your Email Address
* Spam protection	Enter the letters below: . ,.___. ..__.. . \./ [__ \| \|\| \|\|_/ \| \| \|/\\|\|__\|\| \
Comment	> I found something interesting! When I change this statement: > > > > 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 = 'horde.shares.kronolith') AND > > (a1.attribute_name = 'perm_groups' AND a1.attribute_key IN ('1', '2') > > AND (a1.attribute_value & 2) = 2) AND a2.attribute_name = 'name' > > GROUP BY c.datatree_id, c.datatree_name, c.datatree_order, > a2.attribute_value ORDER BY a2.attribute_value ASC > > > > to this statement > > > > 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 > > (a1.attribute_name = 'perm_groups' AND a1.attribute_key IN ('1', '2') > > AND (a1.attribute_value & 2) = 2) AND a2.attribute_name = 'name' > > GROUP BY c.datatree_id, c.datatree_name, c.datatree_order, > a2.attribute_value ORDER BY a2.attribute_value ASC > > > > the execution works and returns the values: > > datatree_id = 2 and datatree_name = 'root' > > > > if I put "... where (c.group_uid = 'horde.shares.kronolith') AND ..." > back in, the same error appeares... See attachment > 'hordeStatements.JPG'
Attachment
Watch this ticket

Saved Queries