[freeside-users] view invoice error (voip)

[TCB]

Hi, I am having the following error when i try and view invoices for
customers with voip.

Error executing "SELECT sum(billsec) as billsec_sum FROM cdr  WHERE  (
charged_party = '8683000110'         OR  src = '8683000110'         )  AND
startdate >= 1 AND startdate < 1370504072 ORDER BY acctid ": ERROR:  column
"cdr.acctid" must appear in the GROUP BY clause or be used in an aggregate
function LINE 1: ...D startdate >= 1 AND startdate < 1370504072 ORDER BY
acctid

anyone come across it. The full error is here. http://pastebin.ca/2393559
-- 
TC
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://freeside.biz/pipermail/freeside-users/attachments/20130608/cfac909e/attachment.html>