No CDR for incoming calls after update to the latest version

[GoogleCodeExporter]

What steps will reproduce the problem?

Debian scripted install with psql.
Everything was working fine until I used apt-get to update FusionPBX on Feb 23d
No incoming calls were logged since then.
After restart now incoming calls are logged but I have error message on CDR 
page for every incoming call:
SQLSTATE[23505]: Unique violation: 7 ERROR: duplicate key value violates unique 
constraint "v_xml_cdr_pkey" DETAIL: Key (uuid)=(random uuid) already exists.

What version of the product are you using? On what operating system?
FreeSWITCH (Version 1.4.17 -2 64bit)
Debian 3.2.65
Fusion PBX 3.7.1

Please provide any additional information below.

Original issue reported on code.google.com by Sergey.M...@gmail.com on 4 Apr 2015 at 9:46

[GoogleCodeExporter]

Incoming calls are logged only if I set log on disk:
<param name="log-http-and-disk" value="true"/>
But this produces SQL error.

Original comment by Sergey.M...@gmail.com on 4 Apr 2015 at 10:05

[GoogleCodeExporter]

[deleted comment]

[GoogleCodeExporter]

Its a bug in FreeSWITCH as they are trying to put unescaped data into the XML 
CDR via HTTP POST. Strangely enough if you configure XML CDR to save to the 
file system and not to do an HTTP POST then it works. In that case you would 
schedule v_xml_cdr_import.php  to run with PHP from the command line.

What version of FreeSWITCH are you using?  Advanced -> Command -> Switch 
command -> version.

Original comment by markjcrane@gmail.com on 6 Apr 2015 at 1:56

• Changed state: Accepted

[GoogleCodeExporter]

FreeSWITCH Version 1.4.17-2~64bit (-2 64bit)

I don't remember updating switch with apt-get, only FusionPBX files.

Original comment by Sergey.M...@gmail.com on 6 Apr 2015 at 2:30

[GoogleCodeExporter]

After today's update of FS and FusionPBX incoming CDR is working again.
FreeSWITCH (Version 1.4.18 -1 64bit)

There is an issue with "Active calls" page though.

Original comment by Sergey.M...@gmail.com on 16 Apr 2015 at 10:31

Attachments:

• Capture.PNG

[GoogleCodeExporter]

Can't reproduce the Active Calls issue.  Please delete 
/app/calls_active/app_languages.php and run svn update again, then see if the 
issue continues.

Glad your CDRs are working again.

Original comment by sevenate on 16 Apr 2015 at 10:41

[GoogleCodeExporter]

People should be cautious, 1.4.18 does not completely fix this issue, you may 
see some CDRS slip through the net. I am 100% certain that this is the case.

Original comment by Digitald...@gmail.com on 16 Apr 2015 at 10:49

[GoogleCodeExporter]

This really is a FreeSWITCH bug report it on JIRA.

Work around right now turn off HTTP POST and load the CDR from the file system. 
Interesting that when XML CDR is saved to the file system it correctly escapes 
the XML data where it fails to do so 100% when using the HTTP POST.

Original comment by markjcrane@gmail.com on 5 May 2015 at 10:22

• Changed state: Done