Zeroing ticket ID

[zheka]

Hi friends,

How would I zero the ID number of tickets to start the numeration from the very beginning. That means I have Ticket ID Type set to Sequential.

Eugene

[Jamie Edwards]

Hi Eugene,

Under Admin CP -> Settings > Tickets, turn the following setting to "Sequential", as below.

[craigbrass]

I don't think that is what he means Jamie. I think he is after having ticket ids like 000001015 which would be possible by modifying the templates a little wherever the ticket id is displayed.

[Digital Mayhem]

I think what he means is for example he has it at Sequential already and so it started at like 0000000001 but after time obviously has gotten up to say 000100038 I think now he wants to reset it back down too 0000000001 but I would see problems with this as it would then have issues with the very first tickets that where originally with that Ticket ID even if those old Tickets have been deleted.

[craigbrass]

Well if he has deleted the existing tickets, he could then just modify the MySQL incrementation value for that field using phpMyAdmin.

[zheka]

It's pretty nice hear the wise voice, thanks guy.
Indeed, I'd like to start the whole SupportSuite history from scratch without reinstalling it and have ticket numbers starting with 000001. All existed tickets have been deleted and I made sure the table swtickets is empty. Then I submitted a new ticket but it still came up with a high value ID. I even tried to manually change the ticketid value in this table to 1 and it showed as ticket #1 indeed but the next one is created with an old high value ID.
Craigbrass suggested to modify the incrementation for ticketid. But how should I modify it, it is set to auto_increment. Should I just remove this parameter?

[Jamie Edwards]

Hi Zheka,

No - you certainly should not as this would cause the system to break. MySQL remembers the 'last value' of it's last auto_increment. To flush this, you need to run the following query;

MySQL: Reset Auto Increament Number

Problem One:
If I have entered 10 records, and deleted 9th, 10th records. The next auto increment value will be 11, not 9.

Solution:
Run a query: ALTER TABLE tablename AUTO_INCREMENT = 1
This will reset the next auto increment value to current largest value in the auto increment column + 1. So, the auto increment value of next inserted record will start from 9.

Or, seen as though you are starting afresh you can run this query;

TRUNCATE TABLE TABLENAME

Which will empty the table as well as reset the auto increment value.

If you are wanting to start afresh, I would strongly recommend starting with a new install so that you can be sure housekeeping is clean and in good order

[craigbrass]

Didn't realise there was a MySQL query to automatically find what it now should be. Thanks for sharing that Jamie.

[zheka]

That worked! Thanks a lot, Jamie!

[dellington]

I want to do something along these same lines -- we are moving our support tracking form another system to Support Suite. Currently in our old system we use sequential numbering and we are up to about 3200. We'd like ot start in SS with number 4000 so we do not repeat numbers from the old system. We have a hosted version so I am not sure where to go to run mySQL commands. I know how to use phpMyAdmin, can we access our database that way?