From: Don Armstrong <don@donarmstrong.com>
Date: Mon, 7 Aug 2017 21:03:33 +0000 (-0700)
Subject: fix the bin->bin_ver join in updatesqlcache
X-Git-Url: https://git.donarmstrong.com/?p=debbugs.git;a=commitdiff_plain;h=e78ac0ab15da5fb8538da0992feba8814b76d0b2

fix the bin->bin_ver join in updatesqlcache
---

diff --git a/bin/debbugs-updatesqlcache b/bin/debbugs-updatesqlcache
index 4a8be5e..0c00c59 100755
--- a/bin/debbugs-updatesqlcache
+++ b/bin/debbugs-updatesqlcache
@@ -227,10 +227,11 @@ sub update_cache {
 	    search_rs({'me.modified' => {'>=',$last_query_time},
 		      },
 		     {columns => [qw(bug_binpackage.id)],
-		      join => {bin_ver =>
+		      join => {bin =>
+			      {bin_vers =>
 			      {bin_pkg =>
 			       'bug_binpackage'
-			      }},
+			      }}},
 		      result_class => 'DBIx::Class::ResultClass::HashRefInflator',
 		     },
 		     )->all();
@@ -241,7 +242,7 @@ sub update_cache {
 	    search_rs({'me.modified' => {'>=',$last_query_time},
 		      },
 		     {columns => [qw(bug_srcpackage.id)],
-		      join => {src_ver =>
+		      join => {source =>
 			      {src_pkg =>
 			       'bug_srcpackage'
 			      }},