6.0.0-beta1
▾
Tasks
New Task
Search
Photos
Wiki
▾
Tickets
New Ticket
Search
dev.horde.org
Toggle Alerts Log
Help
8/12/25
H
istory
A
ttachments
C
omment
W
atch
Download
Comment on [#714] Can't add ticket to whups queue, unknown DB error
*
Your Email Address
*
Spam protection
Enter the letters below:
. .. ..__ . . . \ /\ /[__)| | | \/ \/ | \|__|\__|
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"] > >
Attachment
Watch this ticket
N
ew Ticket
M
y Tickets
S
earch
Q
uery Builder
R
eports
Saved Queries
Open Bugs
Bugs waiting for Feedback
Open Bugs in Releases
Open Enhancements
Enhancements waiting for Feedback
Bugs with Patches
Enhancements with Patches
Release Showstoppers
Stalled Tickets
New Tickets
Horde 5 Showstoppers