1088107 - unable to deploy component watch due to foreign key error on the component_watch table (bugzilla 5.0+)

Status: RESOLVED DUPLICATE of bug 1090493

(bugzilla.mozilla.org :: Extensions, defect)

Description

[:glob ✱]

unable to deploy component watch due to foreign key error on the component_watch table.

this sounds like a duplicate of bug 769829 (and its upstream bug 1082106), but it isn't -- those bugs are for FK errors when adding a column to an existing table.

DBD::mysql::db do failed: Cannot add foreign key constraint [for Statement "ALTER TABLE component_watch ADD
     CONSTRAINT fk_component_watch_component_id_components_id FOREIGN KEY (component_id)
     REFERENCES components(id)
      ON UPDATE CASCADE ON DELETE CASCADE, ADD
     CONSTRAINT fk_component_watch_product_id_products_id FOREIGN KEY (product_id)
     REFERENCES products(id)
      ON UPDATE CASCADE ON DELETE CASCADE, ADD
     CONSTRAINT fk_component_watch_user_id_profiles_userid FOREIGN KEY (user_id)
     REFERENCES profiles(userid)
      ON UPDATE CASCADE ON DELETE CASCADE"] at Bugzilla/DB.pm line 639.
	Bugzilla::DB::bz_add_fks('Bugzilla::DB::Mysql=HASH(0x7452118)', 'component_watch', 'HASH(0x69478e0)', 'HASH(0x7778068)') called at Bugzilla/DB.pm line 546
Bugzilla::DB::bz_setup_foreign_keys('Bugzilla::DB::Mysql=HASH(0x7452118)') called at Bugzilla/Install/DB.pm line 746
	Bugzilla::Install::DB::update_table_definitions('HASH(0x1abb710)') called at ./checksetup.pl line 171

Comment 1

[:glob ✱]

looks like this only happens on bugzilla 4.4+

Comment 2

[:glob ✱]

ah, components.id changed from a SMALLSERIAL to a MEDIUMSERIAL some time between 4.4 and 5.0.

the extension needs to detect the bugzilla version and change the datatype of the component_watch.component_id field.

i suspect there will be issues with sites upgrading to 5.0 (untested).

Comment 3

[:glob ✱]

bug 1090493 has a patch, duping there.