Page 1 of 1

ID ISSUES RESET

Posted: Dec 19, 2018 1:57 am
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.

Re: ID ISSUES RESET

Posted: Dec 19, 2018 2:18 am
by atrol
I didn't try, but this should do the job

Code: Select all

ALTER TABLE mantis_bug_table AUTO_INCREMENT =1;

Re: ID ISSUES RESET

Posted: Dec 19, 2018 2:36 am
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

Re: ID ISSUES RESET

Posted: Dec 19, 2018 2:57 am
by atrol
No idea at the moment what's going wrong, the statement should work
https://stackoverflow.com/questions/892 ... t-in-mysql

Re: ID ISSUES RESET

Posted: Feb 14, 2019 7:19 am
by cas
Another simple approach is to reinstall the Database from scratch.....