View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0002018 | mantisbt | bugtracker | public | 2002-05-22 11:10 | 2003-12-13 05:03 |
| Reporter | Assigned To | aarjona | |||
| Priority | normal | Severity | crash | Reproducibility | always |
| Status | closed | Resolution | duplicate | ||
| Platform | x86 | OS | Windows | OS Version | 98 |
| Product Version | 0.17.3 | ||||
| Summary | 0002018: ERROR Screen when filtering 'Reporter' and 'Search'. | ||||
| Description | When filtering the database by choosing a reporter (in the first pull down menu) AND having something in the "search" field (anything will do), the following error pops up: "ERROR: FAILED QUERY: SELECT COUNT( DISTINCT ( mantis_bug_table.id ) ) as count FROM mantis_bug_table, mantis_bug_text_table LEFT JOIN mantis_bugnote_table ON mantis_bugnote_table.bug_id = mantis_bug_table.id LEFT JOIN mantis_bugnote_text_table ON mantis_bugnote_text_table.id = mantis_bugnote_table.bugnote_text_id WHERE project_id='0000002' AND reporter_id='0000032' AND status<>'90' AND ((summary LIKE '%testsearch%') OR (description LIKE '%testsearch%') OR (steps_to_reproduce LIKE '%testsearch%') OR (additional_information LIKE '%testsearch%') OR (mantis_bug_table.id LIKE '%testsearch%') OR (mantis_bugnote_text_table.note LIKE '%testsearch%')) AND mantis_bug_text_table.id = mantis_bug_table.bug_text_id : | ||||
| Steps To Reproduce |
| ||||
| Additional Information | This can be duplicated on the mantisbt bugtracker here as well as my system. | ||||
| Tags | No tags attached. | ||||