[Asterisk-Users] Mysql-cdr

[Kanuri, Seshu (Company IT)]

/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. 
 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20041206/d6ba035e/attachment.htm