X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=SL%2FIC.pm;h=b9ad62c585a3b33d90792a3c9063bb085aae50e4;hb=997c9f2390c5cf472b221b75d55e1c866612219a;hp=3845017f36551c697f9cc21d68abc91fdc94ba99;hpb=ee454f5b3b7979f407a9429dfc04c5d7302ed1f8;p=kivitendo-erp.git

diff --git a/SL/IC.pm b/SL/IC.pm
index 3845017f3..b9ad62c58 100644
--- a/SL/IC.pm
+++ b/SL/IC.pm
@@ -350,7 +350,7 @@ sub save {
     }
 
     ($form->{id}) = selectrow_query($form, $dbh, qq|SELECT nextval('id')|);
-    do_query($form, $dbh, qq|INSERT INTO parts (id, partnumber) VALUES (?, '')|, $form->{id});
+    do_query($form, $dbh, qq|INSERT INTO parts (id, partnumber, unit) VALUES (?, '', '')|, $form->{id});
 
     $form->{orphaned} = 1;
     if ($form->{partnumber} eq "" && $form->{"item"} eq "service") {
@@ -1633,7 +1633,7 @@ sub prepare_parts_for_printing {
   my $placeholders = join ', ', ('?') x scalar(@part_ids);
   my $query        = qq|SELECT mm.parts_id, mm.model, v.name AS make
                         FROM makemodel mm
-                        LEFT JOIN vendor v ON (mm.make = cast (v.id as text))
+                        LEFT JOIN vendor v ON (mm.make = v.id)
                         WHERE mm.parts_id IN ($placeholders)|;
 
   my %makemodel    = ();