Database error when updating item.

diff --git a/CHANGELOG.txt b/CHANGELOG.txt
index c4f9cdb1e686b65f0a9831ccbac9275cbd785837..aa99151e29c884314dcea6310ab1fe9acdef1451 100644 (file)
--- a/CHANGELOG.txt
+++ b/CHANGELOG.txt
@@ -20,6 +20,8 @@ Legend:
 $ -> Affected files
 
 27-Oct-2009 Joe Hunt
+# Database error when updating item.
+$ /inventory/includes/db/items_db.inc
 # Removed unneeded double forms in scripts with db_pager. Missing $_POST variables.
 $ /dimensions/inquiry/search_dimensions.php
   /manufacturing/search_work_orders.php

diff --git a/inventory/includes/db/items_db.inc b/inventory/includes/db/items_db.inc
index 9b382287749a65f93ee2748da615566eaed1d29d..b0553726158e0319b1be4ba2dc1f6e1072a13ecb 100644 (file)
--- a/inventory/includes/db/items_db.inc
+++ b/inventory/includes/db/items_db.inc
@@ -24,7 +24,7 @@ function update_item($stock_id, $description, $long_description, $category_id,
                assembly_account=".db_escape($assembly_account).",
                dimension_id=".db_escape($dimension_id).",
                dimension2_id=".db_escape($dimension2_id).",
-               tax_type_id=".db_escape($tax_type_id)."
+               tax_type_id=".db_escape($tax_type_id).",
                no_sale=".db_escape($no_sale);
 
        if ($units != '')