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(a)openser.org
http://openser.org/cgi-bin/mailman/listinfo/users
_______________________________________________
Users mailing list
Users(a)openser.org
http://openser.org/cgi-bin/mailman/listinfo/users