Reset Issue ID?

[ChrisOFNA]

Hey Guys,

I'm running MantisBT 1.2.17 and I was wondering if there was anyway to reset the Issue IDs back to 0? I deleted all the issues I had after testing out but now we will be implementing this in the field and we want to start fresh.

[atrol]

Running the following statement in your database should work

Code: Select all

ALTER TABLE mantis_bug_table AUTO_INCREMENT=1;

[ChrisOFNA]

Sorry for my ignorance but where would I run this at? I set this up on a Windows 2008 R2 machine.

[atrol]

I don't know what you have installed on your machine.
You can run this with any MySQL database client, e.g. phpMyAdmin, mysql command line, MySql Workbench, ...

[ChrisOFNA]

phpMyadmin, definitely not MySQL.