ID ISSUES RESET

General discussion of Mantis.

Moderators: Developer, Contributor

Post Reply
cedrickzepp
Posts: 4
Joined: 19 Dec 2018, 06:51

ID ISSUES RESET

Post by cedrickzepp »

HI!

I'm running MantisBT 2.18.0 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
Site Admin
Posts: 8366
Joined: 26 Mar 2008, 21:37
Location: Germany

Re: ID ISSUES RESET

Post by atrol »

I didn't try, but this should do the job

Code: Select all

ALTER TABLE mantis_bug_table AUTO_INCREMENT =1;
Please use Search before posting and read the Manual
cedrickzepp
Posts: 4
Joined: 19 Dec 2018, 06:51

Re: ID ISSUES RESET

Post by cedrickzepp »

Code: Select all

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ALTER TABLE mantis_bug_table AUTO_INCREMENT=1' at line 1
atrol
Site Admin
Posts: 8366
Joined: 26 Mar 2008, 21:37
Location: Germany

Re: ID ISSUES RESET

Post by atrol »

No idea at the moment what's going wrong, the statement should work
https://stackoverflow.com/questions/892 ... t-in-mysql
Please use Search before posting and read the Manual
cas
Posts: 1586
Joined: 11 Mar 2006, 16:08
Contact:

Re: ID ISSUES RESET

Post by cas »

Another simple approach is to reinstall the Database from scratch.....
Post Reply