[rt-users] Re: Is it safe to manually increase the ticket ID counter?

michael.firestone michael.firestone at rule-of-ten.com
Wed Nov 12 09:22:00 EST 2003


http://fsck.com/rtfm/article.html?id=5#224 

Is this of any help?  It describes how to set the starting number for MySQL 
and Pg.  I would assume that importing the tickets in order after that would 
work. 

Mik 


John Hogenmiller writes: 

> I was going to ask a question like this myself.  I wanted to start
> tickets at a certain number, and I wanted to create tickets to have a
> specific number (basically, I'm importing tickets from ticketsmith). 
> 
> My thinking was 1) Set starting number, 2) create tickets in order,
> incrementing starting number for any gaps. 
> 
> However, if I can setup a script to pull tickets out of ticketsmith,
> email them in, can I then change the numbers to what we had in the old
> system directly in mysql?  I'm pretty familiar with manipulating sql
> databases, but I was wondering if I would have to change the ticket
> number in multiple places or face breaking it. 
> 
> I'm only talking about the first instance of the ticket.  I would change
> the ticket numbers, and then send in the ticket updates using the
> updated ticket number. 
> 
> 
> Robert Spier wrote:
>> Yes.  This is perfectly safe. 
>> 
>> -R 
>> 
>> At Tue, 11 Nov 2003 20:05:57 +0100,
>> Jan Algermissen wrote: 
>> 
>>> Hi, 
>>> 
>>> we would like the ticket IDs to start at 100.000 and not at 1, thus
>>> making the ticket ID look more like an ID than a counter[1]. Does
>>> RT tolerate such 'holes' in the ticket ID sequence? Is it safe to
>>> manually set the counter to 100000 in MySQL directly?
>>> Or are there any for($i=1; $i <max $i++)-style loops that will break? 
>>> 
>>> Thanks in advance. 
>>> 
>>> Jan
>>> _______________________________________________
>>> rt-users mailing list
>>> rt-users at lists.fsck.com
>>> http://lists.fsck.com/mailman/listinfo/rt-users 
>>> 
>>> Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm
>> 
>> _______________________________________________
>> rt-users mailing list
>> rt-users at lists.fsck.com
>> http://lists.fsck.com/mailman/listinfo/rt-users 
>> 
>> Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm
>  
> 
> -- 
> John Hogenmiller, kb3dfz
> Network Engineer
> Pennswoods.net
> 877-716-2002 x 545 
> 
> _______________________________________________
> rt-users mailing list
> rt-users at lists.fsck.com
> http://lists.fsck.com/mailman/listinfo/rt-users 
> 
> Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm
 


Mik Firestone
Vice Principal
Rule of Ten, Inc. 



More information about the rt-users mailing list