From: khoff <khoff>
Date: Wed, 6 Apr 2005 00:50:36 +0000 (+0000)
Subject: $pkey should be the primary key of the real table, not the history table.
X-Git-Tag: BEFORE_FINAL_MASONIZE~602
X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=commitdiff_plain;h=52c6b069246af5ca57d44287b542a3d8b5b78e70

$pkey should be the primary key of the real table, not the history table.
---

diff --git a/FS/FS/h_Common.pm b/FS/FS/h_Common.pm
index e575cffdb..d55da8cfb 100644
--- a/FS/FS/h_Common.pm
+++ b/FS/FS/h_Common.pm
@@ -40,8 +40,9 @@ sub sql_h_search {
   my( $self, $end ) = ( shift, shift );
 
   my $table = $self->table;
-  my $pkey = dbdef->table($table)->primary_key
-    or die "can't (yet) search history table $table without a primary key";
+  my $real_table = ($table =~ /^h_(.*)$/) ? $1 : $table;
+  my $pkey = dbdef->table($real_table)->primary_key
+    or die "can't (yet) search history table $real_table without a primary key";
 
   unless ($end) {
     confess 'Called sql_h_search without END_TIMESTAMP';