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
Last Resolved: 3 years ago
Resolution: --- → INVALID
You need to log in before you can comment on or make changes to this bug.