View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0004156 | mantisbt | filters | public | 2004-07-21 05:54 | 2004-08-29 01:47 |
Reporter | grangeway | Assigned To | grangeway | ||
Priority | normal | Severity | minor | Reproducibility | always |
Status | closed | Resolution | fixed | ||
Product Version | 0.19.0a2 | ||||
Fixed in Version | 0.19.0rc1 | ||||
Summary | 0004156: Sql error | ||||
Description | Since adding the 'monitored by' stuff to my view, mssql driver generates a query error on : SELECT COUNT( DISTINCT mantis_bug_table.id ) as count FROM mantis_bug_table, mantis_project_table LEFT JOIN mantis_bug_monitor_table as user_monitor ON user_monitor.bug_id = mantis_bug_table.id WHERE mantis_project_table.enabled = 1 AND mantis_project_table.id = mantis_bug_table.project_id AND (mantis_bug_table.project_id='1') AND (mantis_bug_table.handler_id=0) 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 ((user_monitor.user_id='3')) of: Can we/ don't we need to be doing: FROM mantis_project_table, mantis_bug_table LEFT JOIN mantis_bug_monitor_table instead ? | ||||
Tags | No tags attached. | ||||