I figured it was something like this… but I’ve tried altering the
"Tickets" table and “Transactions” to reflect a ticket number of say
10000, thinking the next one would be 10001.
Doesn't work :( . Next ticket goes back to next in the sequence..
The tickets all work once doctored up to 10000, but new tickets go back
to 5,6,7 etc.
Im pretty good with SQL but this ones got me scratchin my head.
Guess Illl have to go debug the CreateTicket function.
I’ve rebuilt our RT onto a new platform with better queues etc… but I
want to reset the Ticket Id to be something like 10000+ so it doesn’t
clash with old-rt tickets.
The ticket numbers comes from the incrementing sequence in the
database. Instructions on changing it was once sent to the list, but I
don’t have a pointer handy. (It shouldn’t be that hard if you have
sufficient SQL knowledge)
Be sure to check out the RT wiki at http://wiki.bestpractical.com
Leading Edge Internet
Direct +61 2 6163 6162 Support 1 300 662 415