Change Ticket id to a higher start number

[tvds]

We like to start with Ticket id number 6000 instead of 1.

Why... we are going to try and import our own ticket app into support suite.

These old tickets have id's too, and go up till 5000.

Is it possible to let the ticket id's start at 6000 ?

Thanxs !

[Jamie Edwards]

At the moment, no it is not - but I am forwarding the suggestion

[MarcelC]

I know with Modernbill if you create an invoice it gets ID #1 also. If you change #1 in the database to i.e. #6000 then the next generated invoice will be #6001

You could have a try with ticket ID also, maybe it will work.

Be sure to backup your database first !

[efisher]

It seems that Kayako uses MySQL's auto_increment function to number tickets. The following worked for us, but I can't make any guarantees.

Log into the MySQL command line as either root or the user for your Kayako database. Once in:

mysql> use kayako_suite;
mysql> ALTER TABLE swtickets AUTO_INCREMENT=6000;

This will set the next item to be issued a ticketid of 6000, per the auto_increment function in MySQL.

Hope that helps. Just like some of the other suggestions... make sure to backup your database before doing this. It worked for us, but your mileage may vary.

-Eric

Originally Posted by tvds

We like to start with Ticket id number 6000 instead of 1.

Why... we are going to try and import our own ticket app into support suite.

These old tickets have id's too, and go up till 5000.

Is it possible to let the ticket id's start at 6000 ?

Thanxs !

[Jamie Edwards]

Hi efisher,

Thanks for the suggestion. I am not sure of any reason why this would cause any major problems [EDIT] Please see the post below for a side effect of doing this.

[richm]

You might want to test the effects of this on the client portal.

It may be my config, or it may be an existing bug, but since changing the ticket range, when a client logs in, and views the ticket list, it never comes up sorted properly.

e.g. client A has tickets open that range from 13 (lowest) to 527 (highest), when they login, and click ticket view (settings in control panel are to sort newest first) they get ticket 515. To get newest first (527) I have to click the ticket id twice. sigh...

[richm]

Just noticed, in looking at the kayako_suite db, swtickets table, edit table, advanced options, it indicates for "auto_increment" -> "The initial auto increment value for the table, only for MyISAM.

Table options tab says this is engine type InnoDB

Can you confirm that changing the auto-increment per earlier post, isn't going to create problems?