[OpenSIPS-Users] MySQL Prepared Error

[ibrahim tunali]

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
<bogdan at voice-system.ro> 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
>> Users at lists.opensips.org
>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>
>>
>
>