0020896: APPLICATION ERROR #401 with view Issues - all Projects - MantisBT

ID	Project	Category	View Status	Date Submitted	Last Update
0020896	mantisbt	bugtracker	public	2016-05-11 03:52	2016-05-26 05:11

Reporter	tegger	Assigned To	cproensa
Priority	normal	Severity	major	Reproducibility	always
Status	closed	Resolution	duplicate
Platform	x64	OS	Windows	OS Version	Server 2008R2
Product Version	1.3.0-rc.1

Summary	0020896: APPLICATION ERROR 0000401 with view Issues - all Projects
Description	Hi, i got a 401 with no-admin users with "view Issues" in combination with "all projects". Server is IIS 7.5 -- PHP 5.6.21 -- Postgres 9.3.4
Steps To Reproduce	no-admin user view issues change to all projects
Additional Information	APPLICATION ERROR 0000401 Datenbankabfrage fehlgeschlagen. Die Reportmeldung lautet #-1: FEHLER: konnte Datentyp von Parameter $1 nicht ermitteln für die Abfrage: SELECT p.id, p.name, ph.parent_id FROM mantismodern_project_table p LEFT JOIN mantismodern_project_user_list_table u ON p.id=u.project_id AND u.user_id=$2 LEFT JOIN mantismodern_project_hierarchy_table ph ON ph.child_id = p.id WHERE p.enabled = $3 AND ( p.view_state=$4 OR (p.view_state=$5 AND u.user_id=$6 ) ) ORDER BY p.name. Bitte benutzen Sie die „Zurück“-Taste Ihres Browsers, um auf die vorhergehende Seite zurückzukehren. Dort können Sie den hier angezeigten Eintrag korrigieren oder eine andere Aktion ausführen. Über das Menü können Sie auch direkt zu einer anderen Aktion wechseln.
Tags	No tags attached.
Attached Files	MantisError401_all_projects.html (18,248 bytes) <!DOCTYPE html> <!-- saved from url=(0059)http://ma24271.iservices.db.de/mantis/view_all_bug_page.php --> <html><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <title>MantisBT</title> <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1"> <meta name="viewport" content="width=device-width, initial-scale=1.0, maximum-scale=1.0, user-scalable=0"> <link rel="stylesheet" type="text/css" href="./MantisError401_all_projects_files/default.css"> <link rel="stylesheet" type="text/css" href="./MantisError401_all_projects_files/jquery-ui-1.11.4.min.css"> <link rel="stylesheet" type="text/css" href="./MantisError401_all_projects_files/common_config.php"> <link rel="stylesheet" type="text/css" href="./MantisError401_all_projects_files/status_config.php"> <link rel="stylesheet" type="text/css" href="./MantisError401_all_projects_files/bootstrap-3.3.5.min.css"> <link rel="stylesheet" type="text/css" href="./MantisError401_all_projects_files/font-awesome-4.4.0.min.css"> <link rel="stylesheet" type="text/css" href="./MantisError401_all_projects_files/ace-fonts.css"> <link rel="stylesheet" type="text/css" href="./MantisError401_all_projects_files/ace.min.css"> <link rel="stylesheet" type="text/css" href="./MantisError401_all_projects_files/ace-mantis.css"> <!--[if lte IE 9]> <link rel="stylesheet" type="text/css" href="http://ma24271.iservices.db.de/mantis/css/ace-part2.min.css" /> <![endif]--> <link rel="stylesheet" type="text/css" href="./MantisError401_all_projects_files/ace-skins.min.css"> <!--[if lte IE 9]> <link rel="stylesheet" type="text/css" href="http://ma24271.iservices.db.de/mantis/css/ace-ie.min.css" /> <![endif]--> <link rel="shortcut icon" href="http://ma24271.iservices.db.de/mantis/images/favicon.ico" type="image/x-icon"> <link rel="search" type="application/opensearchdescription+xml" title="MantisBT: Text Search" href="http://ma24271.iservices.db.de/mantis/browser_search_plugin.php?type=text"> <link rel="search" type="application/opensearchdescription+xml" title="MantisBT: Issue Id" href="http://ma24271.iservices.db.de/mantis/browser_search_plugin.php?type=id"> <script type="text/javascript" src="./MantisError401_all_projects_files/javascript_config.php"></script><style type="text/css">:root #content > #right > .dose > .dosesingle, :root #content > #center > .dose > .dosesingle {display:none !important;}</style> <script type="text/javascript" src="./MantisError401_all_projects_files/javascript_translations.php"></script> <script type="text/javascript" src="./MantisError401_all_projects_files/jquery-2.1.4.min.js"></script> <script type="text/javascript" src="./MantisError401_all_projects_files/jquery-ui-1.11.4.min.js"></script> <script type="text/javascript" src="./MantisError401_all_projects_files/common.js"></script> <script type="text/javascript" src="./MantisError401_all_projects_files/bugFilter.js"></script> </head> <body class="skin-3"> <div class="col-md-12 col-xs-12"><div class="space-20"></div><div class="alert alert-danger"><p class="bold">APPLICATION ERROR #401</p><p>Datenbankabfrage fehlgeschlagen. Die Reportmeldung lautet #-1: FEHLER: konnte Datentyp von Parameter $1 nicht ermitteln für die Abfrage: SELECT p.id, p.name, ph.parent_id<br> FROM mantismodern_project_table p<br> LEFT JOIN mantismodern_project_user_list_table u<br> ON p.id=u.project_id AND u.user_id=$2<br> LEFT JOIN mantismodern_project_hierarchy_table ph<br> ON ph.child_id = p.id<br> WHERE p.enabled = $3 AND <br> ( p.view_state=$4<br> OR (p.view_state=$5<br> AND<br> u.user_id=$6 )<br> ) ORDER BY p.name.</p><div class="error-info">Bitte benutzen Sie die „Zurück“-Taste Ihres Browsers, um auf die vorhergehende Seite zurückzukehren. Dort können Sie den hier angezeigten Eintrag korrigieren oder eine andere Aktion ausführen. Über das Menü können Sie auch direkt zu einer anderen Aktion wechseln.</div><p> </p><table class="width-100"> <tbody><tr> <td>Full path: C:\inetpub\wwwroot\mantis\core\database_api.php</td> </tr> <tr> <td>Line: 450</td> </tr> <tr> <td> <table class="width100" style="table-layout:fixed;"><tbody><tr><th>Variable</th><th>Value</th><th>Type</th></tr><tr><td style="width=20%; word-wrap:break-word; overflow:auto;">p_query</td><td style="width=70%; word-wrap:break-word; overflow:auto;">SELECT p.id, p.name, ph.parent_id FROM mantismodern_project_table p LEFT JOIN mantismodern_project_user_list_table u ON p.id=u.project_id AND u.user_id=$2 LEFT JOIN mantismodern_project_hierarchy_table ph ON ph.child_id = p.id WHERE p.enabled = $3 AND ( p.view_state=$4 OR (p.view_state=$5 AND u.user_id=$6 ) ) ORDER BY p.name</td><td style="width=10%;">string</td></tr> <tr><td style="width=20%; word-wrap:break-word; overflow:auto;">p_limit</td><td style="width=70%; word-wrap:break-word; overflow:auto;">-1</td><td style="width=10%;">integer</td></tr> <tr><td style="width=20%; word-wrap:break-word; overflow:auto;">p_offset</td><td style="width=70%; word-wrap:break-word; overflow:auto;">-1</td><td style="width=10%;">integer</td></tr> <tr><td style="width=20%; word-wrap:break-word; overflow:auto;">g_db_log_queries</td><td style="width=70%; word-wrap:break-word; overflow:auto;"></td><td style="width=10%;">boolean</td></tr> <tr><td style="width=20%; word-wrap:break-word; overflow:auto;">t_db_type</td><td style="width=70%; word-wrap:break-word; overflow:auto;">pgsql</td><td style="width=10%;">string</td></tr> <tr><td style="width=20%; word-wrap:break-word; overflow:auto;">s_check_params</td><td style="width=70%; word-wrap:break-word; overflow:auto;">1</td><td style="width=10%;">boolean</td></tr> <tr><td style="width=20%; word-wrap:break-word; overflow:auto;">t_start</td><td style="width=70%; word-wrap:break-word; overflow:auto;">1462950908.333</td><td style="width=10%;">double</td></tr> <tr><td style="width=20%; word-wrap:break-word; overflow:auto;">t_params</td><td style="width=70%; word-wrap:break-word; overflow:auto;">5</td><td style="width=10%;">integer</td></tr> <tr><td style="width=20%; word-wrap:break-word; overflow:auto;">i</td><td style="width=70%; word-wrap:break-word; overflow:auto;">5</td><td style="width=10%;">integer</td></tr> <tr><td style="width=20%; word-wrap:break-word; overflow:auto;">s_prefix</td><td style="width=70%; word-wrap:break-word; overflow:auto;">mantismodern_</td><td style="width=10%;">string</td></tr> <tr><td style="width=20%; word-wrap:break-word; overflow:auto;">s_suffix</td><td style="width=70%; word-wrap:break-word; overflow:auto;">_table</td><td style="width=10%;">string</td></tr> <tr><td style="width=20%; word-wrap:break-word; overflow:auto;">t_result</td><td style="width=70%; word-wrap:break-word; overflow:auto;"></td><td style="width=10%;">boolean</td></tr> <tr><td style="width=20%; word-wrap:break-word; overflow:auto;">t_elapsed</td><td style="width=70%; word-wrap:break-word; overflow:auto;">0.0156</td><td style="width=10%;">string</td></tr> <tr><td colspan="3" style="word-wrap:break-word"><br><strong>p_arr_parms</strong></td></tr><tr><td colspan="3"><table class="width100" style="table-layout:fixed;"><tbody><tr><th>Variable</th><th>Value</th><th>Type</th></tr><tr><td style="width=20%; word-wrap:break-word; overflow:auto;">0</td><td style="width=70%; word-wrap:break-word; overflow:auto;">4</td><td style="width=10%;">integer</td></tr> <tr><td style="width=20%; word-wrap:break-word; overflow:auto;">1</td><td style="width=70%; word-wrap:break-word; overflow:auto;">1</td><td style="width=10%;">boolean</td></tr> <tr><td style="width=20%; word-wrap:break-word; overflow:auto;">2</td><td style="width=70%; word-wrap:break-word; overflow:auto;">10</td><td style="width=10%;">integer</td></tr> <tr><td style="width=20%; word-wrap:break-word; overflow:auto;">3</td><td style="width=70%; word-wrap:break-word; overflow:auto;">50</td><td style="width=10%;">integer</td></tr> <tr><td style="width=20%; word-wrap:break-word; overflow:auto;">4</td><td style="width=70%; word-wrap:break-word; overflow:auto;">4</td><td style="width=10%;">integer</td></tr> </tbody></table></td></tr><tr><td colspan="3" style="word-wrap:break-word"><br><strong>g_queries_array</strong></td></tr><tr><td colspan="3"><table class="width100" style="table-layout:fixed;"><tbody><tr><th>Variable</th><th>Value</th><th>Type</th></tr><tr><td colspan="3" style="word-wrap:break-word"><br><strong>1</strong></td></tr><tr><td colspan="3"><table class="width100" style="table-layout:fixed;"><tbody><tr><th>Variable</th><th>Value</th><th>Type</th></tr><tr><td style="width=20%; word-wrap:break-word; overflow:auto;">0</td><td style="width=70%; word-wrap:break-word; overflow:auto;"></td><td style="width=10%;">string</td></tr> <tr><td style="width=20%; word-wrap:break-word; overflow:auto;">1</td><td style="width=70%; word-wrap:break-word; overflow:auto;">0.0000</td><td style="width=10%;">string</td></tr> </tbody></table></td></tr><tr><td colspan="3" style="word-wrap:break-word"><br><strong>2</strong></td></tr><tr><td colspan="3"><table class="width100" style="table-layout:fixed;"><tbody><tr><th>Variable</th><th>Value</th><th>Type</th></tr><tr><td style="width=20%; word-wrap:break-word; overflow:auto;">0</td><td style="width=70%; word-wrap:break-word; overflow:auto;"></td><td style="width=10%;">string</td></tr> <tr><td style="width=20%; word-wrap:break-word; overflow:auto;">1</td><td style="width=70%; word-wrap:break-word; overflow:auto;">0.0000</td><td style="width=10%;">string</td></tr> </tbody></table></td></tr><tr><td colspan="3" style="word-wrap:break-word"><br><strong>3</strong></td></tr><tr><td colspan="3"><table class="width100" style="table-layout:fixed;"><tbody><tr><th>Variable</th><th>Value</th><th>Type</th></tr><tr><td style="width=20%; word-wrap:break-word; overflow:auto;">0</td><td style="width=70%; word-wrap:break-word; overflow:auto;"></td><td style="width=10%;">string</td></tr> <tr><td style="width=20%; word-wrap:break-word; overflow:auto;">1</td><td style="width=70%; word-wrap:break-word; overflow:auto;">0.0000</td><td style="width=10%;">string</td></tr> </tbody></table></td></tr><tr><td colspan="3" style="word-wrap:break-word"><br><strong>4</strong></td></tr><tr><td colspan="3"><table class="width100" style="table-layout:fixed;"><tbody><tr><th>Variable</th><th>Value</th><th>Type</th></tr><tr><td style="width=20%; word-wrap:break-word; overflow:auto;">0</td><td style="width=70%; word-wrap:break-word; overflow:auto;"></td><td style="width=10%;">string</td></tr> <tr><td style="width=20%; word-wrap:break-word; overflow:auto;">1</td><td style="width=70%; word-wrap:break-word; overflow:auto;">0.0000</td><td style="width=10%;">string</td></tr> </tbody></table></td></tr><tr><td colspan="3" style="word-wrap:break-word"><br><strong>5</strong></td></tr><tr><td colspan="3"><table class="width100" style="table-layout:fixed;"><tbody><tr><th>Variable</th><th>Value</th><th>Type</th></tr><tr><td style="width=20%; word-wrap:break-word; overflow:auto;">0</td><td style="width=70%; word-wrap:break-word; overflow:auto;"></td><td style="width=10%;">string</td></tr> <tr><td style="width=20%; word-wrap:break-word; overflow:auto;">1</td><td style="width=70%; word-wrap:break-word; overflow:auto;">0.0000</td><td style="width=10%;">string</td></tr> </tbody></table></td></tr><tr><td colspan="3" style="word-wrap:break-word"><br><strong>6</strong></td></tr><tr><td colspan="3"><table class="width100" style="table-layout:fixed;"><tbody><tr><th>Variable</th><th>Value</th><th>Type</th></tr><tr><td style="width=20%; word-wrap:break-word; overflow:auto;">0</td><td style="width=70%; word-wrap:break-word; overflow:auto;"></td><td style="width=10%;">string</td></tr> <tr><td style="width=20%; word-wrap:break-word; overflow:auto;">1</td><td style="width=70%; word-wrap:break-word; overflow:auto;">0.0000</td><td style="width=10%;">string</td></tr> </tbody></table></td></tr><tr><td colspan="3" style="word-wrap:break-word"><br><strong>7</strong></td></tr><tr><td colspan="3"><table class="width100" style="table-layout:fixed;"><tbody><tr><th>Variable</th><th>Value</th><th>Type</th></tr><tr><td style="width=20%; word-wrap:break-word; overflow:auto;">0</td><td style="width=70%; word-wrap:break-word; overflow:auto;"></td><td style="width=10%;">string</td></tr> <tr><td style="width=20%; word-wrap:break-word; overflow:auto;">1</td><td style="width=70%; word-wrap:break-word; overflow:auto;">0.0000</td><td style="width=10%;">string</td></tr> </tbody></table></td></tr><tr><td colspan="3" style="word-wrap:break-word"><br><strong>8</strong></td></tr><tr><td colspan="3"><table class="width100" style="table-layout:fixed;"><tbody><tr><th>Variable</th><th>Value</th><th>Type</th></tr><tr><td style="width=20%; word-wrap:break-word; overflow:auto;">0</td><td style="width=70%; word-wrap:break-word; overflow:auto;"></td><td style="width=10%;">string</td></tr> <tr><td style="width=20%; word-wrap:break-word; overflow:auto;">1</td><td style="width=70%; word-wrap:break-word; overflow:auto;">0.0000</td><td style="width=10%;">string</td></tr> </tbody></table></td></tr><tr><td colspan="3" style="word-wrap:break-word"><br><strong>9</strong></td></tr><tr><td colspan="3"><table class="width100" style="table-layout:fixed;"><tbody><tr><th>Variable</th><th>Value</th><th>Type</th></tr><tr><td style="width=20%; word-wrap:break-word; overflow:auto;">0</td><td style="width=70%; word-wrap:break-word; overflow:auto;"></td><td style="width=10%;">string</td></tr> <tr><td style="width=20%; word-wrap:break-word; overflow:auto;">1</td><td style="width=70%; word-wrap:break-word; overflow:auto;">0.0000</td><td style="width=10%;">string</td></tr> </tbody></table></td></tr><tr><td colspan="3" style="word-wrap:break-word"><br><strong>10</strong></td></tr><tr><td colspan="3"><table class="width100" style="table-layout:fixed;"><tbody><tr><th>Variable</th><th>Value</th><th>Type</th></tr><tr><td style="width=20%; word-wrap:break-word; overflow:auto;">0</td><td style="width=70%; word-wrap:break-word; overflow:auto;"></td><td style="width=10%;">string</td></tr> <tr><td style="width=20%; word-wrap:break-word; overflow:auto;">1</td><td style="width=70%; word-wrap:break-word; overflow:auto;">0.0000</td><td style="width=10%;">string</td></tr> </tbody></table></td></tr><tr><td colspan="3" style="word-wrap:break-word"><br><strong>11</strong></td></tr><tr><td colspan="3"><table class="width100" style="table-layout:fixed;"><tbody><tr><th>Variable</th><th>Value</th><th>Type</th></tr><tr><td style="width=20%; word-wrap:break-word; overflow:auto;">0</td><td style="width=70%; word-wrap:break-word; overflow:auto;"></td><td style="width=10%;">string</td></tr> <tr><td style="width=20%; word-wrap:break-word; overflow:auto;">1</td><td style="width=70%; word-wrap:break-word; overflow:auto;">0.0000</td><td style="width=10%;">string</td></tr> </tbody></table></td></tr><tr><td colspan="3" style="word-wrap:break-word"><br><strong>12</strong></td></tr><tr><td colspan="3"><table class="width100" style="table-layout:fixed;"><tbody><tr><th>Variable</th><th>Value</th><th>Type</th></tr><tr><td style="width=20%; word-wrap:break-word; overflow:auto;">0</td><td style="width=70%; word-wrap:break-word; overflow:auto;"></td><td style="width=10%;">string</td></tr> <tr><td style="width=20%; word-wrap:break-word; overflow:auto;">1</td><td style="width=70%; word-wrap:break-word; overflow:auto;">0.0000</td><td style="width=10%;">string</td></tr> </tbody></table></td></tr><tr><td colspan="3" style="word-wrap:break-word"><br><strong>13</strong></td></tr><tr><td colspan="3"><table class="width100" style="table-layout:fixed;"><tbody><tr><th>Variable</th><th>Value</th><th>Type</th></tr><tr><td style="width=20%; word-wrap:break-word; overflow:auto;">0</td><td style="width=70%; word-wrap:break-word; overflow:auto;"></td><td style="width=10%;">string</td></tr> <tr><td style="width=20%; word-wrap:break-word; overflow:auto;">1</td><td style="width=70%; word-wrap:break-word; overflow:auto;">0.0156</td><td style="width=10%;">string</td></tr> </tbody></table></td></tr></tbody></table></td></tr></tbody></table> </td> </tr> </tbody></table> <p></p><p></p><div class="table-responsive"><table class="table table-bordered table-striped table-condensed"><tbody><tr><th>Filename</th><th>Line</th><th></th><th></th><th>Function</th><th>Args</th></tr><tr><td>C:\inetpub\wwwroot\mantis\core\database_api.php</td><td>450</td><td>-</td><td>-</td><td>trigger_error</td><td>( <string>'401', <integer>256 )</td></tr><tr><td>C:\inetpub\wwwroot\mantis\core\user_api.php</td><td>1027</td><td>-</td><td>-</td><td>db_query</td><td>( <string>'SELECT p.id, p.name, ph.parent_id FROM {project} p LEFT JOIN {project_user_list} u ON p.id=u.project_id AND u.user_id=$2 LEFT JOIN {project_hierarchy} ph ON ph.child_id = p.id WHERE p.enabled = $3 AND ( p.view_state=$4 OR (p.view_state=$5 AND u.user_id=$6 ) ) ORDER BY p.name', <array> { [0] => 4, [1] => true, [2] => 10, [3] => 50, [4] => 4 } )</td></tr><tr><td>C:\inetpub\wwwroot\mantis\core\filter_api.php</td><td>1197</td><td>-</td><td>-</td><td>user_get_accessible_projects</td><td>( <integer>4 )</td></tr><tr><td>C:\inetpub\wwwroot\mantis\view_all_bug_page.php</td><td>71</td><td>-</td><td>-</td><td>filter_get_bug_rows</td><td>( <integer>1, <NULL>NULL, <NULL>NULL, <NULL>NULL, <NULL>NULL, <NULL>NULL, <NULL>NULL, <boolean>true )</td></tr></tbody></table><p></p></div></div> <script type="text/javascript" src="./MantisError401_all_projects_files/bootstrap-3.3.5.min.js"></script> <script type="text/javascript" src="./MantisError401_all_projects_files/ace-extra.min.js"></script> <script type="text/javascript" src="./MantisError401_all_projects_files/ace-elements.min.js"></script> <script type="text/javascript" src="./MantisError401_all_projects_files/ace.min.js"></script> </div> </body></html> MantisError401_all_projects.html (18,248 bytes)

tegger 2016-05-11 05:08 reporter ~0053118	update, the same error with "my view" and change to all projects with non-admin accounts

cproensa 2016-05-14 13:53 developer ~0053138	@tegger: the related bug 0020479 is already open with this problem, so this one is being closed as duplicated. Please follow 0020479 for the proposed patches and eventual resolution.