Change sequential ID - first / start number

[jones]

Hello

I've been away from Hesk for a period. And forgot how it is I change. The number as Sequential ID starts with.
Are there some that can help with that?

Have searched the forum. But can not find a place where that is described. How do I change the number as Sequential ID starts with?

Since I need to start with the 00053

Thanks
Jonas

[mkoch227]

The sequential IDs are driven by the database itself (HESK does not tell the database what the next sequential ID should be). You can alter the AUTO_INCREMENT value on the tickets table to tell the database what the next ID should be:

Code: Select all

ALTER TABLE hesk_tickets AUTO_INCREMENT = 53

I'm not sure if HESK will do anything weird if the auto increment number is changed; however I don't think it will since tickets can be deleted which breaks the flow of IDs anyways.

If you want to add padding to the ID (i.e. 00053 instead of 53), you will have to do some sort of logic in the PHP pages to properly pad it, or modify the SQL queries to pad some 0s when selecting the data.

[Klemen]

What Mike said is correct. And no, changing the value will not break anything in HESK.

[jones]

Hi Mike & Klemen,

Thanks for the quick reply
- Which file should I change "AUTO_INCREMENT" in?

Jonas

[mkoch227]

You want to execute the query in a MySQL database management application, such as phpMyAdmin.