Hello every body ,
when i try to call internatnial call it said THE NUM YOU HAVE DIAL IS ...
and itested, i cant simulate the call too
- i added all rate
- the call plan and rate card is added, and it seems there is no problem !
- i tested all the way " the call with 00 or removing 00" no change !
And this is the LOG
FROM cc_tariffgroup
RIGHT JOIN cc_tariffgroup_plan ON cc_tariffgroup.id=1
INNER JOIN cc_tariffplan ON (cc_tariffplan.id=cc_tariffgroup_plan.idtariffplan )
LEFT JOIN cc_ratecard ON cc_ratecard.idtariffplan=cc_tariffplan.id
LEFT JOIN cc_trunk AS rt_trunk ON cc_ratecard.id_trunk=rt_trunk.id_trunk
LEFT JOIN cc_trunk AS tp_trunk ON cc_tariffplan.id_trunk=tp_trunk.id_trunk
LEFT JOIN cc_package_offer ON cc_package_offer.id=cc_tariffgroup.id_cc_package_offer
WHERE (dialprefix=SUBSTRING('14165686868',1,length(dialprefix)) OR dialprefix='defaultprefix')
AND startingdate<= CURRENT_TIMESTAMP AND (expirationdate > CURRENT_TIMESTAMP OR expirationdate IS NULL OR LENGTH(expirationdate)<5)
AND startdate<= CURRENT_TIMESTAMP AND (stopdate > CURRENT_TIMESTAMP OR stopdate IS NULL OR LENGTH(stopdate)<5)
AND (starttime <= 9274 AND endtime >=9274)
AND idtariffgroup='1'
AND ( dnidprefix=SUBSTRING('14165686868',1,length(dnidprefix)) OR (dnidprefix='all' AND 0 = 0))
AND ( calleridprefix=SUBSTRING('843264597511111',1,length(calleridprefix)) OR (calleridprefix='all' AND 0 = 0))
ORDER BY LENGTH(dialprefix) DESC
]
[13/04/2008 10:34:53]:[file:Class.A2Billing.php - line:734]:[CallerID:843264597511111]:[CN:8197413819]:[ERROR ::> RateEngine didnt succeed to match the dialed number over the ratecard
HELP ME AND TAKE AWARD