3 Jun
2014
3 Jun
'14
6 a.m.
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
3 Jun
3 Jun
10:01 a.m.
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(a)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
10:14 a.m.
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(a)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(a)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(a)lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
3825
days inactive
3825
days old
2 comments
2 participants
participants (2)
-
Daniel-Constantin Mierla -
Kelvin Chua