Customizing Bugzilla 4.0.2 Bug ID numbers

Posted by Marcus Polk on Stack Overflow See other posts from Stack Overflow or by Marcus Polk
Published on 2012-04-13T23:26:46Z Indexed on 2012/04/13 23:29 UTC
Read the original article Hit count: 210

Filed under:

bugzilla

Is it possible to customize Bugzilla bug numbers and add a letter designator, to immediately know it came from Bugzilla?

My company is evaluating Bugzilla and has now added many new bugs. We also use 2 other bug databases. This wasn't my decision and I believe they were trying to incorporate better reporting, etc.

I read an answer here about "seeding" Bugzilla bug numbers, by setting the "AUTO_INCREMENT" field in the "bugs" table to a different value. I wish I would've thought about this sooner and found this board. Setting that value to start at 9000 or some extraordinary value would have ensured that we knew exactly which bugs came from Bugzilla.

However, would it be possible to change the field in the "bugs" table to accept letters, as well? Of course that would probably just mess up the whole auto incrementing of the numbers.

Any help or advice is greatly appreciated. Thank you.

Related posts about bugzilla

Can't install Perl DBD module on Ubuntu (for Bugzilla)

as seen on Server Fault - Search for 'Server Fault'
Trying to install bugzilla-4.2.2 on Ubuntu 12.04. When I run checksetup.pl I get the following error: YOU MUST RUN ONE OF THE FOLLOWING COMMANDS (depending on which database you use): PostgreSQL: /usr/bin/perl install-module.pl DBD::Pg MySQL: /usr/bin/perl install-module.pl DBD::mysql SQLite: /usr/bin/perl… >>> More
How to delete bugs in Bugzilla

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
Good description of the trick to delete bugs in Bugzilla. >>> More
Bugzilla ./testserver.pl failing

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
root@KittensTest:/var/www/Bugzilla/bugzilla-4.2.1# ./testserver.pl http://localhost/Bugzilla/bugzilla-4.2.1 TEST-OK Webserver is running under group id in $webservergroup. TEST-OK Got padlock picture. TEST-FAILED Webserver is fetching rather than executing CGI files. Check the AddHandler statement… >>> More
Bugzilla with SSL

as seen on Server Fault - Search for 'Server Fault'
I have an install of Bugzilla I'm trying to implement SSL on. When I go into the parameters screen and edit SSLBASE adding in the full url: https://foo.com/bugzilla/ the editparams.cgi times out on loading and I have the following error in the apache log [Tue Mar 30 19:29:39 2010] [error]… >>> More
one step Bugzilla installation

as seen on Server Fault - Search for 'Server Fault'
I'm looking into installing Bugzilla either on a Windows or Linux box. Bugzilla requires a bunch of packages (apache, sql, mail sending?). Does anyone know of a pre-packaged installer which includes most common options or a linux virtual machine image? >>> More

Developer IT