<p></p>
<p>Hi I want to add a new culomn to acc table. I named it ring_time and in every call i put the ring time to it like this:<br>
<code>$dlg_var(ringtime) = $Ts;</code><br>
then I add a extra column in config like this:<br>
<code>modparam("acc", "log_extra", "src_user=$fU;src_domain=$fd;src_ip=$si;" "dst_ouser=$tU;dst_user=$rU;dst_domain=$rd;ring_time=$dlg_var(ringtime)")</code><br>
but when I try to test it always i get:<br>
<code>db_mysql [km_dbase.c:122]: db_mysql_submit_query(): driver error on query: Incorrect datetime value: '1591361996' for column </code>kamailio<code>.</code>acc<code>.</code>ring_time<code> at row 1 (1292) Jun  5 17:29:59 kamailio /usr/sbin/kamailio[22901]: ERROR: {2 102 INVITE 105a0f4a3d99a0a5558355e54b43f4e1@192.168.1.121:5060} <core> [db_query.c:244]: db_do_insert_cmd(): error while submitting query Jun  5 17:29:59 kamailio /usr/sbin/kamailio[22901]: ERROR: {2 102 INVITE 105a0f4a3d99a0a5558355e54b43f4e1@192.168.1.121:5060} acc [acc.c:477]: acc_db_request(): failed to insert into database</code></p>

<p style="font-size:small;-webkit-text-size-adjust:none;color:#666;">—<br />You are receiving this because you are subscribed to this thread.<br />Reply to this email directly, <a href="https://github.com/kamailio/kamailio/issues/2349">view it on GitHub</a>, or <a href="https://github.com/notifications/unsubscribe-auth/ABO7UZK6TZSEHZ4HWELGSZ3RVDUIPANCNFSM4NTRCP3A">unsubscribe</a>.<img src="https://github.com/notifications/beacon/ABO7UZI4DLIRIIJONRRZHWDRVDUIPA5CNFSM4NTRCP3KYY3PNVWWK3TUL52HS4DFUVEXG43VMWVGG33NNVSW45C7NFSM4JNFBK5Q.gif" height="1" width="1" alt="" /></p>
<script type="application/ld+json">[
{
"@context": "http://schema.org",
"@type": "EmailMessage",
"potentialAction": {
"@type": "ViewAction",
"target": "https://github.com/kamailio/kamailio/issues/2349",
"url": "https://github.com/kamailio/kamailio/issues/2349",
"name": "View Issue"
},
"description": "View this Issue on GitHub",
"publisher": {
"@type": "Organization",
"name": "GitHub",
"url": "https://github.com"
}
}
]</script>