View Issue Details

IDProjectCategoryView StatusLast Update
0019369mantisbtdb mssqlpublic2024-02-28 10:43
Reporterkamleshk Assigned Todregad  
PrioritynormalSeverityminorReproducibilityhave not tried
Status closedResolutionno change required 
PlatformWindows OSWindows 2003OS VersionWindows 2003 Ent
Product Version1.2.15 
Summary0019369: Error when click on Summary link
Description

When I select particular project and click on Summary link i get below error.

APPLICATION ERROR 0000401

Database query failed. Error received from database was 0000245: Conversion failed when converting the varchar value 'NotSpecified' to data type int. for the query: SELECT b.id, b.date_submitted, b.last_updated, MAX(h.date_modified) as hist_update, b.status
FROM mantis_bug_table b LEFT JOIN mantis_bug_history_table h
ON b.id = h.bug_id AND h.type=0 AND h.field_name='status' AND h.new_value=?
WHERE b.status >=? AND project_id=8
GROUP BY b.id, b.status, b.date_submitted, b.last_updated
ORDER BY b.id ASC.

I am using SQL server 2005, Windows 2003 Ent. Server

Please help

TagsNo tags attached.
Attached Files
error.htm (5,665 bytes)   
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>
	<link rel="stylesheet" type="text/css" href="http://spvss/mantisbt/css/default.css" />
	<script type="text/javascript"><!--
		if(document.layers) {document.write("<style>td{padding:0px;}<\/style>")}
	// --></script>
	<meta http-equiv="Content-type" content="text/html; charset=utf-8" />
	<meta http-equiv="Pragma" content="no-cache" />
	<meta http-equiv="Cache-Control" content="no-cache" />
	<meta http-equiv="Pragma-directive" content="no-cache" />
	<meta http-equiv="Cache-Directive" content="no-cache" />
	<meta http-equiv="Expires" content="Mon, 16 Feb 2015 13:14:12 GMT" />
	<link rel="shortcut icon" href="/mantisbt/images/favicon.ico" type="image/x-icon" />
	<link rel="search" type="application/opensearchdescription+xml" title="MantisBT: Text Search" href="http://spvss/mantisbt/browser_search_plugin.php?type=text" />	<link rel="search" type="application/opensearchdescription+xml" title="MantisBT: Issue Id" href="http://spvss/mantisbt/browser_search_plugin.php?type=id" />	<title>MantisBT</title>
<script type="text/javascript" src="/mantisbt/javascript/min/common.js"></script>
<script type="text/javascript">var loading_lang = "Loading...";</script><script type="text/javascript" src="/mantisbt/javascript/min/ajax.js"></script>
</head>
<body>
<div align="left"><a href="my_view_page.php"><img border="0" alt="MantisBT" src="/mantisbt/images/mantis_logo.png" /></a></div><br /><div align="center"><table class="width50" cellspacing="1"><tr><td class="form-title">APPLICATION ERROR #401</td></tr><tr><td><p class="center" style="color:red">Database query failed. Error received from database was #245: Conversion failed when converting the varchar value 'NotSpecified' to data type int. for the query: SELECT b.id, b.date_submitted, b.last_updated, MAX(h.date_modified) as hist_update, b.status<br />
        FROM mantis_bug_table b LEFT JOIN mantis_bug_history_table h<br />
            ON b.id = h.bug_id  AND h.type=0 AND h.field_name='status' AND h.new_value=?<br />
            WHERE b.status &gt;=? AND  project_id=8<br />
            GROUP BY b.id, b.status, b.date_submitted, b.last_updated<br />
            ORDER BY b.id ASC.</p></td></tr><tr><td><p class="center">Please use the "Back" button in your web browser to return to the previous page. There you can correct whatever problems were identified in this error or select another action. You can also click an option from the menu bar to go directly to a new section.</p></td></tr><tr><td>		<center>
			<table class="width75">
				<tr>
					<td>Full path: C:\Inetpub\wwwroot\mantisbt\core\database_api.php</td>
				</tr>
				<tr>
					<td>Line: 405</td>
				</tr>
				<tr>
					<td>
						<table class="width100"><tr><th>Variable</th><th>Value</th><th>Type</th></tr><tr><td>p_query</td><td>SELECT b.id, b.date_submitted, b.last_updated, MAX(h.date_modified) as hist_update, b.status
        FROM mantis_bug_table b LEFT JOIN mantis_bug_history_table h
            ON b.id = h.bug_id  AND h.type=0 AND h.field_name='status' AND h.new_value=?
            WHERE b.status &gt;=? AND  project_id=8
            GROUP BY b.id, b.status, b.date_submitted, b.last_updated
            ORDER BY b.id ASC</td><td>string</td></tr>
