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