View Issue Details

WikiRelated ChangesetsJump to Notes
IDProjectCategoryView StatusDate SubmittedLast Update
0009104mantisbtfilterspublic2008-04-24 10:412008-08-11 09:41
ReporterBithunter Assigned Todaryn  
PrioritynormalSeveritymajorReproducibilityalways
Status closedResolutionfixed 
Product Version1.2.0a1 
Target Version1.2.0a2Fixed in Version1.2.0a2 
Summary0009104: Last page of search results not showing because of error 401
Description

On this install of Mantis (http://www.mantisbt.org/bugs) search "tag", and go to page 5 of results.

You'll get:

APPLICATION ERROR 0000401

Ha fallado la consulta a la base de datos. El error devuelto por la base de datos fue 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 ') GROUP BY bug_id' at line 1 para la consulta: SELECT DISTINCT bug_id,MAX(last_modified) as last_modified, COUNT(last_modified) as count FROM mantis_bugnote_table WHERE mantis_bugnote_table.bug_id in () GROUP BY bug_id

TagsNo tags attached.

Relationships

has duplicate 0009146 closed APPLICATION ERROR 0000401 http://www.mantisbt.org/bugs/view_all_bug_page.php?page_number=4 filter: search: Summary page 
has duplicate 0009385 closedgiallu Filtering query error 

Activities

daryn

daryn

2008-04-25 10:04

reporter   ~0017689

This is due to a bug in filter api where the bug count is incorrect. When searching by text the second bugnote search also includes the bug text searches but the counts for each are added together. The error comes because the number of pages is calculated from the bug count and there are no bugs on the last page(s).
daryn

daryn

2008-08-01 01:46

reporter   ~0018979

Fixed in http://mantisbt.svn.sourceforge.net/viewvc/mantisbt?view=rev&revision=5475. searching for numbers in the text field now searches all the normal text field but also correctly searches the bug id and bugnote id fields.

Related Changesets

MantisBT: master a6fc0c8f

2008-08-01 01:41

daryn


Details Diff		 Fix for bug 0009104. Broken bug count in filter.

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