X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=sql%2FPg-upgrade%2FPg-upgrade-2.2.0.33-2.2.0.34.pl;h=297b14ac06bad41b778a1cbcaaaf980384ce5bd3;hb=1de53cbf8a926ae3ae89bc5466ab660df82484b2;hp=497f53f8562e1f487227135e0adaacf4b8285958;hpb=9aaca43317d3ea33d80a308cab7ce4c20d732a16;p=kivitendo-erp.git diff --git a/sql/Pg-upgrade/Pg-upgrade-2.2.0.33-2.2.0.34.pl b/sql/Pg-upgrade/Pg-upgrade-2.2.0.33-2.2.0.34.pl index 497f53f85..297b14ac0 100644 --- a/sql/Pg-upgrade/Pg-upgrade-2.2.0.33-2.2.0.34.pl +++ b/sql/Pg-upgrade/Pg-upgrade-2.2.0.33-2.2.0.34.pl @@ -399,7 +399,7 @@ sub retrieve_std_inventory_accno_id { my $inventory_accno_id; if ($inventory_accno) { - $query = "SELECT id FROM chart WHERE accno = $inventory_accno"; + $query = "SELECT id FROM chart WHERE accno = '$inventory_accno'"; ($inventory_accno_id) = $dbh->selectrow_array($query); }