Re: [OpenSER-Users] Mysql Error

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: