the column for the bug id is bug, not id

[debbugs.git] / bin / debbugs-updatesqlcache

diff --git a/bin/debbugs-updatesqlcache b/bin/debbugs-updatesqlcache
index 0c00c590f1d456705e700e33c13c1a46f75e382c..b2838463e5c0bb50dffd864171072e1a3b86964a 100755 (executable)
--- a/bin/debbugs-updatesqlcache
+++ b/bin/debbugs-updatesqlcache
@@ -222,29 +222,28 @@ sub update_cache {
        # select all bugs which are in packages which have had a binary
        # association modified
        push @bugs,
-           map {$_->{'bug_binpackages.id'}}
+           map {$_->{'bug_binpackages.bug'}}
            $s->resultset('BinAssociation')->
            search_rs({'me.modified' => {'>=',$last_query_time},
                      },
-                    {columns => [qw(bug_binpackage.id)],
+                    {columns => [qw(bug_binpackages.bug)],
                      join => {bin =>
-                             {bin_vers =>
                              {bin_pkg =>
-                              'bug_binpackage'
-                             }}},
+                              'bug_binpackages'
+                             }},
                      result_class => 'DBIx::Class::ResultClass::HashRefInflator',
                     },
                     )->all();
        # or a source association modified
        push @bugs,
-           map {$_->{'bug_srcpackages.id'}}
+           map {$_->{'bug_srcpackages.bug'}}
            $s->resultset('SrcAssociation')->
            search_rs({'me.modified' => {'>=',$last_query_time},
                      },
-                    {columns => [qw(bug_srcpackage.id)],
+                    {columns => [qw(bug_srcpackages.bug)],
                      join => {source =>
                              {src_pkg =>
-                              'bug_srcpackage'
+                              'bug_srcpackages'
                              }},
                      result_class => 'DBIx::Class::ResultClass::HashRefInflator',
                     },