[Asterisk-Users] Mysql-cdr

[Matthew Boehm]

We have quotes in our CDRs and have no problems. Check the debug log. You
should see a reason on why the query failed.

-Matthew
----- Original Message ----- 
From: "Kanuri, Seshu (Company IT)" <Seshu.Kanuri at morganstanley.com>
To: "Asterisk Users Mailing List - Non-Commercial Discussion"
<asterisk-users at lists.digium.com>
Sent: Monday, December 06, 2004 1:25 PM
Subject: RE: [Asterisk-Users] Mysql-cdr


/SNIP/



INSERT INTO cdr

(calldate,

clid,

src,

dst,

dcontext,

channel,

dstchannel,

lastapp,

lastdata,

duration,

billsec,

disposition,

amaflags,

accountcode,

uniqueid)



('2004-12-06 13:36:17',

'\"Mohammad\"',

' ',

'9053265824',

'sip',

'SIP/3000-b4f7',

'SIP/9053265824-f4b2',

'Dial',

'SIP/9053265824|20| Ttr',

9,

5,

'ANSWERED',

3,

' ',

'1102358177.0'

)



Dec  6 13:36:26 ERROR[1221985728]: cdr_addon_mysql.c:200 mysql_log:
Failed to insert into database.Dec  6 13:36:26 ERROR[1221985728]:
 /SNIP/



Above  is the breakdown of your Insert Statement. There is a problem
with the formatting of your CLID, the second field. Try to change that
to a number or something and try again. Dont use quotes or slashes in
your name in the CLID.



Seshu kanuri






**************************************
--------------------------------------------------------

NOTICE: If received in error, please destroy and notify sender.  Sender does
not waive confidentiality or privilege, and use is prohibited.




----------------------------------------------------------------------------
----


> _______________________________________________
> Asterisk-Users mailing list
> Asterisk-Users at lists.digium.com
> http://lists.digium.com/mailman/listinfo/asterisk-users
> To UNSUBSCRIBE or update options visit:
>    http://lists.digium.com/mailman/listinfo/asterisk-users