[Tickets #5146] Re: Horde didn't works

[bugs at bugs.horde.org]

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

Ticket URL: http://bugs.horde.org/ticket/?id=5146
-----------------------------------------------------------------------
 Ticket             | 5146
 Updated By         | simon at dedisoft.com
 Summary            | Horde didn't works
 Queue              | Horde Groupware Webmail Edition
 Type               | Bug
 State              | Feedback
 Priority           | 1. Low
 Owners             | 
-----------------------------------------------------------------------


simon at dedisoft.com (2007-03-23 12:44) wrote:

Just for your information, i've found two errors that I've solved:

Horde wants to create a table named "horde_datatree_seq". Typically, the
user used to connect to the sql didn't have the necessary rigths( only
datareader and datawriter). So I need to create the table myself
(including this on ths sql scripts ?)

On the table "horde_datatree_attributes", the field "attribute_value" is
TEXT. I need to change it to varchar(MAX) because i've these errors:

Mar 23 20:42:55 HORDE [error] [turba] DB Error: unknown error: SELECT
c.datatree_id, c.datatree_name FROM horde_datatree c LEFT JOIN
horde_datatree_attributes a1 ON a1.datatree_id = c.datatree_id WHERE
c.group_uid = 'horde.shares.turba' AND ((a1.attribute_name = 'owner' AND
a1.attribute_value = 'mymailaddress') OR (a1.attribute_name = 'perm_users'
AND a1.attribute_key = 'mymailaddress' AND (CASE WHEN
ISNUMERIC(a1.attribute_value) = 1 THEN (a1.attribute_value & 4) ELSE 3
END) = 4) OR (a1.attribute_name = 'perm_creator' AND (CASE WHEN
ISNUMERIC(a1.attribute_value) = 1 THEN (a1.attribute_value & 4) ELSE 3
END) = 4) OR (a1.attribute_name = 'perm_default' AND (CASE WHEN
ISNUMERIC(a1.attribute_value) = 1 THEN (a1.attribute_value & 4) ELSE 3
END) = 4))   GROUP BY c.datatree_id, c.datatree_name, c.datatree_order
ORDER BY c.datatree_order, c.datatree_name, c.datatree_id [nativecode=402
- The data types text and varchar are incompatible in the equal to
operator.] [on line 1123 of "xxxx\horde\lib\Horde\DataTree\sql.php"]
Mar 23 20:42:55 HORDE [error] [turba] DB Error: unknown error: SELECT
c.datatree_id, c.datatree_name FROM horde_datatree c LEFT JOIN
horde_datatree_attributes a1 ON a1.datatree_id = c.datatree_id WHERE
c.group_uid = 'horde.shares.turba' AND ((a1.attribute_name = 'owner' AND
a1.attribute_value = 'mymailaddress') OR (a1.attribute_name = 'perm_users'
AND a1.attribute_key = 'mymailaddress' AND (CASE WHEN
ISNUMERIC(a1.attribute_value) = 1 THEN (a1.attribute_value & 4) ELSE 3
END) = 4) OR (a1.attribute_name = 'perm_creator' AND (CASE WHEN
ISNUMERIC(a1.attribute_value) = 1 THEN (a1.attribute_value & 4) ELSE 3
END) = 4) OR (a1.attribute_name = 'perm_default' AND (CASE WHEN
ISNUMERIC(a1.attribute_value) = 1 THEN (a1.attribute_value & 4) ELSE 3
END) = 4))   GROUP BY c.datatree_id, c.datatree_name, c.datatree_order
ORDER BY c.datatree_order, c.datatree_name, c.datatree_id [nativecode=402
- The data types text and varchar are incompatible in the equal to
operator.] [on line 425 of "xxxx\horde\turba\lib\Turba.php"]
Mar 23 20:42:55 HORDE [error] [kronolith] DB Error: unknown error: SELECT
c.datatree_id, c.datatree_name FROM horde_datatree c LEFT JOIN
horde_datatree_attributes a1 ON a1.datatree_id = c.datatree_id WHERE
c.group_uid = 'horde.shares.kronolith' AND ((a1.attribute_name = 'owner'
AND a1.attribute_value = 'mymailaddress') OR (a1.attribute_name =
'perm_users' AND a1.attribute_key = 'mymailaddress' AND (CASE WHEN
ISNUMERIC(a1.attribute_value) = 1 THEN (a1.attribute_value & 2) ELSE 1
END) = 2) OR (a1.attribute_name = 'perm_creator' AND (CASE WHEN
ISNUMERIC(a1.attribute_value) = 1 THEN (a1.attribute_value & 2) ELSE 1
END) = 2) OR (a1.attribute_name = 'perm_default' AND (CASE WHEN
ISNUMERIC(a1.attribute_value) = 1 THEN (a1.attribute_value & 2) ELSE 1
END) = 2))   GROUP BY c.datatree_id, c.datatree_name, c.datatree_order
ORDER BY c.datatree_order, c.datatree_name, c.datatree_id [nativecode=402
- The data types text and varchar are incompatible in the equal to
operator.] [on line 1123 of "xxxx\horde\lib\Horde\DataTree\sql.php"]
Mar 23 20:42:55 HORDE [error] [kronolith] DB Error: unknown error: SELECT
c.datatree_id, c.datatree_name FROM horde_datatree c LEFT JOIN
horde_datatree_attributes a1 ON a1.datatree_id = c.datatree_id WHERE
c.group_uid = 'horde.shares.kronolith' AND ((a1.attribute_name = 'owner'
AND a1.attribute_value = 'mymailaddress') OR (a1.attribute_name =
'perm_users' AND a1.attribute_key = 'mymailaddress' AND (CASE WHEN
ISNUMERIC(a1.attribute_value) = 1 THEN (a1.attribute_value & 2) ELSE 1
END) = 2) OR (a1.attribute_name = 'perm_creator' AND (CASE WHEN
ISNUMERIC(a1.attribute_value) = 1 THEN (a1.attribute_value & 2) ELSE 1
END) = 2) OR (a1.attribute_name = 'perm_default' AND (CASE WHEN
ISNUMERIC(a1.attribute_value) = 1 THEN (a1.attribute_value & 2) ELSE 1
END) = 2))   GROUP BY c.datatree_id, c.datatree_name, c.datatree_order
ORDER BY c.datatree_order, c.datatree_name, c.datatree_id [nativecode=402
- The data types text and varchar are incompatible in the equal to
operator.] [on line 801 of "xxxx\horde\kronolith\lib\Kronolith.php"]
Mar 23 20:42:55 HORDE [error] [kronolith] DB Error: unknown error: 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 = 'owner'
AND a1.attribute_value = 'mymailaddress') OR (a1.attribute_name =
'perm_users' AND a1.attribute_key = 'mymailaddress' AND (CASE WHEN
ISNUMERIC(a1.attribute_value) = 1 THEN (a1.attribute_value & 2) ELSE 1
END) = 2) OR (a1.attribute_name = 'perm_creator' AND (CASE WHEN
ISNUMERIC(a1.attribute_value) = 1 THEN (a1.attribute_value & 2) ELSE 1
END) = 2) OR (a1.attribute_name = 'perm_default' AND (CASE WHEN
ISNUMERIC(a1.attribute_value) = 1 THEN (a1.attribute_value & 2) ELSE 1
END) = 2)) AND a2.attribute_name = 'owner' AND a2.attribute_value =
'mymailaddress')  AND a1.datatree_id = a2.datatree_id GROUP BY
c.datatree_id, c.datatree_name, c.datatree_order ORDER BY
c.datatree_order, c.datatree_name, c.datatree_id [nativecode=402 - The
data types text and varchar are incompatible in the equal to operator.]
[on line 1123 of "xxxx\horde\lib\Horde\DataTree\sql.php"]
Mar 23 20:42:55 HORDE [error] [kronolith] DB Error: unknown error: 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 = 'owner'
AND a1.attribute_value = 'mymailaddress') OR (a1.attribute_name =
'perm_users' AND a1.attribute_key = 'mymailaddress' AND (CASE WHEN
ISNUMERIC(a1.attribute_value) = 1 THEN (a1.attribute_value & 2) ELSE 1
END) = 2) OR (a1.attribute_name = 'perm_creator' AND (CASE WHEN
ISNUMERIC(a1.attribute_value) = 1 THEN (a1.attribute_value & 2) ELSE 1
END) = 2) OR (a1.attribute_name = 'perm_default' AND (CASE WHEN
ISNUMERIC(a1.attribute_value) = 1 THEN (a1.attribute_value & 2) ELSE 1
END) = 2)) AND a2.attribute_name = 'owner' AND a2.attribute_value =
'mymailaddress')  AND a1.datatree_id = a2.datatree_id GROUP BY
c.datatree_id, c.datatree_name, c.datatree_order ORDER BY
c.datatree_order, c.datatree_name, c.datatree_id [nativecode=402 - The
data types text and varchar are incompatible in the equal to operator.]
[on line 801 of "xxxx\horde\kronolith\lib\Kronolith.php"]

Is this normal ?