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)" <[EMAIL PROTECTED]>
To: "Asterisk Users Mailing List - Non-Commercial Discussion"
<[EMAIL PROTECTED]>
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
> [EMAIL PROTECTED]
> http://lists.digium.com/mailman/listinfo/asterisk-users
> To UNSUBSCRIBE or update options visit:
> http://lists.digium.com/mailman/listinfo/asterisk-users
_______________________________________________
Asterisk-Users mailing list
[EMAIL PROTECTED]
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users
