[asterisk-bugs] [Asterisk 0013333]: mysql cdr not loging custom fields

[Asterisk Bug Tracker]

The following issue has been UPDATED. 
====================================================================== 
http://bugs.digium.com/view.php?id=13333 
====================================================================== 
Reported By:                lazytt
Assigned To:                
====================================================================== 
Project:                    Asterisk
Issue ID:                   13333
Category:                   CDR/General
Reproducibility:            always
Severity:                   minor
Priority:                   normal
Status:                     closed
Asterisk Version:           1.4.18 
SVN Branch (only for SVN checkouts, not tarball releases): N/A 
SVN Revision (number only!):  
Disclaimer on File?:        N/A 
Request Review:              
Resolution:                 no change required
Fixed in Version:           
====================================================================== 
Date Submitted:             2008-08-18 09:02 CDT
Last Modified:              2008-08-18 17:24 CDT
====================================================================== 
Summary:                    mysql cdr not loging custom fields
Description: 
When trying to add custom fields to the mysql crd table, asterisk will not
log the values assigned to them. I added a field called "monitor" and tried
using the following dialplan:

exten => s,1000,Set(CDR(monitor)=${CALLFILENAME}.${MIXMON_FORMAT})

However, all asterisk adds is:
cdr_addon_mysql.c: cdr_mysql: SQL command as follows: INSERT INTO cdr
(calldate,clid,src,dst,dcontext,channel,dstchannel,lastapp,lastdata,duration,billsec,disposition,amaflags,accountcode,uniqueid,userfield)
VALUES ('2008-08-18 17:01:59','\"lazytt\"
<220>','220','123456','from-internal',
'SIP/220-09024700','Zap/1-1','Dial','ZAP/g0/123456|300|T',10,5,'ANSWERED',3,'','1219068119.2','')

Using the same dialplan with variables such as userfeild works

====================================================================== 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2008-08-18 17:24 blitzrage      Resolution               open => no change
required
======================================================================