Hi Ibrahim , It might be a stupid question, but are you 100% sure you did a complete update (for all modules and core files) from SVN ?
Regards, Bogdan ibrahim tunali wrote: > Hi Bogdan, > > Thank you for quick reply. Detailed error; > > Jan 30 15:39:42 voipvserver /usr/sbin/opensips[27892]: > ERROR:db_mysql:db_mysql_val2str_nq: unknown data type (1233329982) > Jan 30 15:39:42 voipvserver /usr/sbin/opensips[27892]: > ERROR:db_mysql:db_mysql_do_prepared_query: val2str() failed for i=0 > (1) > > Best regards, > > Ibrahim TUNALI > > > > > On Fri, Jan 30, 2009 at 16:09, Bogdan-Andrei Iancu > <[email protected]> wrote: > >> 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
