View Issue Details

WikiRelated ChangesetsJump to Notes
IDProjectCategoryView StatusDate SubmittedLast Update
0009099mantisbtfilterspublic2008-04-23 03:002008-08-11 09:41
Reporteratrol Assigned Todaryn  
PrioritynormalSeverityminorReproducibilityalways
Status closedResolutionfixed 
Product Version1.2.0a1 
Fixed in Version1.2.0a2 
Summary0009099: using advanced filtering leads to APPLICATION ERROR 0000401
Description

start "View Issues Page"
choose Advanced Filter
in Status select from new to assigned
click "Apply Filter"
in Severity select from major to block
click "Apply Filter"

-->

APPLICATION ERROR 0000401

Database query failed. Error received from database was 0001064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3 for the query: SELECT Count(DISTINCT mantis_bug_table.id) as idcnt FROM mantis_project_table, mantis_bug_table

WHERE mantis_project_table.enabled = 1 AND mantis_project_table.id = mantis_bug_table.project_id AND ( ( mantis_bug_table.project_id = 1 ) AND ( ( mantis_bug_table.view_state = 10 ) OR ( mantis_bug_table.reporter_id = 4637 ) ) ) AND ( mantis_bug_table.severity in (60, 70, 80) ) AND ( mantis_bug_table.status in (10, 20, 30, 40, 50, ?, ?, ?) )

TagsNo tags attached.

Activities

daryn

daryn

2008-06-05 09:40

reporter   ~0018015

Last edited: 2008-06-05 11:18

new temporary variable t_where_tmp was not getting reset for each property of the filter. When more than one property had multiple selections the query was looking for a parameter count equal to the current property's selection plus the sum of all previous parameter counts.

Clearing t_where_tmp for each property resolved this issue.

http://mantisbt.svn.sourceforge.net/viewvc/mantisbt?view=rev&revision=5328

Related Changesets

MantisBT: master d5d90291

2008-06-05 09:32

daryn


Details Diff		 Fix bug 0009099. t_where_tmp array should be reset for each property.

git-svn-id: http://mantisbt.svn.sourceforge.net/svnroot/mantisbt/trunk@5328 <a class="text" href="/?p=mantisbt.git;a=object;h=f5dc347c">f5dc347c</a>-c33d-0410-90a0-b07cc1902cb9		 Affected Issues
0009099
mod - core/filter_api.php Diff File