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

bugs at bugs.horde.org bugs at bugs.horde.org
Thu Oct 21 15:45:43 PDT 2004 

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: http://bugs.horde.org/ticket/?id=714
-----------------------------------------------------------------------
 Ticket     | 714
 Created By | rod at morison.biz
 Summary    | Can't add ticket to whups queue, unknown DB error
 Queue      | Whups
 State      | Unconfirmed
 Priority   | 2. Medium
 Type       | Bug
 Owners     | 
-----------------------------------------------------------------------


rod at morison.biz (2004-10-21 15:45) wrote:

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 at 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 at 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"]

More information about the bugs mailing list