X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=sql%2FPg-upgrade2%2FUSTVA_abstraction.pl;h=96c6b73b4524bff03ace0629be7dc4ae9a982643;hb=c696ba272784e16fbac7e3e9a09f2e18eb469217;hp=9c217188415e685f2ca877a8706c1f0cd176cdcd;hpb=d65bfa97a852b44c2a713ae2f7dc266269814488;p=kivitendo-erp.git diff --git a/sql/Pg-upgrade2/USTVA_abstraction.pl b/sql/Pg-upgrade2/USTVA_abstraction.pl index 9c2171884..96c6b73b4 100644 --- a/sql/Pg-upgrade2/USTVA_abstraction.pl +++ b/sql/Pg-upgrade2/USTVA_abstraction.pl @@ -8,6 +8,8 @@ ################### +use strict; + die("This script cannot be run from the command line.") unless ($main::form); sub mydberror { @@ -147,7 +149,7 @@ sub do_copy { my $query = $iconv->convert($copy_statements[$statement]); my $sth = $dbh->prepare($query) || mydberror($query); - for my $copy_line ( 1 .. $#{$copy_data[$statement]} ) { + for my $copy_line ( 0 .. $#{$copy_data[$statement]} ) { #print $copy_data[$statement][$copy_line] . "
" $sth->execute(split m/;/, $iconv->convert($copy_data[$statement][$copy_line]), -1) || mydberror($query); }