View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0004260 | mantisbt | filters | public | 2004-08-04 02:55 | 2004-08-29 02:07 |
Reporter | sgrund | Assigned To | vboctor | ||
Priority | normal | Severity | major | Reproducibility | always |
Status | closed | Resolution | fixed | ||
Product Version | 0.19.0a1 | ||||
Fixed in Version | 0.19.0rc1 | ||||
Summary | 0004260: APPLICATION ERROR 0000401 when searching | ||||
Description | When I search a string in view_all_bug_page, I get an APPLICATION ERROR 0000401 (s. Additional Information). | ||||
Additional Information | APPLICATION ERROR 0000401 Database query failed. Error received from database was 0001064: You have an error in your SQL syntax near '(mantis_bug_table LEFT JOIN mantis_bugnote_table ON mantis_bugnote_table.bug_id ' at line 1 for the query: SELECT COUNT( DISTINCT mantis_bug_table.id ) as count FROM mantis_bug_text_table, mantis_project_table ,(mantis_bug_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 mantis_project_table.enabled = 1 AND mantis_project_table.id = mantis_bug_table.project_id AND (mantis_bug_table.project_id='4') AND ((mantis_bug_table.status='10') OR (mantis_bug_table.status='20') OR (mantis_bug_table.status='30') OR (mantis_bug_table.status='40') OR (mantis_bug_table.status='50') OR (mantis_bug_table.status='80')) AND ((summary LIKE '%oak%') | ||||
Tags | No tags attached. | ||||