[rt-users] Re: Altering/Resetting ticket id # - Help!

[Adrian Carter]

Thanks Seph,
    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.

Adrian

seph wrote:

>>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)
>
>seph
>_______________________________________________
>http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>
>Be sure to check out the RT wiki at http://wiki.bestpractical.com
>
>
>  
>

-- 
Adrian Carter
Network Engineer
Leading Edge Internet
Direct    +61 2 6163 6162  Support 1 300 662 415
E-mail     cartera at lei.net.au