Tickets :: [#714] Can't add ticket to whups queue, unknown DB error

6.0.0-beta1

8/10/25

Summary	Can't add ticket to whups queue, unknown DB error
Queue	Whups
Type	Bug
State	Not A Bug
Priority	2. Medium
Owners
Requester	rod (at) morison (dot) biz
Created	10/21/2004 (7598 days ago)
Due
Updated	10/21/2004 (7598 days ago)
Assigned
Resolved	10/21/2004 (7598 days ago)
Github Issue Link
Github Pull Request
Milestone
Patch	No

10/21/2004 11:12:01 PM	Chuck Hagenbuch	Comment #4	Reply to this comment
all of the errors are right there in your admin logs. the information in them can contain passwords, which is why only the summary is shown on the screen.

10/21/2004 11:10:53 PM	Chuck Hagenbuch	Comment #3 State ⇒ Not A Bug	Reply to this comment
This is why: Oct 21 15:44:17 HORDE [error] [whups] DB Error: unknown error: UPDATE whups_tickets_seq SET id=LAST_INSERT_ID(id+1) [nativecode=1142 ** update command denied to user: 'horde@localhost' for table 'whups_tickets_seq'] [on line 184 of "/srv/www/vhosts/morison.biz/horde.cvs/whups/lib/Driver/sql.php"] You have db permission problems.

10/21/2004 11:08:41 PM	rod (at) morison (dot) biz	Comment #2	Reply to this comment
Same error "There was an error creating the queue: DB Error: unknown error" when trying to create a new queue. I expect I can't create _anything_ in whups right now. When I have time (next week) I'll wipe the whups tables and recreate them. At the least, this bug calls for a better error message! Rod

10/21/2004 10:45:42 PM	rod (at) morison (dot) biz	Comment #1 State ⇒ Unconfirmed Priority ⇒ 2. Medium Type ⇒ Bug Summary ⇒ Can't add ticket to whups queue, unknown DB error Queue ⇒ Whups	Reply to this comment
Can't add ticket to whups queue, only error is "Adding your ticket failed: DB Error: unknown error." Here's verbose from horde.log... Oct 21 15:44:11 HORDE [debug] [whups] SQL Query by Whups_Driver_sql::getQueues(): SELECT queue_id, queue_name FROM whups_queues ORDER BY queue_name [on line 869 of "/srv/www/vhosts/morison.biz/horde.cvs/whups/lib/Driver/sql.php"] Oct 21 15:44:11 HORDE [debug] [whups] SQL Query by Whups_Driver_sql::getTypes(): SELECT t.type_id, t.type_name FROM whups_types t, whups_types_queues tm WHERE tm.queue_id = 1 AND tm.type_id = t.type_id ORDER BY t.type_name [on line 1181 of "/srv/www/vhosts/morison.biz/horde.cvs/whups/lib/Driver/sql.php"] Oct 21 15:44:11 HORDE [debug] [whups] SQL Query by Whups_Driver_sql::getQueue(): SELECT queue_id, queue_name, queue_description, queue_subjectlist, queue_versioned FROM whups_queues WHERE queue_id = 1 [on line 849 of "/srv/www/vhosts/morison.biz/horde.cvs/whups/lib/Driver/sql.php"] Oct 21 15:44:11 HORDE [debug] [whups] SQL Query by Whups_Driver_sql::getVersions(): SELECT version_id, version_name, version_description FROM whups_versions WHERE queue_id = 1 ORDER BY version_name DESC [on line 1483 of "/srv/www/vhosts/morison.biz/horde.cvs/whups/lib/Driver/sql.php"] Oct 21 15:44:11 HORDE [debug] [whups] SQL Query by Whups_Driver_sql::getQueue(): SELECT queue_id, queue_name, queue_description, queue_subjectlist, queue_versioned FROM whups_queues WHERE queue_id = 1 [on line 849 of "/srv/www/vhosts/morison.biz/horde.cvs/whups/lib/Driver/sql.php"] Oct 21 15:44:11 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 = 'horde.groups' AND (a1.attribute_name = 'user' AND a1.attribute_key = 'rod') AND a1.attribute_name = a1.attribute_name GROUP BY c.datatree_id, c.datatree_name, c.datatree_order ORDER BY c.datatree_order, c.datatree_name, c.datatree_id [on line 958 of "/usr/share/php/Horde/DataTree/sql.php"] Oct 21 15:44:11 HORDE [debug] [whups] SQL Query by Whups_Driver_sql::getQueueUsers(): SELECT user_uid AS u1, user_uid AS u2 FROM whups_queues_users WHERE queue_id = 1 ORDER BY u1 [on line 1094 of "/srv/www/vhosts/morison.biz/horde.cvs/whups/lib/Driver/sql.php"] Oct 21 15:44:11 HORDE [debug] [whups] SQL Query by Prefs_sql::retrieve(): SELECT pref_scope, pref_name, pref_value FROM horde_prefs WHERE pref_uid = 'testy' AND (pref_scope = 'whups' OR pref_scope = 'horde') ORDER BY pref_scope [on line 147 of "/usr/share/php/Horde/Prefs/sql.php"] Oct 21 15:44:11 HORDE [debug] [whups] SQL Query by Whups_Driver_sql::getOwners(): SELECT ticket_owner, ticket_owner FROM whups_ticket_owners WHERE ticket_id = 0 [on line 1912 of "/srv/www/vhosts/morison.biz/horde.cvs/whups/lib/Driver/sql.php"] Oct 21 15:44:12 HORDE [debug] [whups] SQL Query by Whups_Driver_sql::getQueues(): SELECT queue_id, queue_name FROM whups_queues ORDER BY queue_name [on line 869 of "/srv/www/vhosts/morison.biz/horde.cvs/whups/lib/Driver/sql.php"] Oct 21 15:44:12 HORDE [debug] [whups] SQL Query by Whups_Driver_sql::getTypes(): SELECT t.type_id, t.type_name FROM whups_types t, whups_types_queues tm WHERE tm.queue_id = '1' AND tm.type_id = t.type_id ORDER BY t.type_name [on line 1181 of "/srv/www/vhosts/morison.biz/horde.cvs/whups/lib/Driver/sql.php"] Oct 21 15:44:12 HORDE [debug] [whups] SQL Query by Whups_Driver_sql::getQueue(): SELECT queue_id, queue_name, queue_description, queue_subjectlist, queue_versioned FROM whups_queues WHERE queue_id = 1 [on line 849 of "/srv/www/vhosts/morison.biz/horde.cvs/whups/lib/Driver/sql.php"] Oct 21 15:44:12 HORDE [debug] [whups] SQL Query by Whups_Driver_sql::getVersions(): SELECT version_id, version_name, version_description FROM whups_versions WHERE queue_id = 1 ORDER BY version_name DESC [on line 1483 of "/srv/www/vhosts/morison.biz/horde.cvs/whups/lib/Driver/sql.php"] Oct 21 15:44:12 HORDE [debug] [whups] SQL Query by Whups_Driver_sql::getStates(): SELECT state_id, state_name FROM whups_states WHERE type_id = 1 AND (state_category = 'unconfirmed') ORDER BY state_category, state_name [on line 1292 of "/srv/www/vhosts/morison.biz/horde.cvs/whups/lib/Driver/sql.php"] Oct 21 15:44:12 HORDE [debug] [whups] SQL Query by Whups_Driver_sql::getQueue(): SELECT queue_id, queue_name, queue_description, queue_subjectlist, queue_versioned FROM whups_queues WHERE queue_id = 1 [on line 849 of "/srv/www/vhosts/morison.biz/horde.cvs/whups/lib/Driver/sql.php"] Oct 21 15:44:12 HORDE [debug] [whups] SQL Query by Whups_Driver_sql::getStates(): SELECT state_id, state_name FROM whups_states WHERE type_id = 1 AND (state_category = 'new' OR state_category = 'assigned') ORDER BY state_category, state_name [on line 1292 of "/srv/www/vhosts/morison.biz/horde.cvs/whups/lib/Driver/sql.php"] Oct 21 15:44:12 HORDE [debug] [whups] SQL Query by Whups_Driver_sql::getPriorities(): SELECT priority_id, priority_name FROM whups_priorities WHERE type_id = 1 ORDER BY priority_name [on line 1400 of "/srv/www/vhosts/morison.biz/horde.cvs/whups/lib/Driver/sql.php"] Oct 21 15:44:12 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 = 'horde.groups' AND (a1.attribute_name = 'user' AND a1.attribute_key = 'rod') AND a1.attribute_name = a1.attribute_name GROUP BY c.datatree_id, c.datatree_name, c.datatree_order ORDER BY c.datatree_order, c.datatree_name, c.datatree_id [on line 958 of "/usr/share/php/Horde/DataTree/sql.php"] Oct 21 15:44:12 HORDE [debug] [whups] SQL Query by Whups_Driver_sql::getQueueUsers(): SELECT user_uid AS u1, user_uid AS u2 FROM whups_queues_users WHERE queue_id = '1' ORDER BY u1 [on line 1094 of "/srv/www/vhosts/morison.biz/horde.cvs/whups/lib/Driver/sql.php"] Oct 21 15:44:12 HORDE [debug] [whups] SQL Query by Prefs_sql::retrieve(): SELECT pref_scope, pref_name, pref_value FROM horde_prefs WHERE pref_uid = 'testy' AND (pref_scope = 'whups' OR pref_scope = 'horde') ORDER BY pref_scope [on line 147 of "/usr/share/php/Horde/Prefs/sql.php"] Oct 21 15:44:12 HORDE [debug] [whups] SQL Query by Whups_Driver_sql::getOwners(): SELECT ticket_owner, ticket_owner FROM whups_ticket_owners WHERE ticket_id = 0 [on line 1912 of "/srv/www/vhosts/morison.biz/horde.cvs/whups/lib/Driver/sql.php"] Oct 21 15:44:17 HORDE [debug] [whups] SQL Query by Whups_Driver_sql::getQueues(): SELECT queue_id, queue_name FROM whups_queues ORDER BY queue_name [on line 869 of "/srv/www/vhosts/morison.biz/horde.cvs/whups/lib/Driver/sql.php"] Oct 21 15:44:17 HORDE [debug] [whups] SQL Query by Whups_Driver_sql::getTypes(): SELECT t.type_id, t.type_name FROM whups_types t, whups_types_queues tm WHERE tm.queue_id = '1' AND tm.type_id = t.type_id ORDER BY t.type_name [on line 1181 of "/srv/www/vhosts/morison.biz/horde.cvs/whups/lib/Driver/sql.php"] Oct 21 15:44:17 HORDE [debug] [whups] SQL Query by Whups_Driver_sql::getQueue(): SELECT queue_id, queue_name, queue_description, queue_subjectlist, queue_versioned FROM whups_queues WHERE queue_id = 1 [on line 849 of "/srv/www/vhosts/morison.biz/horde.cvs/whups/lib/Driver/sql.php"] Oct 21 15:44:17 HORDE [debug] [whups] SQL Query by Whups_Driver_sql::getVersions(): SELECT version_id, version_name, version_description FROM whups_versions WHERE queue_id = 1 ORDER BY version_name DESC [on line 1483 of "/srv/www/vhosts/morison.biz/horde.cvs/whups/lib/Driver/sql.php"] Oct 21 15:44:17 HORDE [debug] [whups] SQL Query by Whups_Driver_sql::getStates(): SELECT state_id, state_name FROM whups_states WHERE type_id = 1 AND (state_category = 'unconfirmed') ORDER BY state_category, state_name [on line 1292 of "/srv/www/vhosts/morison.biz/horde.cvs/whups/lib/Driver/sql.php"] Oct 21 15:44:17 HORDE [debug] [whups] SQL Query by Whups_Driver_sql::getQueue(): SELECT queue_id, queue_name, queue_description, queue_subjectlist, queue_versioned FROM whups_queues WHERE queue_id = 1 [on line 849 of "/srv/www/vhosts/morison.biz/horde.cvs/whups/lib/Driver/sql.php"] Oct 21 15:44:17 HORDE [debug] [whups] SQL Query by Whups_Driver_sql::getStates(): SELECT state_id, state_name FROM whups_states WHERE type_id = 1 AND (state_category = 'new' OR state_category = 'assigned') ORDER BY state_category, state_name [on line 1292 of "/srv/www/vhosts/morison.biz/horde.cvs/whups/lib/Driver/sql.php"] Oct 21 15:44:17 HORDE [debug] [whups] SQL Query by Whups_Driver_sql::getPriorities(): SELECT priority_id, priority_name FROM whups_priorities WHERE type_id = 1 ORDER BY priority_name [on line 1400 of "/srv/www/vhosts/morison.biz/horde.cvs/whups/lib/Driver/sql.php"] Oct 21 15:44:17 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 = 'horde.groups' AND (a1.attribute_name = 'user' AND a1.attribute_key = 'rod') AND a1.attribute_name = a1.attribute_name GROUP BY c.datatree_id, c.datatree_name, c.datatree_order ORDER BY c.datatree_order, c.datatree_name, c.datatree_id [on line 958 of "/usr/share/php/Horde/DataTree/sql.php"] Oct 21 15:44:17 HORDE [debug] [whups] SQL Query by Whups_Driver_sql::getQueueUsers(): SELECT user_uid AS u1, user_uid AS u2 FROM whups_queues_users WHERE queue_id = '1' ORDER BY u1 [on line 1094 of "/srv/www/vhosts/morison.biz/horde.cvs/whups/lib/Driver/sql.php"] Oct 21 15:44:17 HORDE [debug] [whups] SQL Query by Prefs_sql::retrieve(): SELECT pref_scope, pref_name, pref_value FROM horde_prefs WHERE pref_uid = 'testy' AND (pref_scope = 'whups' OR pref_scope = 'horde') ORDER BY pref_scope [on line 147 of "/usr/share/php/Horde/Prefs/sql.php"] Oct 21 15:44:17 HORDE [debug] [whups] SQL Query by Whups_Driver_sql::getOwners(): SELECT ticket_owner, ticket_owner FROM whups_ticket_owners WHERE ticket_id = 0 [on line 1912 of "/srv/www/vhosts/morison.biz/horde.cvs/whups/lib/Driver/sql.php"] Oct 21 15:44:17 HORDE [debug] [whups] SQL Query by Whups_Driver_sql::isCategory(): SELECT 1 FROM whups_states WHERE state_id = 1 AND state_category = 'assigned' [on line 1375 of "/srv/www/vhosts/morison.biz/horde.cvs/whups/lib/Driver/sql.php"] Oct 21 15:44:17 HORDE [debug] [whups] SQL Query by Whups_Driver_sql::isCategory(): SELECT 1 FROM whups_states WHERE state_id = 1 AND state_category = 'assigned' [on line 1375 of "/srv/www/vhosts/morison.biz/horde.cvs/whups/lib/Driver/sql.php"] Oct 21 15:44:17 HORDE [error] [whups] DB Error: unknown error: UPDATE whups_tickets_seq SET id=LAST_INSERT_ID(id+1) [nativecode=1142 update command denied to user: 'horde@localhost' for table 'whups_tickets_seq'] [on line 184 of "/srv/www/vhosts/morison.biz/horde.cvs/whups/lib/Driver/sql.php"] Oct 21 15:44:17 HORDE [error] [whups] DB Error: unknown error: UPDATE whups_tickets_seq SET id=LAST_INSERT_ID(id+1) [nativecode=1142 update command denied to user: 'horde@localhost' for table 'whups_tickets_seq'] [on line 153 of "/srv/www/vhosts/morison.biz/horde.cvs/whups/ticket/create.php"] Oct 21 15:44:18 HORDE [debug] [whups] SQL Query by Whups_Driver_sql::getQueues(): SELECT queue_id, queue_name FROM whups_queues ORDER BY queue_name [on line 869 of "/srv/www/vhosts/morison.biz/horde.cvs/whups/lib/Driver/sql.php"] Oct 21 15:44:18 HORDE [debug] [whups] SQL Query by Whups_Driver_sql::getTypes(): SELECT t.type_id, t.type_name FROM whups_types t, whups_types_queues tm WHERE tm.queue_id = 1 AND tm.type_id = t.type_id ORDER BY t.type_name [on line 1181 of "/srv/www/vhosts/morison.biz/horde.cvs/whups/lib/Driver/sql.php"] Oct 21 15:44:18 HORDE [debug] [whups] SQL Query by Whups_Driver_sql::getQueue(): SELECT queue_id, queue_name, queue_description, queue_subjectlist, queue_versioned FROM whups_queues WHERE queue_id = 1 [on line 849 of "/srv/www/vhosts/morison.biz/horde.cvs/whups/lib/Driver/sql.php"] Oct 21 15:44:18 HORDE [debug] [whups] SQL Query by Whups_Driver_sql::getVersions(): SELECT version_id, version_name, version_description FROM whups_versions WHERE queue_id = 1 ORDER BY version_name DESC [on line 1483 of "/srv/www/vhosts/morison.biz/horde.cvs/whups/lib/Driver/sql.php"] Oct 21 15:44:18 HORDE [debug] [whups] SQL Query by Whups_Driver_sql::getQueue(): SELECT queue_id, queue_name, queue_description, queue_subjectlist, queue_versioned FROM whups_queues WHERE queue_id = 1 [on line 849 of "/srv/www/vhosts/morison.biz/horde.cvs/whups/lib/Driver/sql.php"] Oct 21 15:44:18 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 = 'horde.groups' AND (a1.attribute_name = 'user' AND a1.attribute_key = 'rod') AND a1.attribute_name = a1.attribute_name GROUP BY c.datatree_id, c.datatree_name, c.datatree_order ORDER BY c.datatree_order, c.datatree_name, c.datatree_id [on line 958 of "/usr/share/php/Horde/DataTree/sql.php"] Oct 21 15:44:18 HORDE [debug] [whups] SQL Query by Whups_Driver_sql::getQueueUsers(): SELECT user_uid AS u1, user_uid AS u2 FROM whups_queues_users WHERE queue_id = 1 ORDER BY u1 [on line 1094 of "/srv/www/vhosts/morison.biz/horde.cvs/whups/lib/Driver/sql.php"] Oct 21 15:44:18 HORDE [debug] [whups] SQL Query by Prefs_sql::retrieve(): SELECT pref_scope, pref_name, pref_value FROM horde_prefs WHERE pref_uid = 'testy' AND (pref_scope = 'whups' OR pref_scope = 'horde') ORDER BY pref_scope [on line 147 of "/usr/share/php/Horde/Prefs/sql.php"] Oct 21 15:44:18 HORDE [debug] [whups] SQL Query by Whups_Driver_sql::getOwners(): SELECT ticket_owner, ticket_owner FROM whups_ticket_owners WHERE ticket_id = 0 [on line 1912 of "/srv/www/vhosts/morison.biz/horde.cvs/whups/lib/Driver/sql.php"]