[#JRA-5828] Bugzilla search portlet fails when using MSSQL database

JIRA

Bugzilla search portlet fails when using MSSQL database

Created: 03/Feb/05 12:03 AM Updated: 08/Nov/06 10:01 PM

Component/s:

Import / Export

Affects Version/s:

3.0.3

Fix Version/s:

3.1

Time Tracking:

Not Specified

File Attachments:

bugzillasearch.jsp (2 kB)

Participants:	Jeff Turner [Atlassian] and Joshua Standing
Since last comment:	3 years, 28 weeks, 2 days ago
Resolution Date:	03/Feb/05 12:09 AM
Labels:

Description

« Hide

A user reports the the Bugzilla ID search portlet fails when using SQL Server:

javax.servlet.ServletException: SQL Exception while executing the
following:SELECT ID, groupid, FIELDTYPE, FIELD, OLDVALUE, OLDSTRING,
NEWVALUE, NEWSTRING FROM changeitem WHERE FIELD=? AND OLDSTRING=? ORDER
BY groupid desc (The text, ntext, and image data types cannot be
compared or sorted, except when using IS NULL or LIKE operator.)
at
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageCont
extImpl.java:867)
at
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContex
tImpl.java:800)
at
org.apache.jsp.bugzillasearch_jsp._jspService(bugzillasearch_jsp.java:86
)
at
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:133)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.ja
va:311)
at
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:301)
at
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:248)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tionFilterChain.java:284)
at
....

All

Comments

Work Log

Change History

Sort Order:

[ Permlink | « Hide ]

Jeff Turner [Atlassian] added a comment - 03/Feb/05 12:05 AM

Attached is a replacement for atlassian-jira/bugzillasearch.jsp which should fix this.

[ Permlink | « Hide ]

Joshua Standing added a comment - 11/Feb/05 02:04 PM

That attachment does not help me with my SQL Server database.

My current workorder is to put this code into the General Configuration\Introduction:

<b>Welcome to [My Company]'s JIRA issue tracker!</b>
<br><br>
The [Project name] project was migrated from <a href=http://bugs.mybugzillasite.com/cardinal>Bugzilla</a>. If you had a Bugzilla account, you may log in using the same username (usually your email address) and password. You can search for issues by using the input field below.
<br><br>
<table class=tableBorder border="0" cellpadding="0" cellspacing="0" width="100%"><tr><td>
<table border="0" cellpadding="3" cellspacing="1" width="100%">
<tr class=rowHeader>
<td class="colHeaderLink" colspan="2">
Search by Bugzilla ID
</td>
</tr>
<tr>
<td class=rowAlternate width="20%">
<b><a href=# OnClick="top.location.href='http://bugs.mybugzillasite.com/cardinal/show_bug.cgi?id=' + bugId.value">Bugzilla</a> ID</b>
</td>
<td class=rowNormal>
<form action="IssueNavigator.jspa?" name="filterform" method="post">
<input type="hidden" name="refreshFilter" value="false"></input>
<input type="hidden" name="reset" value="update"></input>
<input type="hidden" name="pid" value="10010"/></input>
<input type="text" name="customfield_10000" value="" size="10"></input>
</form>
</td>
</tr>
</table>
</td>
</tr>
</table>

[ Permlink | « Hide ]

Joshua Standing added a comment - 11/Feb/05 02:18 PM

I apologize - the fix DOES work for my SQL Server database.
I wanted to list the workaround as an alternate method.