[ic] Server error on promotions

Jerry O'Brien interchange-users@interchange.redhat.com
Wed Jan 9 18:05:01 2002


Hi,

I just built a new catalog based on Construct in IC 4.6. I have product
entered, but when I try to go to the promotion page to add an item to the
new items list, I get a server error and this is in the catalog's error.log.

 - [09/January/2002:16:53:12 -0600] aking /cgi-bin/aking/admin/item_feature
Safe: There is no row with index 'ak00010' at
/home/interch/interchange/lib/Vend/Table/Common.pm line 255.
>
>
>       my $db = $Db{merchandising};
>       my $date = $Tag->convert_date({ raw => 1 });
>       my $code = $CGI->{item_id} or return;
>       return unless $db->field($code, 'timed_promotion');
>       return if $date le $db->field($code, 'finish_date');
>       $db->set_field($code, 'featured', 'expired');
>       return;
>
>
 - [09/January/2002:16:53:12 -0600] aking /cgi-bin/aking/admin/item_feature
Runtime error: Can't call method "open_table" on an undefined value at
/home/interch/interchange/lib/Vend/Data.pm line 789.
>

ak00010 is a valid SKU and it does this for any item in the DB. Does this
ring a bell with anyone?

Also, I'd like to upgrade this installation to 4.8, but there only seems to
be info on upgrading from MV in the online docs. Can someone point me to
instructions to upgrade a working server from 4.6 to 4.8 with minimal impact
to my customers?

Thanks,

Jerry O'Brien
Cutting Edge Systems, Inc.