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

[bugs at horde.org]

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: http://bugs.horde.org/ticket/8608
------------------------------------------------------------------------------
  Ticket             | 8608
  Updated By         | c-master at freenet.de
  Summary            | Wrong datatype "?" to "unsigned bigint" in datatree.
                     | \lib\Horde\DataTree\sql.php
  Queue              | Horde Framework Packages
  Version            | FRAMEWORK_3
  Type               | Bug
  State              | Feedback
  Priority           | 2. Medium
  Milestone          |
  Patch              |
  Owners             |
+New Attachment     | hordeStatements.JPG
------------------------------------------------------------------------------


c-master at freenet.de (2009-10-01 03:59) wrote:

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'