0003246: Query fails - generating list of bugs

ID	Project	Category	View Status	Date Submitted	Last Update
0003246	mantisbt	bugtracker	public	2003-07-30 09:58	2003-12-13 04:36

Reporter	doug	Assigned To	aarjona
Priority	normal	Severity	block	Reproducibility	always
Status	closed	Resolution	duplicate

Summary	0003246: Query fails - generating list of bugs
Description	When generating ( what I assume is going to be ) the list of bugs. That is, click on "View Bugs"
Additional Information	This is the error report: Mantis - PExOD - Public APPLICATION ERROR 0000401: ERROR: Database query failed. (database_api.php: line 86) 1064 You have an error in your SQL syntax near 'DISTINCT ( mantis_bug_table.id ) ) as count FROM mantis_bug_table, mantis_projec' at line 1 SELECT COUNT( DISTINCT ( mantis_bug_table.id ) ) as count FROM mantis_bug_table, mantis_project_table 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.status<>'90') This is the result of "mysql> status;": mysql Ver 11.15 Distrib 3.23.39, for -freebsd4.3 (i386)
Tags	No tags attached.

aarjona 2003-07-30 16:05 reporter ~0004472	I just put the query through several MySQL installs, both on Windows and on Linux, and it runs normally.Any idea of how can we reproduce the problem? The query itself looks pretty normal. Are there any special MySQL settings in your config file or was it compiled with any special options?

doug2 2003-07-30 20:56 reporter ~0004473	I don't know how the install was set up - how it might have been compiled, etc., however, there doesn't appear to be a "my.cnf" anywhere on the machine.

aarjona 2003-08-05 18:42 reporter ~0004490	This bug has been fixed along with 0003219