| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0009237 | mantisbt | sql | public | 2008-06-06 19:49 | 2008-08-11 09:41 |
| Reporter | jeremib | Assigned To | daryn | ||
| Priority | normal | Severity | minor | Reproducibility | always |
| Status | closed | Resolution | fixed | ||
| Fixed in Version | 1.2.0a2 | ||||
| Summary | 0009237: When using g_limit_reporters produces SQL error for reporters | ||||
| Description | When using $g_limit_reporters, report "View Issues" receivesDatabase query failed. Error received from database was 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 '? AND mantis_project_table.id = mantis_bug_table.project_id AND ( ( mantis_bug_t' at line 3 for the query: SELECT Count(DISTINCT mantis_bug_table.id) as idcnt FROM mantis_project_table, mantis_bug_table WHERE mantis_project_table.enabled = ? AND mantis_project_table.id = mantis_bug_table.project_id AND ( ( mantis_bug_table.project_id in (42, 32, 38, 31, 45, 34, 43, 30, 1, 9, 28, 36, 35, 39, 40, 41, 44) ) AND ( ( mantis_bug_table.view_state = 10 ) OR ( mantis_bug_table.reporter_id = 19 ) ) ) AND ( mantis_bug_table.handler_id=0 ) AND ( mantis_bug_table.status in (?, ?, ?, ?, ?, ?, ?, ?) ) SQL error: | ||||
| Additional Information | I up'ed to the latest TRUNK after daryn suggested, but still had same outcome. | ||||
| Tags | No tags attached. | ||||
| has duplicate | 0009287 | closed | "Limit reporter access" feature (Broken?) in MANTIS 1.2.0a1 |
 |
variable was incorrectly defined. See http://mantisbt.svn.sourceforge.net/viewvc/mantisbt?view=rev&revision=5335 for change. |
