[OpenSIPS-Users] [Kamailio-Users] Unknown column 'from_uri' in 'field list'

[Kaeman Chris]

Thanks, it helps. error gone.

missed on the missed_calls table. 

Thanks,
KC

--- On Tue, 4/11/08, Daniel-Constantin Mierla <miconda at gmail.com> wrote:
From: Daniel-Constantin Mierla <miconda at gmail.com>
Subject: Re: [Kamailio-Users] Unknown column 'from_uri' in 'field list'
To: kaemanchris at yahoo.co.in
Cc: users at lists.kamailio.org
Date: Tuesday, 4 November, 2008, 5:59 PM


On 11/04/08 14:19, Kaeman Chris wrote:
> Hello,
> 
> modparam("acc", "db_extra", "from_uri=$fu;
to_uri=$tu")
> 
> added 2 new fields in the acc table.
> 
> Logs giving following errors while making calls
> 
> Nov  4 07:14:11 [4567] ERROR:db_mysql:db_mysql_submit_query: driver error
on query: Unknown column 'from_uri' in 'field list'
> Nov  4 07:14:11 [4567] ERROR:core:db_do_insert: error while submitting
query
> Nov  4 07:14:11 [4567] ERROR:acc:acc_db_request: failed to insert into
database
> 
> Is this error due to the added fields?
> 
have you added the appropriate columns in the acc table?

For each extra field you account, you need to add a new column in acc and
missed_calls table.

Cheers,
Daniel

-- Daniel-Constantin Mierla
http://www.asipto.com




      Get perfect Email ID for your Resume. Grab now http://in.promos.yahoo.com/address
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.opensips.org/pipermail/users/attachments/20081104/18f6efd3/attachment.htm