Is it safe to manually increase the ticket ID counter?

RT Users
#1

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

#2

Yes. This is perfectly safe.

-R

At Tue, 11 Nov 2003 20:05:57 +0100,
Jan Algermissen wrote:

#3

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@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@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

877-716-2002 x 545

#4

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@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@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@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.