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 > [email protected] > http://openser.org/cgi-bin/mailman/listinfo/users > > > _______________________________________________ Users mailing list [email protected] http://openser.org/cgi-bin/mailman/listinfo/users
