[OpenSER-Users] Mysql Error

[Norman Brandinger]

The missed call table is called (missed_calls) not missing.  Sorry if
this added any confusion.

Regards,
Norm

Norman Brandinger wrote:
> 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
>>
>>
>>   
>>     
>
>
> _______________________________________________
> Users mailing list
> Users at openser.org
> http://openser.org/cgi-bin/mailman/listinfo/users
>
>
>