<html>
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">inline :-<br>
On Wednesday 02 September 2015 02:58 PM, shirish wrote:<br>
</div>
<blockquote cite="mid:55E7008E.5090905@hamaralinux.org" type="cite">at
bottom :-
<br>
<br>
On Wednesday 02 September 2015 04:25 PM, Vikas Tara wrote:
<br>
<blockquote type="cite">On 02/09/15 11:19, Anant wrote:
<br>
<blockquote type="cite">Please suggest me, what we need to do.
<br>
</blockquote>
We have not used testopia at all - would suggest removing it
altogether
<br>
and then trying the upgrade.
<br>
</blockquote>
</blockquote>
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.<br>
<br>
<small>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) <br>
[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"]</small><br>
<br>
<blockquote cite="mid:55E7008E.5090905@hamaralinux.org" type="cite">
<blockquote type="cite">
<br>
I don't think we really need it do we?
<br>
<br>
</blockquote>
<br>
Went through the bug that Anant shared. AFAIK testoptia is an
optional plug-in. I do know and remember that was talk of people
writing test-cases and running them.
<br>
<br>
I would suggest we go for it, just need to mail a statement that
we would be upgrading bugzilla and hence bugzilla instance would
be down for sometime and once it's up, sharing the same and asking
people to mail if they come across any issues.
<br>
<br>
Incidentally, at the first time I was going through bugzilla, I
had wondered why bugzilla is not in Debian and then saw #638705
and #669643 in the debian BTS.
<br>
<br>
There could be a case of debian-packaging bugzilla 5 as well if
hamara wants to go for it, it would be a real contribution to
Debian and could be considered once bugzilla has been updated on
our own server.
<br>
<br>
The two main features that would come are with the new version are
:-
<br>
<br>
a. Being able to see number of recent bugs filed at a glance (so
we know which new bugs were filed and when.)
<br>
<br>
b. Being able to mail replies to bugzilla instead of having to go
to the relevant page. So people like me who like mail interfaces
better rather than bugzilla pages could do it from one interface.
<br>
<br>
Look forward to seeing the new version on hamara server soonish.
<br>
<br>
</blockquote>
<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>