<table cellspacing="0" cellpadding="0" border="0" ><tr><td valign="top" style="font: inherit;">Thanks, it helps. error gone.<br><br>missed on the missed_calls table. <br><br>Thanks,<br>KC<br><br>--- On <b>Tue, 4/11/08, Daniel-Constantin Mierla <i><miconda@gmail.com></i></b> wrote:<br><blockquote style="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; padding-left: 5px;">From: Daniel-Constantin Mierla <miconda@gmail.com><br>Subject: Re: [Kamailio-Users] Unknown column 'from_uri' in 'field list'<br>To: kaemanchris@yahoo.co.in<br>Cc: users@lists.kamailio.org<br>Date: Tuesday, 4 November, 2008, 5:59 PM<br><br><pre><br>On 11/04/08 14:19, Kaeman Chris wrote:<br>> Hello,<br>> <br>> modparam("acc", "db_extra", "from_uri=$fu;<br>to_uri=$tu")<br>> <br>> added 2 new fields in the acc table.<br>> <br>> Logs giving following errors while making calls<br>> <br>> Nov 4 07:14:11 [4567]
ERROR:db_mysql:db_mysql_submit_query: driver error<br>on query: Unknown column 'from_uri' in 'field list'<br>> Nov 4 07:14:11 [4567] ERROR:core:db_do_insert: error while submitting<br>query<br>> Nov 4 07:14:11 [4567] ERROR:acc:acc_db_request: failed to insert into<br>database<br>> <br>> Is this error due to the added fields?<br>> <br>have you added the appropriate columns in the acc table?<br><br>For each extra field you account, you need to add a new column in acc and<br>missed_calls table.<br><br>Cheers,<br>Daniel<br><br>-- Daniel-Constantin Mierla<br>http://www.asipto.com<br><br></pre></blockquote></td></tr></table><br>
<!--1--><hr size=1></hr> Get perfect Email ID for your Resume. <a href="http://in.rd.yahoo.com/tagline_dbid_1/*http://in.promos.yahoo.com/address" target="_blank">Get before others grab.</a>