ID ISSUES RESET

General discussion of Mantis.

Moderators: Contributor, Developer

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

ID ISSUES RESET

Post by cedrickzepp » Dec 19, 2018 1:57 am

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: 7625
Joined: Mar 26, 2008 4:37 pm
Location: Germany

Re: ID ISSUES RESET

Post by atrol » Dec 19, 2018 2:18 am

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: Dec 19, 2018 1:51 am

Re: ID ISSUES RESET

Post by cedrickzepp » Dec 19, 2018 2:36 am

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: 7625
Joined: Mar 26, 2008 4:37 pm
Location: Germany

Re: ID ISSUES RESET

Post by atrol » Dec 19, 2018 2:57 am

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: 528
Joined: Mar 11, 2006 11:08 am
Contact:

Re: ID ISSUES RESET

Post by cas » Feb 14, 2019 7:19 am

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

Post Reply