[whups] DB Error: constraint violation
Chris Collins
z0cool at gmail.com
Fri Apr 22 01:50:56 PDT 2005
Hello
I am having some troubles restoring my whups configuration after a reinstall
I am hoping somebody might be able to shed some light.
I am getting the following error when I try and access my tickets stored in
the sql database. I am running the latest cvs release.
"There was an error listing your assigned tickets: DB Error: constraint
violation"
Horde.log show the following.
RDE [debug] [whups] SQL Query by Whups_Driver_sql::getUserSearches(): SELECT
search_name, search_getvars FROM whups_users_searches WHERE user_uid = ?
ORDER BY search_name [on line 1665 of
"/usr/local/www/horde/whups/lib/Driver/sql.php"]
Apr 22 04:29:06 HORDE [debug] [whups] Hook _horde_hook_share_init in
application horde not called. [on line 1418 of
"/usr/local/www/horde/lib/Horde.php"]
Apr 22 04:29:06 HORDE [debug] [whups] SQL Query by
DataTree_sql::getByAttributes(): 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 = ? AND ((a1.attribute_name = ? AND
a1.attribute_value = ?) OR (a1.attribute_name = ? AND a1.attribute_key = ?
AND a1.attribute_value \& ?) OR (a1.attribute_name = ? AND
a1.attribute_value \& ?) OR (a1.attribute_name = ? AND a1.attribute_value \&
?) OR (a1.attribute_name = ? AND a1.attribute_key IN (?) AND
a1.attribute_value \& ?)) GROUP BY c.datatree_id, c.datatree_name,
c.datatree_order ORDER BY c.datatree_order, c.datatree_name,
c.datatree_id[on line 979 of
"/usr/local/www/horde/lib/Horde/DataTree/sql.php"]
Thanks....
More information about the whups
mailing list