Re: Updating Item

null@example.com (joe) — Fri, 06 Nov 2009 09:13:43 +0000

Thanks for pointing this out. It has been fixed in CVS 2.2 unstable repository a while ago. Affected file /inventory/manage/items.php. It will be included in final.

/Joe

Updating Item

null@example.com (dano1967) — Fri, 06 Nov 2009 01:17:50 +0000

In file /inventory/includes/db/items_db.inc
function update_item
line

$sql = "UPDATE ".TB_PREF."stock_master SET long_description=".db_escape($long_description).",
description=".db_escape($description).",
category_id=".db_escape($category_id).",
sales_account=".db_escape($sales_account).",
inventory_account=".db_escape($inventory_account).",
cogs_account=".db_escape($cogs_account).",
adjustment_account=".db_escape($adjustment_account).",
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)."
no_sale=".db_escape($no_sale);

is missing a comma after: tax_type_id=".db_escape($tax_type_id)."

Dan

FrontAccounting forum — Updating Item

Re: Updating Item

Updating Item