[OpenSER-Users] Mysql Error

[Norman Brandinger]

Hi Gerson,

You are trying to write accounting data to columns that don't exist in
the accounting table (acc).
The MySQL code below is an example of how you can add the columns to the
accounting (acc) and missed call (missing) tables.

alter_tables.sql:

alter table acc
add column src_user varchar(64) NOT NULL DEFAULT '',
add column dst_user varchar(64) NOT NULL DEFAULT '';

alter table missing
add column src_user varchar(64) NOT NULL DEFAULT '',
add column dst_user varchar(64) NOT NULL DEFAULT '';

If the above code is placed into the alter_tables.sql file, then the
command:

mysql -u openserrw -p xxx openser < alter_tables.sql

Should add the columns for you and resolve the problem you are having.

Regards,
Norm


Gerson Matiolli wrote:
> Somebody knows what it is this message of error?
>
> Aug 10 15:55:43 localhost /usr/local/sbin/openser[16746]: submit_query: Unknown column 'src_user' in 'field list'
> Aug 10 15:55:43 localhost /usr/local/sbin/openser[16746]: db_insert: Error while submitting query
> Aug 10 15:55:43 localhost /usr/local/sbin/openser[16746]: ERROR:acc:acc_db_request: Error while inserting to database
>
>
> _______________________________________________
> Users mailing list
> Users at openser.org
> http://openser.org/cgi-bin/mailman/listinfo/users
>
>
>