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

[Randy Moore]

--=====================_64846718==_.ALT
Content-Type: text/plain; charset="us-ascii"; format=flowed

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 
--=====================_64846718==_.ALT
Content-Type: text/html; charset="us-ascii"

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

--=====================_64846718==_.ALT--