X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=sql%2FPg-upgrade2%2Finvoice_positions.pl;h=d92daca6e4739d6704212359f2b20886a7423be6;hb=0c96594cddd9ea0cabb4a8cfd052812af21b47ed;hp=18ea9e9bcc604835d91242a8b5315deedbafe472;hpb=2a1e80a83b3c03fa6bd6b6103883b040f92ff382;p=kivitendo-erp.git

diff --git a/sql/Pg-upgrade2/invoice_positions.pl b/sql/Pg-upgrade2/invoice_positions.pl
index 18ea9e9bc..d92daca6e 100644
--- a/sql/Pg-upgrade2/invoice_positions.pl
+++ b/sql/Pg-upgrade2/invoice_positions.pl
@@ -17,11 +17,13 @@ sub run {
 
 
   $query = qq|SELECT * FROM invoice ORDER BY trans_id, id|;
+  my $query2 = qq|UPDATE invoice SET position = ? WHERE id = ?|;
 
   my $sth = $self->dbh->prepare($query);
+  my $sth2 = $self->dbh->prepare($query2);
   $sth->execute || $::form->dberror($query);
 
-  # set new posittion field in order of ids, starting by one for each invoice
+  # set new position field in order of ids, starting by one for each invoice
   my $last_invoice_id;
   my $position;
   while (my $ref = $sth->fetchrow_hashref("NAME_lc")) {
@@ -32,10 +34,10 @@ sub run {
     }
     $last_invoice_id = $ref->{trans_id};
 
-    $query = qq|UPDATE invoice SET position = ? WHERE id = ?|;
-    $self->db_query($query, bind => [ $position, $ref->{id} ]);
+    $sth2->execute($position, $ref->{id});
   }
   $sth->finish;
+  $sth2->finish;
 
   $query = qq|ALTER TABLE invoice ALTER COLUMN position SET NOT NULL|;
   $self->db_query($query);