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

[Daniel-Constantin Mierla]

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