[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