[Hamara-devel] should we switch over to bugzilla 5.0 ?

[shirish]

at bottom :-

On Wednesday 02 September 2015 08:04 PM, Anant wrote:
> inline :-
> On Wednesday 02 September 2015 02:58 PM, shirish wrote:
>> at bottom :-
>>
>> On Wednesday 02 September 2015 04:25 PM, Vikas Tara wrote:
>>> On 02/09/15 11:19, Anant wrote:
>>>> Please suggest me, what we need to do.
>>> We have not used testopia at all - would suggest removing it altogether
>>> and then trying the upgrade.
> I have already tried updating bugzilla after removing testopia. But
> testopia had created foreign key sets in database due to which I got the
> same error.
>
> Adding foreign key: test_case_components.component_id ->
> components.id... DBD::mysql::db do failed: Can't create table
> 'hamarabugzilla.#sql-65f_79' (errno: 150)
> [for Statement "ALTER TABLE test_case_components ADD  CONSTRAINT
> fk_test_case_components_component_id_components_id FOREIGN KEY
> (component_id) REFERENCES components(id)  ON UPDATE CASCADE ON DELETE
> CASCADE"]
>

Hi,

@Anant - have shared a probable way to deal with that. See if the way 
thorsten shares would be good.

Otherwise the way forward would be to have a new installation and see if 
the database for the bugs that we have done can be copied/moved.

If that doesn't work out, then would have to do it manually (which is a 
pain I agree.)

Interesting to note that bugzilla doesn't have a way to deal with such 
optional modules/extensions.

Also see 
https://groups.google.com/forum/#!topic/mozilla.support.bugzilla/ybadmmNBSiY 
so this isn't a new issue either, has been there for quite sometime.

So, upto you how do you wanna play it.

-- 
Regards,
Shirish Agarwal,
Community Lead,
Hamaralinux.org