[asterisk-bugs] [Asterisk 0017599]: odbc can't insert specyfic record

Asterisk Bug Tracker noreply at bugs.digium.com
Wed Jul 7 11:47:10 CDT 2010


The following issue has been SUBMITTED. 
====================================================================== 
https://issues.asterisk.org/view.php?id=17599 
====================================================================== 
Reported By:                jamicque
Assigned To:                tilghman
====================================================================== 
Project:                    Asterisk
Issue ID:                   17599
Category:                   CDR/cdr_odbc
Reproducibility:            always
Severity:                   minor
Priority:                   normal
Status:                     assigned
Asterisk Version:           1.6.2.7 
JIRA:                        
Regression:                 No 
Reviewboard Link:            
SVN Branch (only for SVN checkouts, not tarball releases): N/A 
SVN Revision (number only!):  
Request Review:              
====================================================================== 
Date Submitted:             2010-07-07 11:47 CDT
Last Modified:              2010-07-07 11:47 CDT
====================================================================== 
Summary:                    odbc can't insert specyfic record
Description: 
Below I paste a cdr record, which cannot be inserted via odbc (via
cdr_pgsql works).
The mentioned column "sip_proxy_host" exists, I don't know why there is an
"v_" before it in log.
I can insert the query to the database manually.

INSERT INTO cdr
(clid,src,dst,dcontext,channel,dstchannel,lastapp,lastdata,duration,billsec,disposition,amaflags,accountcode,uniqueid,userfield,number_a,number_b,src_interface,dst_interface,is_outbound,is_inbound,sip_proxy_host)
VALUES ('"Unknown"
<Unknown>','Unknown','boniek420','CALLEX','SIP/boniek420-00000041','SIP/boniek420-00000042','Dial','SIP/0693618338 at boniek420,45,wW',12,2,'ANSWERED',3,'boniek420','1278503202.119','UID:1278503202.119;','Unknown','+48693618338','SIP/testowy','SIP/testowy','f','f','sip.freeconet.pl')

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

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2010-07-07 11:47 jamicque       New Issue                                    
2010-07-07 11:47 jamicque       Status                   new => assigned     
2010-07-07 11:47 jamicque       Assigned To               => tilghman        
2010-07-07 11:47 jamicque       Asterisk Version          => 1.6.2.7         
2010-07-07 11:47 jamicque       Regression                => No              
2010-07-07 11:47 jamicque       SVN Branch (only for SVN checkouts, not tarball
releases) => N/A             
======================================================================




More information about the asterisk-bugs mailing list