thanks daniel, found the culprit in db_cluster. my bad. Kelvin Chua
On Tue, Jun 3, 2014 at 3:01 PM, Daniel-Constantin Mierla <mico...@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@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@lists.sip-router.org > http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users _______________________________________________ SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list sr-users@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
