last week i added the cf_fx_iteration custom field to bugzilla, however it looks like something went wrong. i don't recall any errors being thrown at the time. the other field i created at the same time (cf_fx_points) was created without issue. i've just tried to add values to the field, and it reported that cf_fx_iteration table didn't exist :( i deleted the field and re-created it, however it's now broken in a different way. the field doesn't exist according to bz_schema or the fielddefs table. however the schema for the field exists (bugs.cf_fx_iteration and the cf_fx_iteration table), so any attempt to create the field now fails. can the following actions please be taken on the bugzilla master database: - drop the bugs.cf_fx_iteration column - drop the cf_fx_iteration table thanks
Kicked off. Should be finished soon.
This completed. Made sure there was no production impact (that was part of the purpose of the last comment).
thanks for the quick turn around on this request :) unfortunately things went south when i tried again to create the field. thankfully i had my tools pointed at bugzilla so i think i know the sequence of events which lead us to this situation (long story short: failure during field creation isn't rolled back on mysql or memcached). in order to get this field live, can you please create the following table on production and insert a single row: CREATE TABLE `cf_fx_iteration` ( `id` smallint(6) NOT NULL AUTO_INCREMENT, `value` varchar(64) NOT NULL, `sortkey` smallint(6) NOT NULL DEFAULT '0', `isactive` tinyint(4) NOT NULL DEFAULT '1', `visibility_value_id` smallint(6) DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `cf_fx_iteration_value_idx` (`value`), KEY `cf_fx_iteration_visibility_value_id_idx` (`visibility_value_id`), KEY `cf_fx_iteration_sortkey_idx` (`sortkey` , `value`) ) INSERT INTO cf_fx_iteration (value) VALUES ('---')
It would seem this table and row already exist. Please advise.
sorry, my bad. not sure what happened to make me think the table wasn't there, but it's there for sure and i can add values to it. thanks again for the prompt response!