https://bugzilla.wikimedia.org/show_bug.cgi?id=37105
--- Comment #11 from Andre Klapper <[email protected]> --- Tried to deploy bzr://bzr.mozilla.org/bmo/4.2/extensions/ComponentWatching/ on boogs.wmflabs.org, but running checksetup.pl triggers: Adding new column 'watch_user' to the 'components' table... Adding foreign key: component_watch.product_id -> products.id... Adding foreign key: component_watch.component_id -> components.id... Adding foreign key: component_watch.user_id -> profiles.userid... Adding foreign key: components.watch_user -> profiles.userid... DBD::mysql::db do failed: Can't create table 'bugs.#sql-3c5_85' (errno: 121) [for Statement "ALTER TABLE components ADD CONSTRAINT fk_components_watch_user_profiles_userid FOREIGN KEY (watch_user) REFERENCES profiles(userid) ON UPDATE CASCADE ON DELETE SET NULL"] at Bugzilla/DB.pm line 654 Bugzilla::DB::bz_add_fks('Bugzilla::DB::Mysql=HASH(0x23c5e20)', 'components', 'HASH(0x56be2d0)', 'HASH(0x7fda5e0)') called at Bugzilla/DB.pm line 561 Bugzilla::DB::bz_setup_foreign_keys('Bugzilla::DB::Mysql=HASH(0x23c5e20)') called at Bugzilla/Install/DB.pm line 685 Bugzilla::Install::DB::update_table_definitions('HASH(0x16c5bc0)') called at ./checksetup.pl line 199 Would love to check the "components" table for the "watch_user" column in the "bugs" database (to see where this is coming from), and to be on the safe side also run SELECT constraint_name, table_name FROM information_schema.table_constraints WHERE constraint_type = 'FOREIGN KEY' AND table_schema = DATABASE() ORDER BY constraint_name; but mysql> SHOW DATABASES; +--------------------+ | Database | +--------------------+ | information_schema | | test | +--------------------+ 2 rows in set (0.00 sec) seems to not offer me the bugs database (and cannot log in as root). -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. _______________________________________________ Wikibugs-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
