<p>Using opensips 1.11, /usr/local/src/opensips-1.11.5-tls/scripts/mysql/acc-create.sql says : <br>
INSERT INTO version (table_name, table_version) values ('acc','6');<br>
CREATE TABLE acc (<br>
id INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY NOT NULL,<br>
method CHAR(16) DEFAULT '' NOT NULL,<br>
from_tag CHAR(64) DEFAULT '' NOT NULL,<br>
to_tag CHAR(64) DEFAULT '' NOT NULL,<br>
callid CHAR(64) DEFAULT '' NOT NULL,<br>
sip_code CHAR(3) DEFAULT '' NOT NULL,<br>
sip_reason CHAR(32) DEFAULT '' NOT NULL,<br>
time DATETIME NOT NULL,<br>
duration INT(11) UNSIGNED DEFAULT 0 NOT NULL,<br>
setuptime INT(11) UNSIGNED DEFAULT 0 NOT NULL,<br>
created DATETIME DEFAULT NULL<br>
) ENGINE=MyISAM;</p>
<p>When running opensips in debug mode, I have : <br>
Aug 7 16:31:45 opensips-preprod /sbin/opensips[31788]: DBG:db_mysql:db_mysql_do_prepared_query: new query=|insert into acc (method,from_tag,to_tag,callid,sip_code,sip_reason,time,gwid,from_user,to_user,duration,setuptime,created ) values (?,?,?,?,?,?,?,?,?,?,?,?,?)|<br>
Aug 7 16:31:45 opensips-preprod /sbin/opensips[31788]: DBG:db_mysql:re_init_statement: query is , ptr=(nil)<br>
Aug 7 16:31:45 opensips-preprod /sbin/opensips[31788]: CRITICAL:db_mysql:wrapper_single_mysql_stmt_prepare: driver error (1054): Unknown column 'gwid' in 'field list'<br>
Aug 7 16:31:45 opensips-preprod /sbin/opensips[31788]: ERROR:db_mysql:db_mysql_do_prepared_query: failed to create new context<br>
Aug 7 16:31:45 opensips-preprod /sbin/opensips[31788]: ERROR:acc:acc_db_cdrs: failed to insert into database<br>
Aug 7 16:31:45 opensips-preprod /sbin/opensips[31788]: ERROR:acc:acc_dlg_callback: Cannot insert into database</p>
<p>I guess fields are missing in sql scheme.<br>
Regards,<br>
Cédric</p>
<p style="font-size:small;-webkit-text-size-adjust:none;color:#666;">—<br>Reply to this email directly or <a href="https://github.com/OpenSIPS/opensips/issues/592">view it on GitHub</a>.<img alt="" height="1" src="https://github.com/notifications/beacon/AFOciW0DYLp57Z-WDpjc4s-7zkBR-9Hkks5olLpZgaJpZM4Fnly1.gif" width="1" /></p>
<div itemscope itemtype="http://schema.org/EmailMessage">
<div itemprop="action" itemscope itemtype="http://schema.org/ViewAction">
<link itemprop="url" href="https://github.com/OpenSIPS/opensips/issues/592"></link>
<meta itemprop="name" content="View Issue"></meta>
</div>
<meta itemprop="description" content="View this Issue on GitHub"></meta>
</div>