Hi!
On the old server billing work good (psql 8.2.X). But when I install billing to new server with Postgresql 8.3, I see this error in debug console of *:
Code:
a2billing.php|1: file:Class.A2Billing.php - line:701 - DESTINATION ::> 38044XXXXXXX
a2billing.php|1: file:Class.A2Billing.php - line:703 - RULES APPLY ON DESTINATION ::> 38044XXXXXXX
a2billing.php|1: file:Class.A2Billing.php - line:739 - ERROR ::> RateEngine didnt succeed to match the dialed number over the ratecard (Please check : id the ratecard is well create ; if the removeInter_Prefix is set according to your prefix in the ratecard ; if you hooked the ratecard to the Call Plan)
-- Playing 'prepaid-dest-unreachable' (escape_digits=#) (sample_offset 0)
a2billing.php|1: file:Class.A2Billing.php - line:654 - [CARD STATUS UPDATE : UPDATE cc_card SET inuse=inuse-1 WHERE username='50410']
-- AGI Script a2billing.php completed, returning -1
All callplans & ratecards is OK.
In postgres log I see:
Code:
ERROR: функция length(timestamp without time zone) не существует на символе 2120
ПОДСКАЗКА: No function matches the given name and argument types. You might need to add explicit type casts.
КОМАНДА: SELECT
tariffgroupname, lcrtype, idtariffgroup, cc_tariffgroup_plan.idtariffplan, tariffname, destination,
....
I think what this problem is linked to new syntax psql.
What I can do?
Return to Postgres 8.2 is very hard for me.
Please help.