Hello list,
I'm trying to add additional platforms to customize the bugzilla
system for our needs.
I searched the web and haven't found any information on this subject.
From what I managed to figure out, bugzilla pulls its data from the
bugs table in it's db.
here is the relevant part from mysql output :
<<<
mysql> show create table bugs;
[snip]
`product_id` smallint(6) NOT NULL default '0',
`rep_platform`
enum('All','DEC','HP','Macintosh','PC','SGI','Sun','Other') default
NULL,
`reporter` mediumint(9) NOT NULL default '0',
[snip]
>>>
I tried issuing the following commands :
<<<
mysql> ALTER TABLE bugs DROP rep_platform;
ALTER TABLE bugs ADD rep_platform
enum('All','plat1','plat2','plat3','PC','plat4','plat5','Other','plat6','plat7','plat8')
default NULL;
>>>
I didn't used the ALTER TABLE CHANGE syntax because of a user comment
posted by Tom S [1].
I've verified that the data was correctly inputted into the database by issuing
<<<
mysql> show create table bugs;
[snip]
`rep_platform`
enum('All','plat1','plat2','plat3','PC','plat4','plat5','Other','plat6','plat7','plat8')
default NULL,
PRIMARY KEY (`bug_id`),
[snip]
>>>
The column was now that last one, which is obvious because of the way
mysql works, but to my understanding that should not affect the way
bugzilla interfaces with the db.
I even did a
<<<
apachectl stop
/etc/init.d/mysql stop
/etc/init.d/mysql start
apachectl start
>>>
The trouble is that when I went back to the bug reporting page of
bugzilla, the old platform selections have remained unchanged. I am
quite confused and frustrated about this.
As I lack the knowledge of perl, I seem to be unable to figure out
where exactly does bugzilla pulls it's data from, and that is why I'm
requesting your help.
Thank you in advance for any points.
mysql Ver 11.18 Distrib 3.23.58, for redhat-linux-gnu (i386)
Bugzilla Version 2.18.3
Cheers.
--
Cheers,
Maxim Vexler (hq4ever).
Do u GNU ?
