<p></p>

<h3>Description</h3>

<p>Just as in <a class="issue-link js-issue-link" data-error-text="Failed to load title" data-id="283541546" data-permission-text="Title is private" data-url="https://github.com/kamailio/kamailio/issues/1378" data-hovercard-type="issue" data-hovercard-url="/kamailio/kamailio/issues/1378/hovercard" href="https://github.com/kamailio/kamailio/issues/1378">#1378</a>, allowing nullable entries for SQL would be appreciated in acc <code>db_extra</code> and acc <code>multi_leg_info</code>.</p>
<h3>Expected behavior</h3>
<p>Empty/NULL values should be inserted with <code>NULL</code>.  For example, I can't create a <code>timestamp without time zone</code> to be used with multi-leg-accounting as follows.</p>
<pre><code>modparam("acc", "multi_leg_info",
        "leg_dst_user=$avp(leg_dst_user);"
        "leg_dst_domain=$avp(leg_dst_domain);"
        "leg_sip_code=$avp(leg_sip_code);"
        "leg_time=$avp(leg_time);"
        "leg_to_tag=$avp(leg_to_tag)")

$avp(leg_time)=$timef(%F %T)

</code></pre>
<h4>Actual observed behavior</h4>
<p>Emplty/NULL values are inserted with <code>''</code> which fails as <code>''</code> is invalid input for a <code>timestamp without time zone</code> column.</p>
<h4>Log Messages</h4>

<pre><code>db_postgres [km_dbase.c:266]: db_postgres_submit_query(): 0x7f26f7fb6cc8 PQsendQuery Error: ERROR:  invalid input syntax for type timestamp: ""
</code></pre>
<h4>SIP Traffic</h4>

<pre><code>(paste your sip traffic here)
</code></pre>
<h3>Possible Solutions</h3>

<h3>Additional Information</h3>
<ul>
<li><strong>Kamailio Version</strong> - output of <code>kamailio -v</code></li>
</ul>
<pre><code>ersion: kamailio 5.4.1-8.gitd43872c11e.fc32.2 (x86_64/linux) 09fd6a
flags: USE_TCP, USE_TLS, USE_SCTP, TLS_HOOKS, USE_RAW_SOCKS, DISABLE_NAGLE, USE_MCAST, DNS_IP_HACK, SHM_MMAP, PKG_MALLOC, Q_MALLOC, F_MALLOC, TLSF_MALLOC, DBG_SR_MEMORY, USE_FUTEX, FAST_LOCK-ADAPTIVE_WAIT, USE_DNS_CACHE, USE_DNS_FAILOVER, USE_NAPTR, USE_DST_BLACKLIST, HAVE_RESOLV_RES, TLS_PTHREAD_MUTEX_SHARED
ADAPTIVE_WAIT_LOOPS 1024, MAX_RECV_BUFFER_SIZE 262144, MAX_URI_SIZE 1024, BUF_SIZE 65535, DEFAULT PKG_SIZE 8MB
poll method support: poll, epoll_lt, epoll_et, sigio_rt, select.
id: 09fd6a 
compiled on 00:00:00 Oct 22 2020 with gcc 10.2.1
</code></pre>
<ul>
<li><strong>Operating System</strong>:</li>
</ul>

<pre><code>Linux host 5.8.15-201.fc32.x86_64 #1 SMP Thu Oct 15 15:56:44 UTC 2020 x86_64 x86_64 x86_64 GNU/Linux
</code></pre>

<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/2531">view it on GitHub</a>, or <a href="https://github.com/notifications/unsubscribe-auth/ABO7UZIOSZOB2ZS47AC7WLDSMKD5BANCNFSM4S5NOXCQ">unsubscribe</a>.<img src="https://github.com/notifications/beacon/ABO7UZLRS62YVNIMD4OKJ33SMKD5BA5CNFSM4S5NOXC2YY3PNVWWK3TUL52HS4DFUVEXG43VMWVGG33NNVSW45C7NFSM4K3PUDUA.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/2531",
"url": "https://github.com/kamailio/kamailio/issues/2531",
"name": "View Issue"
},
"description": "View this Issue on GitHub",
"publisher": {
"@type": "Organization",
"name": "GitHub",
"url": "https://github.com"
}
}
]</script>