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

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: [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 <[hidden email]> wrote:
From: Daniel-Constantin Mierla <[hidden email]>
Subject: Re: [Kamailio-Users] Unknown column 'from_uri' in 'field list'
To: [hidden email]
Cc: [hidden email]
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. Get before others grab.
_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Loading...