[freeside-users] view invoice error (voip)

Ivan Kohler ivan at freeside.biz
Wed Jul 24 15:01:05 PDT 2013


On Sat, Jun 08, 2013 at 11:54:57PM +0200, TCB wrote:
> 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.

No.

Are you perhaps running MySQL or an older version of PostgreSQL?  It 
would have been useful to post your database, Freeside version and other 
relevant information as requested in the mailing list guidelines.

-- 
_ivan


More information about the freeside-users mailing list