Hello,
I have located an error when installing from scratch A2Billing 2.0 using PostgreSQL. When I try to export call plan with LCR in Rates menu, the SQL query fails with this message:
2013-09-20 17:43:22 CEST ERROR: colum «cc_callplan_lcr.destination» must appear in the GROUP BY clause or be used in an aggregate function
2013-09-20 17:43:22 CEST SENTENCIA: SELECT destination, dialprefix, buyrate, MIN(rateinitial) as rateinitial, startdate, stopdate, initblock, connectcharge, id_trunk , idtariffplan , id FROM cc_callplan_lcr WHERE tariffgroup_id= '3' GROUP BY dialprefix ORDER BY dialprefix ASC LIMIT 10 OFFSET 0
This query is generated in the file FG_var_def_ratecard.inc. I'm trying to adapt it to work well in POSTGRES, but do not know this database manager.
Please, someone could help me?
Thanks !!!
|