| asterisk2billing.org http://forum.asterisk2billing.org/ |
|
| Postgresql error in Export Call Plan with LCR http://forum.asterisk2billing.org/viewtopic.php?f=34&t=10503 |
Page 1 of 1 |
| Author: | fpoprogsis [ Mon Sep 23, 2013 9:23 am ] |
| Post subject: | Postgresql error in Export Call Plan with LCR |
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 !!! |
|
| Page 1 of 1 | All times are UTC |
| Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group http://www.phpbb.com/ |
|