[Freeswitch-users] mod_lcr and UnixODBC Error

FERNANDO VILLARROEL fvillarroel at yahoo.com
Thu Oct 31 23:07:49 MSK 2013


Dear all.

I am trying to use mod_lcr, but in my tests i did received the follow error:

2013-10-31 16:35:03.916887 [ERR] switch_core_sqldb.c:1114 ERR: [SELECT l.digits AS lcr_digits, c.carrier_name AS lcr_carrier_name, l.rate AS lcr_rate_field,                                                       cg.prefix AS lcr_gw_prefix, cg.suffix AS lcr_gw_suffix, l.lead_strip AS lcr_lead_strip,                                                       l.trail_strip AS lcr_trail_strip, l.prefix AS lcr_prefix, l.suffix AS lcr_suffix,                                                       cg.codec AS lcr_codec, l.cid AS lcr_cid FROM lcr l JOIN carriers c ON l.carrier_id=c.id                                                             JOIN carrier_gateway cg ON c.id=cg.carrier_id                                                             WHERE c.enabled = '1' AND cg.enabled = '1' AND l.enabled = '1' AND (          
                                                   (digits IN (12145551111, 1214555111, 121455511, 12145551, 1214555, 121455, 12145, 1214, 121, 12, 1)     AND lrn = false) OR                                                             (digits IN (12145551111, 1214555111, 121455511, 12145551, 1214555, 121455, 12145, 1214, 121, 12, 1) AND lrn = true)) AND CURRENT_TIMESTAMP BETWEEN date_start AND date_end ORDER BY digits DESC,  rate,  quality DESC,  reliability DESC, random();]
[STATE: 42883 CODE 7 ERROR: [unixODBC]ERROR: el operador no existe: prefix_range = bigint;
Error while executing the query
]


I am using PostgreSQL 8.4.11 and Debian Squezee

How i can solve this issue?

Regards
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20131031/7ab2bd1a/attachment.html 


Join us at ClueCon 2013 Aug 6-8, 2013
More information about the FreeSWITCH-users mailing list