View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0019369 | mantisbt | db mssql | public | 2015-02-14 06:27 | 2024-02-28 10:43 |
Reporter | kamleshk | Assigned To | dregad | ||
Priority | normal | Severity | minor | Reproducibility | have not tried |
Status | closed | Resolution | no change required | ||
Platform | Windows | OS | Windows 2003 | OS Version | Windows 2003 Ent |
Product Version | 1.2.15 | ||||
Summary | 0019369: 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 I am using SQL server 2005, Windows 2003 Ent. Server Please help | ||||
Tags | No 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 >=? 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 >=? 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>( <string>'401', <integer>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>( <string>'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', <Array> { [0] => 80, [1] => 80 } )</td></tr></table></center></td></tr></table></div></body> </html> | ||||
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 ? |
|
Thank you, |
|
Additional, debugging information is needed to help understanding the problem. Please follow these steps:
$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.
If the output does not help you resolving the issue and you need further assistance,
|
|
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. |
|
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. |
|