We'd like to start our bug numbers to something other than 1 for a new Bugzilla installation. Is there a way to do this?
+2
A:
I'm not sure about Bugzilla's backend, but if it uses a SQL database, you should be able to find the table that controls the bug ID number and set the autoincrement value to something else. That is, if Bugzilla uses autoincrement.
But I don't have a copy of Bugzilla to provide more info.
Thomas Owens
2008-10-30 12:27:20
A:
I believe it's an autoincrement value in the "bugs" table.
In order to force this to start at a predefined value,
in MYSQL, you'll need to ...
- switch off autoincrement on this field.
- insert a record with a bug_id set to your starting point.
- switch the autoincrement back on.
seanyboy
2008-10-30 12:55:45
Or you can open up the table and set the AUTOINCREMENT to a new starting value...it's much easier. Unfortunately, I only know how to do that in the MySQL Query Browser and MySQL Administrator.
Thomas Owens
2008-10-30 12:57:18
+1
A:
Based on the responses, the following MySQL command will do it:
ALTER TABLE bugs AUTO_INCREMENT = 100;
where 100 is the new seed number.
Here's the link to the Bugzilla schema.
Richard Morgan
2008-10-30 13:13:46