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