Closed (fixed)
Project:
Quotes
Version:
7.x-1.x-dev
Component:
Code
Priority:
Normal
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
28 Oct 2011 at 16:16 UTC
Updated:
30 Mar 2012 at 19:30 UTC
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
Comment #1
ctmattice1 commentedNew dev release out. Thanks @hubScrappy
Comment #2.0
(not verified) commentedforgot to wrap it in