[horde] Re: 'DB Error: mismatch' when adding user groups

[Christian Stadler]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Chuck Hagenbuch schrieb:
> Quoting Christian Stadler <webmaster at ragnarokonline.de>:
>>I'm getting the following error, when I'm creating a new user group:
>>'newgroupname' was not created: DB Error: mismatch.
> And what's the full error message from Horde's logfile?

No error-message, but the following:

Mar 23 06:38:12 HORDE [debug] [horde] SQL Query by
DataTree_sql::_buildLoadQuery(): SELECT datatree_id, datatree_parents
FROM horde_datatree WHERE datatree_name = 'test' AND group_uid =
'horde.groups' ORDER BY datatree_id [on line 175 of
"/path/to/htdocs/lib/Horde/DataTree/sql.php"]
Mar 23 06:38:12 HORDE [debug] [horde] SQL Query by DataTree_sql::add():
INSERT INTO horde_datatree (datatree_id, group_uid, datatree_name,
datatree_order, datatree_data, user_uid, datatree_serialized,
datatree_parents) VALUES (30, 'horde.groups', 'test', NULL, '',
'Administrator', 0, '') [on line 418 of
"/path/to/htdocs/lib/Horde/DataTree/sql.php"]
Mar 23 06:38:12 HORDE [debug] [horde] SQL Query by
DataTree_sql::updateData(): UPDATE horde_datatree SET datatree_data =
NULL WHERE datatree_id = 30 [on line 1213 of
"/var/www/web04/htdocs/lib/Horde/DataTree/sql.php"]
Mar 23 06:38:12 HORDE [debug] [horde] SQL Query by
DataTree_sql::updateData(): DELETE FROM horde_datatree_attributes WHERE
datatree_id = 30 [on line 1224 of
"/path/to/htdocs/lib/Horde/DataTree/sql.php"]
Mar 23 06:38:12 HORDE [debug] [horde] SQL Query by
DataTree_sql::updateData(): INSERT INTO horde_datatree_attributes
(datatree_id, attribute_name, attribute_key, attribute_value) VALUES
(30, 'email', '', ?) [on line 1244 of
"/path/to/htdocs/lib/Horde/DataTree/sql.php"]
Mar 23 06:38:12 HORDE [debug] [horde] SQL Query by
DataTree_sql::_load(): SELECT datatree_id, datatree_name,
datatree_parents, datatree_order FROM horde_datatree WHERE group_uid =
'horde.groups' [on line 113 of "/path/to/htdocs/lib/Horde/DataTree/sql.php"]

Regards,
  Christian Stadler
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.0 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFCQQGs9250Hcbf/3IRAj9qAJ9yAorW76t0vlZjBo3bO7zBymw9CgCfekAH
aapQ0g5U4F0aDxH+O5Q1Asc=
=1qy5
-----END PGP SIGNATURE-----