--=====================_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.

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?