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.
ID ISSUES RESET
Moderators: Developer, Contributor
Re: ID ISSUES RESET
I didn't try, but this should do the job
Code: Select all
ALTER TABLE mantis_bug_table AUTO_INCREMENT =1;
-
- Posts: 4
- Joined: 19 Dec 2018, 06:51
Re: ID ISSUES RESET
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
No idea at the moment what's going wrong, the statement should work
https://stackoverflow.com/questions/892 ... t-in-mysql
https://stackoverflow.com/questions/892 ... t-in-mysql
Re: ID ISSUES RESET
Another simple approach is to reinstall the Database from scratch.....