Akopia Akopia Services

[Date Prev][Date Next][Thread Prev][Thread Next][Minivend by date ][Minivend by thread ]

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



Quoting Randy Moore (ramoore@axion-it.net):
> 
> 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} = 
> '';

This means that for some reason those variables are not being defined
in your variable.txt. Place this line in catalog_before.cfg:

Variable  UI_ITEM_DESCRIPTION  description

There should already be a line:

Variable UI_PRODUCT_TABLE  products

This is being replaced in future versions with __DescriptionField__, which
is the value of the DescriptionField directive. I don't think it is in
4.6.1 (the code for AutoVariable, to set certain directive values to
variable values for easy access).

-- 
Akopia, Inc., 131 Willow Lane, Floor 2, Oxford, OH  45056
phone +1.513.523.7621 fax 7501 <heins@akopia.com>

Friends don't let friends use Outlook. -- Bob Blaylock

_______________________________________________
Interchange-users mailing list
Interchange-users@lists.akopia.com
http://lists.akopia.com/mailman/listinfo/interchange-users


Search for: Match: Format: Sort by: