<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
</head>
<body bgcolor="#ffffff" text="#000000">
Hi Guys,<br>
<br>
Ever since OpenSIPS 1.4.0 onward, I've encountered this problem in very
regular manner. I've updated to lastest 1.4.2 but this problems still
persist. <br>
<br>
If I recalled correctly, previously there's several mails highlighted
this problem, and some of us actually suggested add a LM_DBG to the .c
file and recompile, so that we could get the SQL statement, I've tried
with earlier (1.4.1) and it does show some normal SQL, doesn't cause
any problem if I entered it on MySQL console/command prompt, but
whenever these SQL send through OpenSIPS (db_mysql or db), it always
gave error "command out of sync", sometimes even occurred during
authentication in REGISTER. Tried to patch the .c code in 1.4.2 but it
doesn't show the exact SQL so can't paste it out, I guess all I can do
is provide error log.<br>
<hr size="2" width="100%">Sep 2 15:08:17 DvidRnD /sbin/opensips[6457]:
ERROR:db_mysql:db_mysql_submit_query: driver error on query: Commands
out of sync; you can't run this command now<br>
Sep 2 15:08:17 DvidRnD /sbin/opensips[6457]: ERROR:core:db_do_query:
error while submitting query<br>
Sep 2 15:08:17 DvidRnD /sbin/opensips[6457]:
ERROR:rls:get_resource_list: while querying table xcap for
[uri]=<a class="moz-txt-link-freetext" href="sip:david@MY_IP">sip:david@MY_IP</a><br>
Sep 2 15:08:17 DvidRnD /sbin/opensips[6457]:
ERROR:rls:rls_handle_subscribe: while attepmting to get a resource list<br>
Sep 2 15:08:17 DvidRnD /sbin/opensips[6457]:
ERROR:rls:rls_handle_subscribe: occured in rls_handle_subscribe<br>
<hr size="2" width="100%"><br>
Is anyone come across this, and with a fix for it? Appreciate if any of
you can share the solution, thanks in advance.<br>
<br>
<br>
Regards,<br>
David Loh<br>
</body>
</html>