[OpenSIPS-Users] MySQL Prepared Error

[Bogdan-Andrei Iancu]

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
> <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
>>>
>>>
>>>       
>>     
>
>