Return-Path: X-Original-To: apmail-incubator-bloodhound-commits-archive@minotaur.apache.org Delivered-To: apmail-incubator-bloodhound-commits-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 078CA9130 for ; Wed, 11 Apr 2012 12:15:07 +0000 (UTC) Received: (qmail 14187 invoked by uid 500); 11 Apr 2012 12:15:07 -0000 Delivered-To: apmail-incubator-bloodhound-commits-archive@incubator.apache.org Received: (qmail 14166 invoked by uid 500); 11 Apr 2012 12:15:06 -0000 Mailing-List: contact bloodhound-commits-help@incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: bloodhound-dev@incubator.apache.org Delivered-To: mailing list bloodhound-commits@incubator.apache.org Received: (qmail 14158 invoked by uid 99); 11 Apr 2012 12:15:06 -0000 Received: from bloodhound-vm.apache.org (HELO bloodhound-vm) (140.211.11.32) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 11 Apr 2012 12:15:06 +0000 Received: from bloodhound-vm.apache.org (localhost [127.0.0.1]) by bloodhound-vm (Postfix) with ESMTP id C0C65808F3; Wed, 11 Apr 2012 12:15:06 +0000 (UTC) MIME-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 7bit From: "Apache Bloodhound" X-Trac-Version: 0.13dev-r10952 Cc: bloodhound-commits@incubator.apache.org Auto-Submitted: auto-generated X-Mailer: Trac 0.13dev-r10952, by Edgewall Software X-Trac-Project: Apache Bloodhound Date: Wed, 11 Apr 2012 12:15:06 -0000 Reply-To: bloodhound-dev@incubator.apache.org X-URL: https://issues.apache.org/bloodhound/ Subject: [Apache Bloodhound] #30: Default report {7} My Tickets fails for issues.apache.org/bloodhound configuration X-Trac-Ticket-URL: https://issues.apache.org/bloodhound/ticket/30 Message-ID: <052.2e926d324379ca2958c81be7a135bb35@incubator.apache.org> X-Trac-Ticket-ID: 30 #30: Default report {7} My Tickets fails for issues.apache.org/bloodhound configuration -----------------------+------------------------------------- Reporter: gjm | Owner: nobody Type: defect | Status: new Priority: major | Milestone: RC1 for initial release Component: trac core | Version: Keywords: | -----------------------+------------------------------------- Error is: {{{ProgrammingError: for SELECT DISTINCT, ORDER BY expressions must appear in select list}}} I have already modified the report SQL for the issues.apache.org/bloodhound (hopefully correctly) but this does not deal with the underlying problem. The error has already been noted, with possible fixes in trac:comment:13:ticket:9311 I suspect that we will need to modify trunk/trac/trac/db_default.py to provide non-erroring sql for this report and test across all supported databases. -- Ticket URL: Apache Bloodhound The Apache Bloodhound (incubating) issue tracker