[ic] New Items errors...

Paul Stearns pauls@compuace.com
Mon, 20 Nov 2000 00:06:16 -0500

I am having 2 problems, potentially related.

Problem 1.

When I am in the admin interface, the merchandising section, when I click on the
last column Promotion) and the row contains "none" I get an Internal Server error,
and the error log contains;

============= c7VwiW26: - [20/November/2000:00:28:54 -0500] flcit
rus /cgi-bin/flcitrus/admin/item_feature Safe: There is no row with index '55W'
at /usr/lib/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;
> c7VwiW26: - [20/November/2000:00:28:54 -0500] flcit
rus /cgi-bin/flcitrus/admin/item_feature Runtime error: Can't call method "open_
table" on an undefined value at /usr/lib/interchange/lib/Vend/Data.pm line 789.


If the promotions column contains a value other than "none", it seems to work

I searched the archives looking for this issue & couldn't find it. Any ideas?

Problem 2.

When I click on "New Items" in the user interface (the store, not the admin), it
returns no items and logs the following error;

============== c7VwiW26: - [20/November/2000:00:51:24 -0500] flcit
rus /cgi-bin/flcitrus/scan/fi=merchandisingsf=featuredse=new.html search error:
Search strings must be at least 1 characters.
> You had no search string specified.

The field "search" in the table "cat" for the record "New items" contains

This is a somewhat (not very) modified version of the demo. The main changes have
been cosmetic and replacing the demo data with live data. I have added some "new"
products using the merchandising table maintenance because of problem 1 above.

I am obviously new at this which is why I've chosen to change as little as

While typing this I discovered the following;

I went to the vanilla construct demo which I installed and have handy in case
something like this arises, and discovered the following;

The "cat" record for "New items" had each of the parameters fi, sf, and se on a
line by themself. Somehow this got changed, I put it back and that solved problem

Problem 1 occurs in the demo straight out of the box(?).