[SR-Users] sqlops

[Kelvin Chua]

thanks daniel, found the culprit in db_cluster. my bad.
Kelvin Chua


On Tue, Jun 3, 2014 at 3:01 PM, Daniel-Constantin Mierla
<miconda at gmail.com> wrote:
> Hello,
>
> if you run with debug=3, do you get more hints?
>
> Also, in case you have mysql server, you can enable logging sql query and
> see exactly what is sent to it.
>
> Cheers,
> Daniel
>
>
> On 03/06/14 05:00, Kelvin Chua wrote:
>>
>> what is wrong with this sql query? it works outside kamailio.
>>
>> select s.* from (select @p1:=4088112345 p) parm , lrn.lrnx s;
>>
>> ERROR: sqlops [sql_api.c:435]: sql_exec_xquery(): cannot do the query
>>
>>
>>
>> Kelvin Chua
>>
>> _______________________________________________
>> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
>> sr-users at lists.sip-router.org
>> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
>
>
> --
> Daniel-Constantin Mierla - http://www.asipto.com
> http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda
>
>
> _______________________________________________
> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
> sr-users at lists.sip-router.org
> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users