[ic] Problem with 'aq' column op

Mike Heins mike at perusion.com
Thu Jun 10 17:28:46 EDT 2004


Quoting Ron Phipps (rphipps at reliant-solutions.com):
> 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 "
> 

This is probably a bug in save_more (can't save the query subroutine in
Storable) that was fixed sometime before IC5.2.

-- 
Mike Heins
Perusion -- Expert Interchange Consulting    http://www.perusion.com/
phone +1.765.647.1295  tollfree 800-949-1889 <mike at perusion.com>

If you like what you're gettin', keep doin' what you're doin'. -- Hector


More information about the interchange-users mailing list