The following patch fixes an issue when going to Configuration -> BIOS, where qa.aid needs to be part of the GROUP BY:

*** /tmp/quotes.module  Fri Oct 28 16:13:09 2011
--- quotes.module       Fri Oct 28 16:14:06 2011
***************
*** 2126,2132 ****
    $q_alias = $sql -> leftjoin('quotes', 'q', "q.aid = qa.aid");
    $count_alias = $sql->addExpression('COUNT(q.nid)', 'count');
    $sql
!     ->groupBy('name')
      ->orderBy('name', 'DESC');
  
    $result = $sql->execute()->fetchAll();
--- 2126,2132 ----
    $q_alias = $sql -> leftjoin('quotes', 'q', "q.aid = qa.aid");
    $count_alias = $sql->addExpression('COUNT(q.nid)', 'count');
    $sql
!     ->groupBy('name, qa.aid')
      ->orderBy('name', 'DESC');
  
    $result = $sql->execute()->fetchAll();

Comments

ctmattice1’s picture

Status: Needs review » Fixed

New dev release out. Thanks @hubScrappy

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.

Anonymous’s picture

Issue summary: View changes

forgot to wrap it in