Merge branch 'master' of vc.linet-services.de:public/lx-office-erp

[kivitendo-erp.git] / sql / Pg-upgrade2 / USTVA_abstraction.pl

diff --git a/sql/Pg-upgrade2/USTVA_abstraction.pl b/sql/Pg-upgrade2/USTVA_abstraction.pl
index 9c21718..96c6b73 100644 (file)
--- 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] . "<br />"
       $sth->execute(split m/;/, $iconv->convert($copy_data[$statement][$copy_line]), -1) || mydberror($query);
     }