825584 - "Building Schema object from database" do not include foreign keys

Status: RESOLVED DUPLICATE of bug 377432

(Bugzilla :: Installation & Upgrading, defect)

Description

[andershol]

Attachment: Fix "Building Schema object from database" to handle existing foreign keys

Bugzilla may try to build the schema object from the database (e.g. if you delete the row from the bz_schema-table). But when it does, it does not check for any foreign keys, so when it next tries to upgrade the schema it will try to create the foreign keys that already exist and this will fail.

This patch adds logic to get foreign key definitions from the database (Bugzilla/DB/Mysql.pm, Bugzilla/DB/Schema.pm), handles missing columns (Bugzilla/DB.pm), and fix the error handling to check for missing column before attempting dclone-ing it (Bugzilla/DB/Schema.pm).

Comment 1

[Frédéric Buclin]

We already have a bug for this issue. Please read comments in bug 377432 and re-attach your patch there.