View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0009104 | mantisbt | filters | public | 2008-04-24 10:41 | 2008-08-11 09:41 |
Reporter | Bithunter | Assigned To | daryn | ||
Priority | normal | Severity | major | Reproducibility | always |
Status | closed | Resolution | fixed | ||
Product Version | 1.2.0a1 | ||||
Target Version | 1.2.0a2 | Fixed in Version | 1.2.0a2 | ||
Summary | 0009104: 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 | ||||
Tags | No tags attached. | ||||
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 | closed | giallu | Filtering query error |
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). |
|
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. |
|
MantisBT: master a6fc0c8f 2008-08-01 01:41 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 |