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

[Anant]

at bottom:-
On Friday 10 July 2015 02:13 PM, Amardeep Singh wrote:
> at bottom:-
>
> On Thursday 09 July 2015 11:41 PM, shirish wrote:
>> Hi all,
>> Should we switch over to bugzilla 5.0 now that its here and now.
>>
>> https://www.bugzilla.org/releases/5.0/release-notes.html
>>
>> https://ftp.mozilla.org/pub/mozilla.org/webtools/bugzilla-5.0.tar.gz
>>
>> Some of the features in the new release look good.
>>
>> Probably this would be the best :-
>>
>> Improved WebServices
>>
>> This release has major improvements in the WebServices interface. One
>> big addition is a new REST-like endpoint alongside the existing
>> XML-RPC and JSON-RPC endpoints. This will allow clients to access
>> Bugzilla data using standard HTTP calls for easy development. Note:
>> XML-RPC and JSON-RPC are deprecated in favor of REST and will likely
>> be removed in the Bugzilla 7.0 release.
>>
>> Also API key support has been added so that API calls will no longer
>> need to use cookies or a user's login and password. Users can create
>> a different API key for each application and revoke API keys that
>> have been compromised or are no longer needed. The API key will
>> simply be passed to each call as credentials.
>>
>> Several methods have been added and existing ones improved to allow
>> returning data that was not available before such as Group.get.
>> Bug.search is now as full featured as the Advanced Query UI allowing
>> for the same searches to be executed. Attachment data such as flags
>> and other metadata can now be updated through the API. Other
>> WebService changes are detailed below.
>>
>> I guess we would probably wait for 5.0.1 or something for the
>> migration although bugzilla instance we have is recent enough so that
>> we should not have much issues.
>>
>> Comments please - @Anant, @Amardeep and all and anybody else who has
>> access to administrating the bugzilla instance.
> I don't see any issue in upgrading. Sooner we upgrade better and
> easier it will be.
>
> @Anant - Can you take this up please and send notification for upgrade.
>
> Thanks,
>
Yesterday night I checked the bugzilla updating process, While updating
it to latest version on my testing machine I faced the below problem.

Update Bugzilla 4.4.5 to 4.4.9 -/Successful//
//
/Update Bugzilla 4.4.9 to 5.0 - 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"] at Bugzilla/DB.pm line 642.
    Bugzilla::DB::bz_add_fks('Bugzilla::DB::Mysql=HASH(0x7b711c8)',
'test_case_components', 'HASH(0x705dac8)', 'HASH(0x7e21008)') called at
Bugzilla/DB.pm line 546
   
Bugzilla::DB::bz_setup_foreign_keys('Bugzilla::DB::Mysql=HASH(0x7b711c8)')
called at Bugzilla/Install/DB.pm line 745
    Bugzilla::Install::DB::update_table_definitions('HASH(0x242ce70)')
called at ./checksetup.pl line 172

It  was due to testopia plugin, So I tried to remove testopia and update
it. But testopia had created foreign key sets in database due to which I
got the same error.

After some research I found this link -
https://bugzilla.mozilla.org/show_bug.cgi?id=600948 ( Having the same
problem )

So finally I commented the line 642 in Bugzilla/DB.pm, and then updated
the bugzilla. It went well, But I am not sure about the impact of
commenting that line.

Please suggest me, what we need to do.


Many thanks,
Anant

-- 
	Anant Saraswat

System Administrator

	Direct: +91 124 4548387
Tel: +91 124 4548383 Ext- 1018
UK: +44 845 0047 142 Ext- 5020

	TBS Website <http://www.techbluesoftware.co.in>
	Techblue Software Pvt. Ltd
The Palms, Plot No 73, Sector 5, IMT Manesar,
Gurgaon- 122050 (Hr.)

www.techbluesoftware.co.in <http://www.techbluesoftware.co.in>

	
	TBS Facebook
<https://www.facebook.com/pages/Techblue-Software-Limited/441777369284888>
TBS Twitter <https://twitter.com/TechbluSoftware> TBS Google+
<https://plus.google.com/+TechblueSoftwareCoIn> TBS Linked In
<https://www.linkedin.com/company/techblue-softwares-pvt-ltd>

TBS Branding <http://www.techbluesoftware.co.in>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.hamaralinux.org/pipermail/hamara-devel/attachments/20150902/d782bce6/attachment.html>