[asterisk-bugs] [Asterisk 0014317]: Latest cdr_addon_mysql queries borked

[Asterisk Bug Tracker]

The following issue has been SUBMITTED. 
====================================================================== 
http://bugs.digium.com/view.php?id=14317 
====================================================================== 
Reported By:                cheesegrits
Assigned To:                
====================================================================== 
Project:                    Asterisk
Issue ID:                   14317
Category:                   Addons/cdr_addon_mysql
Reproducibility:            always
Severity:                   major
Priority:                   normal
Status:                     new
Asterisk Version:           SVN 
Regression:                 No 
SVN Branch (only for SVN checkouts, not tarball releases):  trunk 
SVN Revision (number only!): 730 
Request Review:              
====================================================================== 
Date Submitted:             2009-01-22 20:40 CST
Last Modified:              2009-01-22 20:40 CST
====================================================================== 
Summary:                    Latest cdr_addon_mysql queries borked
Description: 
After updating to the latest asterisk-addons SVN, my MySQL log queries are
broken:

[Jan 22 19:55:17] DEBUG[8359] cdr_addon_mysql.c: SQL command as follows:
INSERT INTO cdr
(calldate,clid,src,dst,dcontext,channel,dstchannel,lastapp,lastdata,duration,billsec,disposition,amaflags,,uniqueid,)
VALUES ('2009-01-22 19:55:13','\"Hugh Poly\"
<301>','301','300','from-internal','SIP/301-0a2304a8','SIP/300-0a387ba0','Dial','SIP/300,,tr','4','2','ANSWERED','3',,'1232675713.0',')

Note the missing fields / values (coresponding to userfield and
accountcode) and the extra ' on the end of values.

I'll attempt to attach a diff for the changes I had to make to get it
working.

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

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2009-01-22 20:40 cheesegrits    New Issue                                    
2009-01-22 20:40 cheesegrits    Asterisk Version          => SVN             
2009-01-22 20:40 cheesegrits    Regression                => No              
2009-01-22 20:40 cheesegrits    SVN Branch (only for SVN checkouts, not tarball
releases) =>  trunk          
2009-01-22 20:40 cheesegrits    SVN Revision (number only!) => 730             
======================================================================