On Mon, Jan 11, 2010 at 9:16 AM, Raymond Dans <[email protected]> wrote: > Ranga wrote: >>Subject: [sipX-dev] ODBC ERR from sipXproxy >> >>Hello, >> >>I am running 4.1.6-017649 >> >>After I built, installed and configured the system, I noticed >>that phones could not call each other. I see the following in >>my sipXproxy.log file: >> >>"2010-01-11T03:25:41.255068Z":59:ODBC:ERR:sipxtest.sipxtest.net >>:SipXProxyCseObserver-10:B77FAB90:SipXProxy:"odbcExecute: >>statement INSERT INTO call_state_events VALUES >>(DEFAULT,'192.168.5.75:-1',1,timestamp '2010-01-11 >>03:25:41.254','R',1,'[email protected]',' > EFD9BEBD-AA18E08C','','\"user1\" >><sip:[email protected]>;tag=EFD9BEBD-AA18E08C','<sip: >>[email protected];user=phone>','<sip:[email protected] > 2>','','',0,'','','','f',''); >>failed, error code -1" >>"2010-01-11T03:25:41.255135Z":60:ODBC:ERR:sipxtest.sipxtest.net >>:SipXProxyCseObserver-10:B77FAB90:SipXProxy:" >> SQLGetDiagRec(SQLExecDirect):[unixODBC]Error while executing >>the query (non-fatal);\nERROR: INSERT has more expressions >>than target columns" >> >> >>Any clues about where this is coming from? >> > How old is your CDR database? I added a number of new fields in the CSE > and CDR tables in 4.2 (awhile back though) and informed the development > public to drop and re-create the CDR database. If you hadn't done this > and just started using CDR in the development environment then this > could be your issue. > > I would go into the database and check both the "call_state_events" and > "cdrs" tables to ensure all of the fields exist. This can be done as > follows:
Thank you very much. This fixed the problem. Sorry I did not remember your earlier mail. It might be nice to have a "dropall" command that just cleans all databases. Best regards Ranga -- M. Ranganathan _______________________________________________ sipx-dev mailing list [email protected] List Archive: http://list.sipfoundry.org/archive/sipx-dev Unsubscribe: http://list.sipfoundry.org/mailman/listinfo/sipx-dev sipXecs IP PBX -- http://www.sipfoundry.org/
