From 4b4c9020f4ae9b4a79d11b8bc17e75405fcfef72 Mon Sep 17 00:00:00 2001 From: Moritz Bunkus Date: Thu, 11 Dec 2008 13:24:27 +0000 Subject: [PATCH] =?utf8?q?Beim=20Upgrade=20und=20Einf=C3=BChrung=20des=20n?= =?utf8?q?euen=20Lagers=20die=20Zeilen=20in=20inventory=20mit=20leerer=20C?= =?utf8?q?hargennummer=20bef=C3=BCllen=20(nicht=20mit=20NULL),=20weil=20de?= =?utf8?q?r=20Rest=20des=20Lagercodes=20von=20leeren=20Strings=20ausgeht,?= =?utf8?q?=20wenn=20keine=20Chargennummer=20verwendet=20wird.=20Ansonsten?= =?utf8?q?=20wertet=20Lx-Office=20zwei=20Eintr=C3=A4ge=20ohne=20Chargennum?= =?utf8?q?mer=20als=20unterschiedlich=20(einmal=20NULL,=20einmal=20leerer?= =?utf8?q?=20String),=20und=20man=20kann=20die=20migrierten=20Best=C3=A4nd?= =?utf8?q?e=20nicht=20mehr=20ver=C3=A4ndern.?= MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit Fix für Bug 876. --- sql/Pg-upgrade2/warehouse.pl | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/sql/Pg-upgrade2/warehouse.pl b/sql/Pg-upgrade2/warehouse.pl index e205670c7..f9e59a4e5 100644 --- a/sql/Pg-upgrade2/warehouse.pl +++ b/sql/Pg-upgrade2/warehouse.pl @@ -63,8 +63,8 @@ INSERT INTO bin FROM warehouse, tmp_parts WHERE warehouse.description=$warehouse); INSERT INTO inventory - (warehouse_id, parts_id, bin_id, qty, employee_id, trans_id, trans_type_id) - (SELECT warehouse.id, tmp_parts.id, bin.id, onhand, (SELECT id FROM employee LIMIT 1), nextval('id'), transfer_type.id + (warehouse_id, parts_id, bin_id, qty, employee_id, trans_id, trans_type_id, chargenumber) + (SELECT warehouse.id, tmp_parts.id, bin.id, onhand, (SELECT id FROM employee LIMIT 1), nextval('id'), transfer_type.id, '' FROM transfer_type, warehouse, tmp_parts, bin WHERE warehouse.description = $warehouse AND COALESCE(bin, $bin) = bin.description -- 2.20.1