Missing semicolon in UPDATE instruction.

[fa-stable.git] / sql / alter2.4rc1.sql

diff --git a/sql/alter2.4rc1.sql b/sql/alter2.4rc1.sql
index 4091f80ac9cd7dd79ea6ef9d661bf49d2615bc27..d49e498aadc069867cb51ca7a3e9cd68de655689 100644 (file)
--- a/sql/alter2.4rc1.sql
+++ b/sql/alter2.4rc1.sql
@@ -39,7 +39,7 @@ UPDATE `0_sys_prefs` SET `name`='default_wip_act' WHERE `name`='default_assembly
 
 UPDATE `0_wo_issue_items` i, `0_stock_moves` m
        SET i.unit_cost=m.standard_cost
-       WHERE i.unit_cost=0 AND i.stock_id=m.stock_id AND m.trans_no=i.issue_id AND m.`type`=28 AND m.qty=-i.qty_issued
+       WHERE i.unit_cost=0 AND i.stock_id=m.stock_id AND m.trans_no=i.issue_id AND m.`type`=28 AND m.qty=-i.qty_issued;
 
 UPDATE `0_wo_requirements` r, `0_stock_moves` m
        SET r.unit_cost=m.standard_cost