[OpenSIPS-Users] Dialog module - updating db

[Антон Загорский]

Hello.

Sometimes I see in a log following lines:

[89566]: DBG:dialog:dialog_update_db: inserting new dialog 0x80417c568
[89566]: DBG:db_mysql:db_mysql_do_prepared_query: conn=0x731538
(tail=7530824) MC=0x72e9a8
[89566]: DBG:db_mysql:db_mysql_do_prepared_query: new query=|insert into
dialog
(hash_entry,hash_id,callid,from_uri,from_tag,to_uri,to_tag,caller_sock,calle
e_sock,start_time,caller_route_set,callee_route_set,caller_contact,callee_co
ntact,state,timeout,caller_cseq,callee_cseq,vars,profiles,script_flags )
values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)|
[89566]: INFO:db_mysql:re_init_statement:  query  is <insert into dialog
(hash_entry,hash_id,callid,from_uri,from_tag,to_uri,to_tag,caller_sock,calle
e_sock,start_time,caller_route_set,callee_route_set,caller_contact,callee_co
ntact,state,timeout,caller_cseq,callee_cseq,vars,profiles,script_flags )
values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)>, ptr=0x0
[89566]: DBG:db_mysql:db_mysql_do_prepared_query: new statement(0x7317c8) on
connection: (0x731538) 0x72e948


And that causes
[89566]: CRITICAL:db_mysql:wrapper_single_mysql_stmt_execute: driver error
(1048): Column 'to_tag' cannot be null
[89566]: ERROR:dialog:dialog_update_db: could not add another dialog to db


How can all values be '?' ?




WBR, Anton Zagorskiy
VoIP Developer, Oyster Telecom
Phone.: +7 812 601-0666
Fax: +7 812 601-0593
a.zagorskiy at oyster-telecom.ru
www.oyster-telecom.ru