[ic] Bug? v6.2.1 - SQL error when editing item Inventories in UI

[Randy Moore <ramoore@axion-it.net>]

Interchange v 4.6.1
mySQLversion 3.22.27
perl v 5.005_03
Redhat 6.0

Problem (see possible fix below):

In the Interchange UI (and using the construct demo), when trying to edit
item quantities, I get the following error:

Sorry, there was an error in processing this form action. Please report
the error or try again later. (You have an error in your SQL syntax near
'= '' where sku = 'fedjobkit1' ' at line 1 ) 
{}
{}
{}
{}
{}
{}


Looking in the mySQL server logs, I see the following
command:

        

update
products SET  = '' where sku = 'fedjobkit1'

Notice that the field name "quantity" is missing.  The
other fields in the inventory table are being set correctly.

If I follow the "Tables" link at the bottom of the UI and edit
the inventory table directly for an item, the quantity is updated
properly.

Possible Fix:

In the file
/usr/local/interchange/lib/UI/admin/pages/item_inventory.html, on both
lines 10 and 11, remove the
'__UI_PRODUCT_TABLE__:__UI_ITEM_DESCRIPTION__' string.

This leaves lines 10 & 11 looking like:
               
$CGI->{ui_data_fields} = '[db-columns
name=inventory]';                           
               
$CGI->{ui_display_only} =
'';                                           

After this change, I can successfully update the quantity field from this
page.

But, I suspect that I'm "treating a symptom rather than the
disease" in this case.  I'd guess that whatever code is
supposed to read & process these values in not handling them properly
when the data is stored in an SQL database

 From the way the code reads, it seems that the product description is
supposed to appear at the top of the form in display mode only, but it is
not appearing at all.

Can anyone else using an SQL backend confirm this problem?  Maybe it
is something strange in my setup?

Thanks.

Randy Moore

Axion Information Technologies, Inc.

email     ramoore@axion-it.net

phone   301-408-1200

fax        301-445-3947