[Hamara-devel] Fwd: Re: Upgrade to 5.0 - Problem dropping foreign key

[shirish]

-------- Forwarded Message --------
Subject: Re: Upgrade to 5.0 - Problem dropping foreign key
Date: Fri, 10 Jul 2015 18:45:04 +0200
From: Thorsten Schöning <tschoening at am-soft.de>
Organization: AM-SoFT IT-Systeme
To: support-bugzilla at lists.mozilla.org <support-bugzilla at lists.mozilla.org>

Guten Tag Jonathan Goldberg,
am Freitag, 10. Juli 2015 um 17:33 schrieben Sie:

> Some years ago, we experimented
> with Testopia, but never actually used it.

Would have been better to use a different installation...

>  We don't do any
> customization, so I always upgrade Bugzilla using the tar ball.
> This should overwrite any patching of Bugzilla files that the
> Testopia installation does.  I have also dropped all of the "test_*" tables from the database.

Bugzilla manages the current state of its schema in the table
bz_schema, just dropping tables is not enough. Extensions like those
for Testopia can register themself for changing the schema and are
added to bz_schema representation that way, so Bugzilla is always
aware that it might need to do additional things during upgrades for
the extensions. The interesting thing is how to completely uninstall
extensions, so they are removed from the schema as well. From what I
know there's currently no proper way to do this, the only thing I'm
aware of is disabling an extension. Removing from the schema is a
heavy task of course, the user might loose data from the extension and
such...

So to make a long story short, you need to change the content of
bz_schema as well and remove everything testopia added. The structure
is a simple Perl hash, easy readable in any text editor. Get it from
the table, change it, update it or something like that, depends on the
tools you have. You can compare it with a fresh empty installation of
4.4.9, shouldn't be too hard to find the differences using some diff
tool.

Because you already dropped the testopia tables, installing it again
and just disabling it won't help you, because installation surely will
fail. But it may be worth a try...

Mit freundlichen Grüßen,

Thorsten Schöning

-- 
Thorsten Schöning       E-Mail: Thorsten.Schoening at AM-SoFT.de
AM-SoFT IT-Systeme      http://www.AM-SoFT.de/

Telefon...........05151-  9468- 55
Fax...............05151-  9468- 88
Mobil..............0178-8 9468- 04

AM-SoFT GmbH IT-Systeme, Brandenburger Str. 7c, 31789 Hameln
AG Hannover HRB 207 694 - Geschäftsführer: Andreas Muchow

_______________________________________________
support-bugzilla mailing list
support-bugzilla at lists.mozilla.org
https://lists.mozilla.org/listinfo/support-bugzilla
PLEASE put support-bugzilla at lists.mozilla.org in the To: field when you 
reply.