View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0003853 | mantisbt | filters | public | 2004-05-18 08:43 | 2004-08-29 01:52 |
Reporter | vboctor | Assigned To | vboctor | ||
Priority | normal | Severity | major | Reproducibility | sometimes |
Status | closed | Resolution | fixed | ||
Product Version | git trunk | ||||
Fixed in Version | 0.19.0rc1 | ||||
Summary | 0003853: Filters sometime generate an invalid query | ||||
Description | When I try to view all the reports I wrote, the system will return the attached error message: APPLICATION ERROR 0000401 WHERE mantis_project_table.enabled = 1 AND mantis_project_table.id = mantis_bug_table.project_id AND ((mantis_bug_table.project_id='6') OR (mantis_bug_table.project_id='4') OR (mantis_bug_table.project_id='13') OR (mantis_bug_table.project_id='2') OR (mantis_bug_table.project_id='21') OR (mantis_bug_table.project_id='1') OR (mantis_bug_table.project_id='10') OR (mantis_bug_table.project_id='12') OR (mantis_bug_table.project_id='9') OR (mantis_bug_table.project_id='18') OR (mantis_bug_table.project_id='3') OR (mantis_bug_table.project_id='19') OR (mantis_bug_table.project_id='17') OR (mantis_bug_table.project_id='11') OR (mantis_bug_table.project_id='8') OR (mantis_bug_table.project_id='5')) AND (mantis_bug_table.reporter_id='17') ORDER BY ASC Please use the "Back" button in your web browser to return to the previous page. There you can correct whatever problems were identified in this error or select another action. You can also click an option from the menu bar to go directly to a new section. | ||||
Tags | No tags attached. | ||||
I forgot to highlight the problem. Note the "ORDER BY ASC". This happens when the "sort" attribute is passed as blank. I fixed the SQL error in CVS. The fix will be included in 0.19.0. The fix I applied sets the sort field to "last_updated" and the order to "desc" if the sort field was found to be blank. The root problem still has to be fixed, but this fixes the symptoms. This is also needed to avoid SQL errors for filters saved in user dbs. |
|
Reminder sent to Narcissus Narcissus, what do you think about this one? |
|
What still needs to be done to resolve this? |
|