[asterisk-bugs] [Asterisk 0014058]: cdr_pgsql does not work in asterisk 1.6.0.x

[Asterisk Bug Tracker]

A NOTE has been added to this issue. 
====================================================================== 
http://bugs.digium.com/view.php?id=14058 
====================================================================== 
Reported By:                navis
Assigned To:                Corydon76
====================================================================== 
Project:                    Asterisk
Issue ID:                   14058
Category:                   CDR/cdr_pgsql
Reproducibility:            always
Severity:                   major
Priority:                   normal
Status:                     assigned
Asterisk Version:           1.6.0 
SVN Branch (only for SVN checkouts, not tarball releases): N/A 
SVN Revision (number only!):  
Disclaimer on File?:        N/A 
Request Review:              
====================================================================== 
Date Submitted:             2008-12-11 03:46 CST
Last Modified:              2008-12-11 11:06 CST
====================================================================== 
Summary:                    cdr_pgsql does not work in asterisk 1.6.0.x
Description: 
cdr_pgsql not write data to the table. Clearly, the request is not formed
correctly

[Dec 11 11:31:07] ERROR[7770]: cdr_pgsql.c:309 pgsql_log: cdr_pgsql:
Failed to insert call detail record into database!
[Dec 11 11:31:07] ERROR[7770]: cdr_pgsql.c:310 pgsql_log: cdr_pgsql:
Reason: ERROR:  syntax error at or near ")"
LINE 1: INSERT INTO public.cdr ) VALUES )

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

---------------------------------------------------------------------- 
 (0096212) Corydon76 (administrator) - 2008-12-11 11:06
 http://bugs.digium.com/view.php?id=14058#c96212 
---------------------------------------------------------------------- 
The query to discover the table structure is as follows:
select a.attname, t.typname, a.attlen, a.attnotnull, d.adsrc from pg_class
c, pg_type t, pg_attribute a left outer join pg_attrdef d on a.atthasdef
and d.adrelid = a.attrelid and d.adnum = a.attnum where c.oid = a.attrelid
and a.atttypid = t.oid and (a.attnum > 0) and c.relname = 'cdr' order by
c.relname, attnum

If you run this query on your psql command line, what error do you get
back? 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2008-12-11 11:06 Corydon76      Note Added: 0096212                          
======================================================================