Hi, This is because of the newly introduced prepared statements in mysql. But the error is in other place:
DBG:db_mysql:db_mysql_val2str_nq: unknown data type Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]: ERROR:db_mysql:db_mysql_do_prepared_query: val2str() failed for i=0 (1) I enhanced the err reporting, so please update from SVN and do get the log again. Thanks and regards, Bogdan ibrahim tunali wrote: > Hello, > > I got below DB error when re-registering with SVN build Opensips. I > would appreciate if you could check this issue > > Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]: > DBG:usrloc:update_ucontact: exists callback for type= > UL_CONTACT_UPDATE > Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]: > DBG:db_mysql:db_mysql_do_prepared_query: new query=|update location > set > expires=?,q=?,cseq=?,flags=?,cflags=?,user_agent=?,received=?,path=?,socket=?,methods=?,last_modified=? > where username=? AND contact=? AND callid=? AND domain=?| > Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]: > DBG:db_mysql:db_mysql_do_prepared_query: prepared statement > successfully prepared > Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]: > DBG:db_mysql:db_mysql_do_prepared_query: doing BIND_PARAM in... > Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]: > DBG:db_mysql:db_mysql_do_prepared_query: prepared statement > successfully set... > Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]: > DBG:db_mysql:db_mysql_do_prepared_query: set values for the statement > run > Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]: > DBG:db_mysql:db_mysql_do_prepared_query: added val (0): len=19; > buf=2009-01-30 14:17:18; is_null=0 > Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]: > DBG:db_mysql:db_mysql_do_prepared_query: added val (1): len=10; > buf=0.00 ; is_null=0 > Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]: > DBG:db_mysql:db_mysql_do_prepared_query: added val (2): len=5; > buf=35581; is_null=0 > Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]: > DBG:db_mysql:db_mysql_do_prepared_query: added val (3): len=1; buf=0; > is_null=0 > Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]: > DBG:db_mysql:db_mysql_do_prepared_query: added val (4): len=2; buf=64; > is_null=0 > Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]: > DBG:db_mysql:db_mysql_do_prepared_query: added val (5): len=21; > buf=Linksys/SPA2100-3.3.6; is_null=0 > Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]: > DBG:db_mysql:db_mysql_do_prepared_query: added val (6): len=24; > buf=sip:193.192.116.18:64314; is_null=0 > Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]: > DBG:db_mysql:db_mysql_do_prepared_query: added val (7): len=4; > buf=NULL; is_null=1 > Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]: > DBG:db_mysql:db_mysql_do_prepared_query: added val (8): len=22; > buf=udp:81.21.166.171:5060; is_null=0 > Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]: > DBG:db_mysql:db_mysql_do_prepared_query: added val (9): len=4; > buf=5183; is_null=0 > Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]: > DBG:db_mysql:db_mysql_do_prepared_query: added val (10): len=19; > buf=2009-01-30 13:17:18; is_null=0 > Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]: > DBG:db_mysql:db_mysql_val2str_nq: unknown data type > Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]: > ERROR:db_mysql:db_mysql_do_prepared_query: val2str() failed for i=0 > (1) > Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]: > ERROR:usrloc:db_update_ucontact: updating database failed > Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]: > ERROR:usrloc:update_ucontact: failed to update database > > Regards, > Ibrahim TUNALI > > _______________________________________________ > Users mailing list > [email protected] > http://lists.opensips.org/cgi-bin/mailman/listinfo/users > > _______________________________________________ Users mailing list [email protected] http://lists.opensips.org/cgi-bin/mailman/listinfo/users
