fix the bin->bin_ver join in updatesqlcache

diff --git a/bin/debbugs-updatesqlcache b/bin/debbugs-updatesqlcache
index 4a8be5e3eb4e11701248619840d55750d6796f02..0c00c590f1d456705e700e33c13c1a46f75e382c 100755 (executable)
--- 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'
                              }},