Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

In this Discussion

osTicket v1.10 (stable) and Maintenance Release v1.9.15 are now available! Go get it now

changing from random ticket IDs to incremental

Is it possible to change from random IDs to incremental IDs on a system that already has numerous (22,000) tickets, without breaking the system? Will osticket recognize that an ID number is already taken and jump to the next unused ID?

Thanks!
Tagged:

Comments

  • We did this without any issue. It looks like there are two separate fields in the database, one for the actual number, the other for the random number.

    Jack
  • Thanks, Jack. I've made change. I'm crossing my fingers!
  • I've never tried going from one to the other.  Please let me know how you make out on this. :)
  • You shouldn't expect any issues from changing ticket numbering from random to sequential. If you want to start at a specific number e.g 6500 issue the following SQL command.

    ALTER TABLE ost_ticket AUTO_INCREMENT = 6500;

    osTicket v1.9.4 comes with custom ticket numbers and formats ... just a FYI.
  • From what I can see, ticketID is only referenced in the ost_ticket table and nowhere else.  I will set to autoincrement -- thanks for tip.
  • I've never tried going from one to the other.  Please let me know how you make out on this. :)
    Haven't seen any issues. system is functioning as expected.
Sign In or Register to comment.