[ic] Problem with 'aq' column op

Ron Phipps rphipps at reliant-solutions.com
Thu Jun 10 16:25:20 EDT 2004


Hello,

I'm on IC 5.0.0, Perl 5.6.1, MySQL.  I'm running a custom store.  I have
the following search profile:

__NAME__ keyword_search
mv_search_page=search_results
mv_searchtype=db
mv_coordinate=yes
mv_search_file=products
mv_return_fields=sku,title,image,short_description,long_description,msrp
_price,free_batteries,free_shipping,mfgr_id,import_type,option_type,hcpc
s_code
mv_sort_field=title
mv_search_field=:long_description:short_description:title:sku
mv_column_op=aq
mv_search_field=user_inactive
mv_searchspec=0
mv_column_op===
mv_search_field=import_inactive
mv_searchspec=0
mv_column_op===
mv_matchlimit=10
__END__

I enter the word 'canes' into the search box and hit enter.  14 products
are returned as expected.  After the result is returned if I hit refresh
on my browser some times it works and other times I receive the
following in the error log and no results are returned:

store /search.html search error: Limit subroutine creation: Bad code:
syntax error at (eval 519) line 8, near "] aqcanes "

Some times I can hit refresh 5 times and the results are returned each
time.  Other times it errors out the first time I hit refresh.  It's
very unpredictable on the number of times I can hit refresh before it
errors out.  

I have tried removing the column op of 'aq' and just searching on the
title field and I can refresh that search results as many times as I
want so it appears to be a problem with the 'aq' code path.  I'm
currently debugging the search code to see where the problem might lie
and will post if I find anything of use.

Thanks,
-Ron



More information about the interchange-users mailing list