[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:04 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 )

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

---------------------------------------------------------------------- 
 (0096211) Corydon76 (administrator) - 2008-12-11 11:04
 http://bugs.digium.com/view.php?id=14058#c96211 
---------------------------------------------------------------------- 
This would typically happen when upon startup, the query to discover the
table structure failed.  What version of PostgreSQL are you running? 

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