SQL Fix

Alex L admin@networkessence.net
Sat, 6 Oct 2001 19:10:19 -0500



Problem in SQL backend driver for updating ticket state and priority state.

setTicketState:

Line 131 was:
$this->_query("UPDATE ticket SET state = $tostate WHERE id = $ticket_id");

and needs to be:
$this->_query("UPDATE whups_tickets SET state_id = $tostate WHERE ticket_id = 
$ticket_id");


setTicketPriority:

Line 144 was:
$this->_query("UPDATE ticket SET priority = $priority WHERE id = $ticket_id");

and needs to be:
$this->_query("UPDATE whups_tickets SET priority_id = $priority WHERE ticket_id 
= $ticket_id");


-Alex

-------------------------------------------------
This mail sent through IMP: http://horde.org/imp/