fix the bin->bin_ver join in updatesqlcache

[debbugs.git] / bin / debbugs-updatesqlcache

diff --git a/bin/debbugs-updatesqlcache b/bin/debbugs-updatesqlcache
index 8e57d4a0032a6c994d3a10e9cd8849d9118d5fc0..0c00c590f1d456705e700e33c13c1a46f75e382c 100755 (executable)
--- a/bin/debbugs-updatesqlcache
+++ b/bin/debbugs-updatesqlcache
@@ -226,11 +226,12 @@ sub update_cache {
            $s->resultset('BinAssociation')->
            search_rs({'me.modified' => {'>=',$last_query_time},
                      },
-                    {columns => [qw(bug_binpackages.id)],
-                     join => {bin_vers =>
+                    {columns => [qw(bug_binpackage.id)],
+                     join => {bin =>
+                             {bin_vers =>
                              {bin_pkg =>
-                              'bug_binpackages'
-                             }},
+                              'bug_binpackage'
+                             }}},
                      result_class => 'DBIx::Class::ResultClass::HashRefInflator',
                     },
                     )->all();
@@ -240,10 +241,10 @@ sub update_cache {
            $s->resultset('SrcAssociation')->
            search_rs({'me.modified' => {'>=',$last_query_time},
                      },
-                    {columns => [qw(bug_srcpackages.id)],
-                     join => {src_vers =>
+                    {columns => [qw(bug_srcpackage.id)],
+                     join => {source =>
                              {src_pkg =>
-                              'bug_srcpackages'
+                              'bug_srcpackage'
                              }},
                      result_class => 'DBIx::Class::ResultClass::HashRefInflator',
                     },