<html>
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">at bottom:-
<br>
On Friday 10 July 2015 02:13 PM, Amardeep Singh wrote:<br>
</div>
<blockquote cite="mid:559FC4FC.8020407@hamaralinux.org" type="cite">at
bottom:-
<br>
<br>
On Thursday 09 July 2015 11:41 PM, shirish wrote:
<br>
<blockquote type="cite">Hi all,
<br>
Should we switch over to bugzilla 5.0 now that its here and now.
<br>
<br>
<a class="moz-txt-link-freetext" href="https://www.bugzilla.org/releases/5.0/release-notes.html">https://www.bugzilla.org/releases/5.0/release-notes.html</a>
<br>
<br>
<a class="moz-txt-link-freetext" href="https://ftp.mozilla.org/pub/mozilla.org/webtools/bugzilla-5.0.tar.gz">https://ftp.mozilla.org/pub/mozilla.org/webtools/bugzilla-5.0.tar.gz</a>
<br>
<br>
Some of the features in the new release look good.
<br>
<br>
Probably this would be the best :-
<br>
<br>
Improved WebServices
<br>
<br>
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.
<br>
<br>
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.
<br>
<br>
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.
<br>
<br>
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.
<br>
<br>
Comments please - @Anant, @Amardeep and all and anybody else who
has access to administrating the bugzilla instance.
<br>
</blockquote>
I don't see any issue in upgrading. Sooner we upgrade better and
easier it will be.
<br>
<br>
@Anant - Can you take this up please and send notification for
upgrade.
<br>
<br>
Thanks,
<br>
<br>
</blockquote>
Yesterday night I checked the bugzilla updating process, While
updating it to latest version on my testing machine I faced the
below problem.<br>
<br>
Update Bugzilla 4.4.5 to 4.4.9 -<font color="#33ff33"> <font
color="#009900"><i>Successful</i></font></font><i><font
color="#009900"> </font><br>
</i><i><br>
</i>Update Bugzilla 4.4.9 to 5.0 - <font color="#ff0000">Error</font><br>
<small><br>
Adding foreign key: test_case_components.component_id -><br>
components.id...<br>
DBD::mysql::db do failed: Can't create table
'hamarabugzilla.#sql-65f_79' (errno: 150) [for Statement "ALTER
TABLE test_case_components ADD <br>
CONSTRAINT fk_test_case_components_component_id_components_id
FOREIGN KEY (component_id)<br>
REFERENCES components(id)<br>
ON UPDATE CASCADE ON DELETE CASCADE"] at Bugzilla/DB.pm line
642.<br>
Bugzilla::DB::bz_add_fks('Bugzilla::DB::Mysql=HASH(0x7b711c8)',
'test_case_components', 'HASH(0x705dac8)', 'HASH(0x7e21008)')
called at Bugzilla/DB.pm line 546<br>
Bugzilla::DB::bz_setup_foreign_keys('Bugzilla::DB::Mysql=HASH(0x7b711c8)')
called at Bugzilla/Install/DB.pm line 745<br>
Bugzilla::Install::DB::update_table_definitions('HASH(0x242ce70)')
called at ./checksetup.pl line 172</small><br>
<br>
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.<br>
<br>
After some research I found this link -
<a class="moz-txt-link-freetext" href="https://bugzilla.mozilla.org/show_bug.cgi?id=600948">https://bugzilla.mozilla.org/show_bug.cgi?id=600948</a> ( Having the
same problem )<br>
<br>
So finally I commented the line 642 in <big> </big>Bugzilla/DB.pm,
and then updated the bugzilla. It went well, But I am not sure about
the impact of commenting that line. <br>
<br>
Please suggest me, what we need to do.<br>
<br>
<br>
Many thanks,<br>
Anant<br>
<br>
<div class="moz-signature">-- <br>
<table cellpadding="0" cellspacing="0" border="0" width="100%">
<style type="text/css">
@import url(<a class="moz-txt-link-freetext" href="http://fonts.googleapis.com/css?family=Lato:300,400,600,800">http://fonts.googleapis.com/css?family=Lato:300,400,600,800</a>);
a { text-decoration: none; }
.appleLinks a {color:#28336C;}
</style> <tbody>
<tr>
<td align="left" bgcolor="#fff" valign="top">
<table cellpadding="0" cellspacing="0" align="left"
border="0" width="300">
<tbody>
<tr>
<td style="font-size:0; line-height:0;" align="left"
bgcolor="#fff" valign="top" width="12"> <img
src="http://www.techbluesoftware.co.in/documents/15491/115033/spacer7.gif"
moz-do-not-send="true" alt="" height="1"
width="12"> </td>
<td style=" font-family:'Lato', Helvetica, Arial,
sans-serif; font-size:16px; color:#2d5259;
line-height:18px; padding:0px;
background-color:#FFFFFF" align="left"
valign="top"> <font style="font-weight:bold;
color:#28336C;">Anant Saraswat<br>
</font>
<p style="font-size:14px; font-weight:bold;
color:#A9A918; text-decoration:none; margin:0;
padding:0">System Administrator<br>
</p>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
<tr>
<td style="font-size:0; line-height:0;" align="left"
bgcolor="#fff" valign="top"> <img
src="http://www.techbluesoftware.co.in/documents/15491/115033/spacer6.gif"
moz-do-not-send="true" alt="" height="10" width="1"></td>
</tr>
<tr>
<td align="left" bgcolor="#fff" valign="top">
<table cellpadding="0" cellspacing="0" align="left"
border="0" width="300">
<tbody>
<tr>
<td style="font-size:0; line-height:0;" align="left"
bgcolor="#fff" valign="top" width="12"> <img
src="http://www.techbluesoftware.co.in/documents/15491/115033/spacer7.gif"
moz-do-not-send="true" alt="" height="1"
width="12"> </td>
<td style=" font-family:'Lato', Helvetica, Arial,
sans-serif; font-size:12px; color:#2d5259;
line-height:18px; padding:0px;
background-color:#FFFFFF" align="left"
valign="top"> <font style=" color:#28336C;">Direct:
+91 124 4548387</font><br>
<font style=" color:#28336C;">Tel: +91 124 4548383
Ext- 1018</font><br>
<font style=" color:#28336C;">UK: +44 845 0047 142
Ext- 5020</font><br>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
<tr>
<td style="font-size:0; line-height:0;" align="left"
bgcolor="#fff" valign="top"> <img
src="http://www.techbluesoftware.co.in/documents/15491/115033/spacer6.gif"
moz-do-not-send="true" alt="" height="10" width="1"></td>
</tr>
<tr>
<td style="font-size:0; line-height:0;" align="left"
bgcolor="#fff" valign="top"> <img
src="http://www.techbluesoftware.co.in/documents/15491/115033/spacer7.gif"
moz-do-not-send="true" alt="" height="18" width="1"></td>
</tr>
<tr>
<td style=" padding:0px" align="left" bgcolor="#fff"
valign="top">
<table style="padding:0px" cellpadding="0" cellspacing="0"
align="left" border="0" width="280">
<tbody>
<tr>
<td style="font-size:0; line-height:0;" align="left"
bgcolor="#fff" valign="top" width="12"> <img
src="http://www.techbluesoftware.co.in/documents/15491/115033/spacer6.gif"
moz-do-not-send="true" alt="" height="1"
width="12"> </td>
<td style="padding:0; margin:0" align="left"
valign="top" width="280"> <a
href="http://www.techbluesoftware.co.in"><img
src="http://www.techbluesoftware.co.in/documents/15491/115033/tbs-logo.gif"
moz-do-not-send="true" alt="TBS Website"
style="padding:0" border="0" width="87"></a> </td>
</tr>
<tr>
<td style="font-size:0; line-height:0;" align="left"
bgcolor="#fff" valign="top"> <img
src="http://www.techbluesoftware.co.in/documents/15491/115033/spacer7.gif"
moz-do-not-send="true" alt="" height="18"
width="1"> </td>
</tr>
<tr>
<td style="font-size:0; line-height:0;" align="left"
bgcolor="#fff" valign="top" width="12"> <img
src="http://www.techbluesoftware.co.in/documents/15491/115033/spacer6.gif"
moz-do-not-send="true" alt="" height="1"
width="12"> </td>
<td style=" width:300px; font-size:12px;
font-family:'Lato', Helvetica, Arial, sans-serif;
font-weight:bold; color:#28336C;
line-height:14px;" align="left" valign="top">Techblue
Software Pvt. Ltd<br>
<span style="color:#28336C; font-size:12px;
line-height:16px; font-weight:normal">The Palms,
Plot No 73, Sector 5, IMT Manesar,<br>
Gurgaon- 122050 (Hr.)<br>
</span>
<p style="font-weight:bold; padding:0;
margin-top:5px; font-size:12px
text-decoration:none;"><a
href="http://www.techbluesoftware.co.in"
style="text-decoration:none; color:#28336C; ">www.techbluesoftware.co.in</a></p>
</td>
<td style="color:#28336C; font-size:10px;
line-height:16px"> <br>
</td>
</tr>
<tr>
<td style="font-size:0; line-height:0;" align="left"
bgcolor="#fff" valign="top" width="12"> <img
src="http://www.techbluesoftware.co.in/documents/15491/115033/spacer6.gif"
moz-do-not-send="true" alt="" height="1"
width="12"> </td>
<td style="padding-top:10px" align="left"
valign="top" width="196"> <a
href="https://www.facebook.com/pages/Techblue-Software-Limited/441777369284888"><img
src="http://www.techbluesoftware.co.in/documents/15491/115033/fb.gif"
moz-do-not-send="true" nosend="1" alt="TBS
Facebook" title="TBS Facebook" border="0"
height="25" width="25"></a> <a
href="https://twitter.com/TechbluSoftware"><img
src="http://www.techbluesoftware.co.in/documents/15491/115033/tweet.gif"
moz-do-not-send="true" nosend="1" alt="TBS
Twitter" title="TBS Twitter" border="0"
height="25" width="25"></a> <a
href="https://plus.google.com/+TechblueSoftwareCoIn"><img
src="http://www.techbluesoftware.co.in/documents/15491/115033/google-plus.gif"
moz-do-not-send="true" nosend="1" alt="TBS
Google+" title="TBS Google+" border="0"
height="25" width="25"></a> <a
href="https://www.linkedin.com/company/techblue-softwares-pvt-ltd"><img
src="http://www.techbluesoftware.co.in/documents/15491/115033/in.gif"
moz-do-not-send="true" nosend="1" alt="TBS
Linked In" title="TBS Linked In" border="0"
height="25" width="25"></a> </td>
</tr>
</tbody>
</table>
<table style="padding-left:0px; width:298px"
valign="bottom" cellpadding="0" cellspacing="0"
align="right" border="0">
<tbody>
<tr>
<td style="font-size:0; line-height:0;"
align="right" bgcolor="#fff" valign="bottom"> <img
src="http://www.techbluesoftware.co.in/documents/15491/115033/spacer7.gif"
moz-do-not-send="true" alt="" height="30"
width="1"></td>
</tr>
<tr>
<td style=" margin:0; width:320px; " align="right"
valign="bottom"> <a
href="http://www.techbluesoftware.co.in"><img
src="http://www.techbluesoftware.co.in/documents/15491/115033/tech_circle.gif"
moz-do-not-send="true" alt="TBS Branding"
height="136" width="320"></a> </td>
</tr>
</tbody>
</table>
</td>
</tr>
<tr>
<td style="font-size:0; line-height:0;" align="left"
bgcolor="#fff" valign="top"> <img
src="http://www.techbluesoftware.co.in/documents/15491/115033/spacer7.gif"
moz-do-not-send="true" alt="" height="18" width="1"></td>
</tr>
</tbody>
</table>
</div>
</body>
</html>