Tickets :: Comment on [#5146] Horde didn't works

* Your Email Address
* Spam protection	Enter the letters below: .___.__ ._..__..__ [__ [__) \| \| \|[__) \| [__)_\|_\|__\\|
Comment	> 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 ?
Attachment
Watch this ticket

Saved Queries