This is a kind of minor issue, but one that has been annoying me a lot. I use basic ticket numbering, and the links to tickets, like tickets.php?id=123 use to match the ticket numbers, but something has caused them not to match. The ticket number is 5 ahead of the id. I was kind of surprised to see this, but after seeing how there is the whole custom ticket numbering system available, I understand that they are not actually linked like in most php projects. I have actually gone and manually set the AUTO_INCREMENT for the ost_tickets table so that they line up (hopefully that doesn't break anything...  since I only adjusted it forwards).Anyone have recommendation on how to keep them matching, or a patch to just use the sql table's auto increment instead of fancy osticket numbering?What would be really nice an option, like a checkbox, in the Manage Sequences tool, to just follow the sql auto increment.Thanks,Dan

Dan, I too had this problem.  Look at the ost_sequence table>next column.  I don't exactly remember how I matched up the numbers but I do remember massaging the ost_sequence table and the ost_ticket table.  I think I had to manually add some records in the ost_ticket table.BTW, the tickets add up fast and so I jumped forward to the thousands series in case I needed to do any searches that required the exact number.Cherrie

a year later

Definitively what you need is go into the ost_sequence table and edit the "next" column. That indicates what is the next id to be used.

But, you may also change the ticket_id autoincrement in ost_ticket, that is easier:

ALTER TABLE ticket_id AUTO_INCREMENT = [value];

Write a Reply...