<tr><td>p_limit</td><td>-1</td><td>integer</td></tr>
<tr><td>p_offset</td><td>-1</td><td>integer</td></tr>
<tr><td>g_db_log_queries</td><td></td><td>boolean</td></tr>
<tr><td>g_db_param_count</td><td>11</td><td>integer</td></tr>
<tr><td>t_db_type</td><td>mssql</td><td>string</td></tr>
<tr><td>s_check_params</td><td></td><td>boolean</td></tr>
<tr><td>t_result</td><td></td><td>boolean</td></tr>
<tr><td colspan="3" align="left"><br /><strong>arr_parms</strong></td></tr><tr><td colspan="3"><table class="width100"><tr><th>Variable</th><th>Value</th><th>Type</th></tr><tr><td>0</td><td>80</td><td>integer</td></tr>
<tr><td>1</td><td>80</td><td>integer</td></tr>
</table></td></tr><tr><td colspan="3" align="left"><br /><strong>g_queries_array</strong></td></tr><tr><td colspan="3"><table class="width100"><tr><th>Variable</th><th>Value</th><th>Type</th></tr><tr><td>0</td><td>1</td><td>integer</td></tr>
<tr><td>1</td><td>1</td><td>integer</td></tr>
<tr><td>2</td><td>1</td><td>integer</td></tr>
<tr><td>3</td><td>1</td><td>integer</td></tr>
<tr><td>4</td><td>1</td><td>integer</td></tr>
<tr><td>5</td><td>1</td><td>integer</td></tr>
<tr><td>6</td><td>1</td><td>integer</td></tr>
<tr><td>7</td><td>1</td><td>integer</td></tr>
<tr><td>8</td><td>1</td><td>integer</td></tr>
</table></td></tr></table>					</td>
				</tr>
			</table>
		</center>
</td></tr><tr><td><center><table class="width75"><tr><th>Filename</th><th>Line</th><th></th><th></th><th>Function</th><th>Args</th></tr><tr class="row-1"><td>C:\Inetpub\wwwroot\mantisbt\core\database_api.php</td><td>405</td><td>-</td><td>-</td><td>trigger_error</td><td>( &lt;string&gt;'401', &lt;integer&gt;256 )</td></tr><tr class="row-2"><td>C:\Inetpub\wwwroot\mantisbt\summary_page.php</td><td>55</td><td>-</td><td>-</td><td>db_query_bound</td><td>( &lt;string&gt;'SELECT b.id, b.date_submitted, b.last_updated, MAX(h.date_modified) as hist_update, b.status
        FROM mantis_bug_table b LEFT JOIN mantis_bug_history_table h
            ON b.id = h.bug_id  AND h.type=0 AND h.field_name=\'status\' AND h.new_value=?
            WHERE b.status &gt;=? AND  project_id=8
            GROUP BY b.id, b.status, b.date_submitted, b.last_updated
            ORDER BY b.id ASC', &lt;Array&gt; { [0] =&gt; 80, [1] =&gt; 80 } )</td></tr></table></center></td></tr></table></div></body>
</html>
error.htm (5,665 bytes)   

Activities

dregad

dregad

2015-02-16 03:11

developer   ~0048831

It's difficult to help as I don't have access to a MSSQL instance to test, but I'm wondering where this value 'NotSpecified' is coming from. Is that a custom status you have defined ?

kamleshk

kamleshk

2015-02-16 03:55

reporter   ~0048834

Thank you,
No Sir, We did not added any custom status to it. if you need we can give you remote access through Team Viewer. We are in India.

dregad

dregad

2015-02-16 06:36

developer   ~0048838

Additional, debugging information is needed to help understanding the problem. Please follow these steps:

  1. temporarily configure your system as follows:

$g_show_detailed_errors = ON;

WARNING - SECURITY RISK: the 'show_detailed_errors' config can cause MantisBT to display sensitive information about your system. We recommend to restrict its activation to a Test environment, only for as long as necessary. If possible, do not turn it ON globally, instead limit it for specific user(s) using the Manage Configuration page.

  1. Reproduce the error

If the output does not help you resolving the issue and you need further assistance,

  1. save the output of the error screen, preferably as an HTML page
  2. be careful to remove/mask any confidential information if needed
  3. upload the results here
kamleshk

kamleshk

2015-02-16 08:20

reporter   ~0048839

Thank you sir, I have reproduced the error as per your instruction and attaching the same here as "error.htm" file.

Thanks again for all your help.

dregad

dregad

2024-02-16 20:20

developer   ~0068551

We are resolving this issue as "no change required", because it was reported against an old version of MantisBT which is no longer supported.

We recommend that you upgrade to the latest stable version [1]; if after doing so the problem still exists, do not hesitate to reopen the issue.

[1] http://www.mantisbt.org/download.php