<html><head><base href="x-msg://318/"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">Hi Federico,<div><br></div><div>That's not an error. That's Opensips letting you know it has initialized the prepared statement in the MySQL database. The ?s are part of the statement format. Depending on your config, you may see these for other modules in addition to acc. I see them a lot for dialog in my config after a restart. Once a statement has been initialized for each child process, you won't see them anymore. </div><div><br></div><div>Are you sure the data isn't in the table? If it isn't, there isn't any indication here as to why.</div><div><br></div><div><br></div><div>- Jeff</div><div><br></div><div><br></div><div><br><div><div>On Sep 15, 2011, at 3:07 PM, Federico Varela wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><span class="Apple-style-span" style="border-collapse: separate; font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; font-size: medium; "><div class="hmmessage" style="font-size: 10pt; font-family: Tahoma; "><div dir="ltr"><font class="Apple-style-span" face="Tahoma" size="2">Hello:</font><div style="font-family: Tahoma; font-size: 10pt; ">My name is Federico. I have a problem with Acc Module in Opensips 1.6.</div><div><font class="Apple-style-span" face="Tahoma" size="2">I can complete a call perfectly, but opensips dont insert data in mysql acc table.</font></div><div><font class="Apple-style-span" face="Tahoma" size="2"><br></font></div><div><font class="Apple-style-span" face="Tahoma" size="2">My configuration is this:</font></div><div><font class="Apple-style-span" face="Tahoma" size="2"><br></font></div><div><font class="Apple-style-span" face="Tahoma" size="2"><div>modparam("acc", "early_media", 1)</div><div>modparam("acc", "report_ack", 1)</div><div>modparam("acc", "report_cancels", 1)</div><div>modparam("acc", "detect_direction", 0)</div><div>modparam("acc", "failed_transaction_flag", 3)</div><div>modparam("acc", "log_flag", 1)</div><div>modparam("acc", "log_missed_flag", 2)</div><div>modparam("acc", "db_flag", 1)</div><div>modparam("acc", "db_missed_flag", 2)</div><div>modparam("acc", "db_url","<a href="mysql://root:xxxx@localhost/opensips_db">mysql://root:xxxx@localhost/opensips_db</a>")</div><div>modparam("acc", "db_extra","from_uri=$fu; to_uri=$tu")</div><div><br></div><div>And, my log is this: </div><div><br></div></font></div><div><font class="Apple-style-span" face="Tahoma" size="2">Sep 15 16:05:20 oepnsips /usr/sbin/opensips[6663]: INFO:db_mysql:re_init_statement: query is <insert into acc (method,from</font>_tag,to_tag,callid,sip_code,sip_reason,time,from_uri,to_uri ) values (?,?,?,?,?,?,?,?,?)>, ptr=(nil)</div><div><br></div><div>Why in this SQL string, the values are "?"..</div><div><br></div><div>Thanks a lot!!!</div><div><br></div><div>Federico</div></div></div></span></blockquote></div><br></div></body></html>