From 21ae7910a5ed55314b4507023c383d74bc2860bd Mon Sep 17 00:00:00 2001
From: Ivan Kohler <ivan@freeside.biz>
Date: Mon, 30 Jun 2014 14:36:55 -0700
Subject: [PATCH] use a separate table for freesidestatus for IVR imports,
 RT#39055

---
 FS/FS/cdr/Import.pm | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/FS/FS/cdr/Import.pm b/FS/FS/cdr/Import.pm
index 472e22062..e788712c4 100644
--- a/FS/FS/cdr/Import.pm
+++ b/FS/FS/cdr/Import.pm
@@ -83,7 +83,7 @@ sub dbi_import {
   #my @cols = values %{ $args{column_map} };
   my $sql = "SELECT * FROM $table "; # join(',', @cols). " FROM $table ".
   $sql .=  'LEFT JOIN '. $args{status_table}.
-           ' USING ( '. $args{primary_key}. ' )'
+           " ON ( $table.$pkey = ". $args{status_table}. ".$pkey )"
     if $args{status_table};
   $sql .= ' WHERE freesidestatus IS NULL ';
 
-- 
2.11.0