Closed Bug 1145322 Opened 9 years ago Closed 9 years ago

Bug id customization - add a character as prefix before bug id

Categories

(Bugzilla :: Administration, task)

4.4.2
task
Not set
normal

Tracking

()

RESOLVED INVALID

People

(Reporter: ruban.yuvaraj, Unassigned)

Details

User Agent: Mozilla/5.0 (Linux; Android 4.4.2; SM-G7102 Build/KOT49H) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/40.0.2214.109 Mobile Safari/537.36

Steps to reproduce:

I am using mysql database for bugzilla.  I changed the bug id field in bugs table as varchar (30) and removed auto increment, also modified data type in all its corresponding child tables.  I created a new table for generating sequence and wrote a before insert trigger on bugs table to concatenate alphabet and the sequence number into bug_id column in bugs table. 


Actual results:

 Am getting foreign key constraint error on longdesc table. 
Getting error on Bug.pm module at line# 711 and Bugzilla::Bug::create("Bugzilla::Bug", HASH(0x19f28840)) called at /var/www/html/bugzilla/post_bug.cgi line 129


Expected results:

I want bug id should get generated as 'AB001'
This is a support question. Please see https://www.bugzilla.org/support for help. Altering the DB schema of Bugzilla is always a bad idea anyway.
Status: UNCONFIRMED → RESOLVED
Closed: 9 years ago
Resolution: --- → INVALID
You need to log in before you can comment on or make changes to this bug.