Not getting the CDR report into database


Getting below errors

Executing [s@from-pstn:1] Set(“DAHDI/1-1”, “ODBC_SAVE_CDR()=,”) in new stack
[May 20 12:05:17] WARNING[572][C-00000016]: func_odbc.c:477 execute: SQL Execute returned an error -1: 42000: [MySQL][ODBC 5.1 Driver][mysqld-5.1.73]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘,)’ at line 1 (204)
[May 20 12:05:17] WARNING[572][C-00000016]: func_odbc.c:486 execute: SQL Exec Direct failed (-1)![INSERT INTO CDR_Report VALUES (,)]

You’re going to need to provide your dialplan and further information on the call flow. You are calling ODBC_SAVE_CDR from the dialplan but we don’t know what you are passing to it. We also need to know the version of Asterisk in use.

1 Like