DB Error: constraint violation
Chris Collins <[email protected]> Fri, 22 Apr 2005 04:50:56 -0400
| Newsgroups | gmane.comp.horde.whups |
|---|---|
| Message-ID | <[email protected]> |
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.... -- Whups mailing list - Join the hunt: http://horde.org/bounties/#whups Frequently Asked Questions: http://horde.org/faq/ To unsubscribe, mail: [email protected]