[Bug #97] [Base] Sorting on 'Component#' fails

anthill-daemon <anthill-daemon-+mQDA36h6dWw5LPnMra/[email protected]> Thu, 15 Jan 2004 05:47:21 -0700

Newsgroups	gmane.comp.bug-tracking.anthill.devel
Message-ID	<[email protected]>

http://anthill.vmlinuz.ca/anthill/query.php?bug=97

--- 97	2004-01-15 05:47:21.000000000 -0700
+++ 97.tmp.ElhBJK	2004-01-15 05:47:21.000000000 -0700
@@ -0,0 +1,24 @@
+Bug#       : 97
+Product    : Anthill
+Version    : 0.2.6
+Status     : NEW
+Priority   : Normal
+Component  : Base
+URL        :
+Assigned To: [email protected]
+Reported By: turbo-lqJR/[email protected]
+Type       : PUBLIC
+
+Summary    : Sorting on 'Component#' fails
+
+Comment posted: 2004-01-15 05:47 AM by turbo-lqJR/[email protected]
+
+Results in message:
+
+Database error: Invalid SQL: SELECT * FROM (bugs LEFT JOIN components ON bugs.
+component = components.cid) WHERE product = '3' ORDER BY components.name
+DESC,bugs.bid ASC
+MySQL Error: 1052 (Column: 'product' in where clause is ambiguous)
+Session halted.
+
+

----
You are receiving this notice because you are the assignee, reporter, or a
watcher for this bug report.

_______________________________________________
Anthill-workers mailing list
Anthill-workers-+mQDA36h6dWw5LPnMra/[email protected]
http://vmlinuz.ca/mailman/listinfo/anthill-workers