Software affected: SmarterTicket v2.x

When trying to do an action, such as deleting a ticket, you get the following error:

An error has occurred:

/Agent/frmTickets.aspx

Back

And the error log shows:

Agent: [some agent]

Exception caught by frmError.aspx
Could not find stored procedure 'smarterticketSP_DeleteTicket'.
System.Data.SqlClient.SqlException: Could not find stored procedure 'smarterticketSP_DeleteTicket'.

Solution: Run the following SQL query against the SmarterTicket database using
Enterprise manager (or whichever database administration tool you have
available):

CREATE PROCEDURE [dbo].[smarterticketSP_DeleteTicket]
@ticketNumber as varchar(32),
@agentID as int = 0,
@purge as int = 0,
@dtnow as DateTime = GetDate,
@deleteStats as int = 0
AS

declare @ticketID as int;
declare @groupID as int;
select @ticketID = TicketID, @groupID = GroupID from
[dbo].[SmarterTicket_Ticket] where TicketNumber = @ticketNumber;

delete from [dbo].[SmarterTicket_TicketRead] where TicketID = @ticketID;

if @deleteStats <> 0
delete from [dbo].[SmarterTicket_MicroStats] where TicketID = @ticketid;

if @deleteStats <> 0
delete from [dbo].[SmarterTicket_TicketLog] where TicketNumber =
@ticketnumber;

if @deleteStats <> 0
delete from [dbo].[SmarterTicket_ActionLog] where TicketNumber =
@ticketnumber;

delete from [dbo].[SmarterTicket_TicketNote] where TicketNumber =
@ticketnumber;
delete from [dbo].[SmarterTicket_TicketResolution] where TicketNumber =
@ticketnumber;
delete from [dbo].[SmarterTicket_Attachment] where ReplyID in (
select ReplyID from [dbo].[SmarterTicket_Reply] where TicketNumber =
@ticketnumber);
delete from [dbo].[SmarterTicket_Reply] where TicketNumber = @ticketnumber;

if @purge = 0
update [dbo].[SmarterTicket_Ticket]
set deleteddate=@dtnow, deletedagentid = @agentID, IsOpen = 0, IsPinned =
0
where ticketnumber = @ticketnumber;
else
delete from [dbo].[SmarterTicket_Ticket] where TicketNumber =
@ticketnumber;

if @deleteStats = 0
insert into [dbo].[SmarterTicket_MicroStats] (TicketID, AgentID, GroupID,
EventTime, EventCode)
values (@ticketID, @agentID, @groupID, @dtnow, 9);
else
insert into [dbo].[SmarterTicket_MicroStats] (TicketID, AgentID, GroupID,
EventTime, EventCode)
values (null, @agentID, @groupID, @dtnow, 9);