X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=sql%2FPg-upgrade2%2Fadd_more_constraints_fibu_projekt_xplace.pl;h=187eea4042c70e364966f2a33b5395bc3b281fcd;hb=30b4a78c4100ebdcd6e6917fbcbf1d12f4f7b4d6;hp=67e8e8d68b95f2714dcf6c0fbd3035d21a901ffe;hpb=347f2cff58f8d798bb0fe52495fb09b4e08db036;p=kivitendo-erp.git diff --git a/sql/Pg-upgrade2/add_more_constraints_fibu_projekt_xplace.pl b/sql/Pg-upgrade2/add_more_constraints_fibu_projekt_xplace.pl index 67e8e8d68..187eea404 100644 --- a/sql/Pg-upgrade2/add_more_constraints_fibu_projekt_xplace.pl +++ b/sql/Pg-upgrade2/add_more_constraints_fibu_projekt_xplace.pl @@ -28,8 +28,8 @@ sub run { } } $sth_all_groups->finish(); - my $query = qq|select count(*) from acc_trans where trans_id is NULL|; - my $sth_all_groups = prepare_execute_query($::form, $self->dbh, $query); + $query = qq|select count(*) from acc_trans where trans_id is NULL|; + $sth_all_groups = prepare_execute_query($::form, $self->dbh, $query); while (my $hash_ref = $sth_all_groups->fetchrow_hashref()) { # Schleife if ($hash_ref->{count} eq 0){ # Falls wir keine alte buggy Installation haben, ist es super die @@ -45,7 +45,6 @@ sub run { do_statement($::form,$sth,$query); $sth->finish(); } - $self->dbh ->commit(); return 1; }