Re: [Phphelpdesk-help] Reset Ticket ID

[Roy R. <rs...@ae...>]

On Tue, 5 Feb 2002, David Hansen Jr. wrote:
> How would I reset it to 1?

The ticket ID is determined by MySQL based on previous ticket IDs present
in the ticket table.  If your ticket table has any tickets, MySQL will use
the next available ticket ID as the new ticket number.

The solution, then, theoretically, is to delete all tickets in the ticket
table.  

You may need to do this within MySQL -- I found that when I installed
PHPHD, it put in some default tickets & departments and, if I did the wrong
thing (defining my users as not having access to those departments since we
were not using them), they became, essentially, invisible from within the
web interface.  

DELETE from ticket; 

is your friend :)

-roy