CODEWITHSUNDEEP
bugzilla
Richard Morgan
Richard Morgan

Reputation: 7691

How do I seed the Bug number in Bugzilla?

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?

Upvotes: 2

Views: 2159

Answers (3)

Richard Morgan
Richard Morgan

Reputation: 7691

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.

Upvotes: 5

seanyboy
seanyboy

Reputation: 5693

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.

Upvotes: 0

Thomas Owens
Thomas Owens

Reputation: 116187

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.

Upvotes: 2

Related Questions