[ic] search error: Unknown mv_column_op searching 2 tables?

Angus Rogerson arogerso at uwaterloo.ca
Wed Oct 10 17:01:19 UTC 2012

Hey Andy,

I am just guessing here, but I notice:
- the error message mentions an array
- mv_column_op is a single value
- mv_search_file is multiple values when it fails, and single value when it works
- mv_coordinate is on
so I would expect a coordinate 'stacking' problem.

I expect you are thinking that the two files are both product files so you are doing a single search on both files, but maybe search sees a coordinated search with two conditions, so I would try:

- mv_coordinate no
- mv_search_field title,title
- mv_searchspec $w1,$w1
- mv_column_op rm,rm
perhaps just change mv_column_op to rm,rm to see whether the error message changes to complain about one of the other fields mv_search_field, mv_searchspec etc



On 2012-10-09, at 5:43 PM, IC wrote:

> Hi Folks,
> When using the below actionmap that searches 2 product tables I get an error
> in the log everytime the page is accessed even though the search works fine,
> in the log I see loads of:-
> search error: Unknown mv_column_op (ARRAY(0xb38eef8))
> If I remove either table, I no longer get the errors, is it possible to
> search both product tables and not get the error?
> Here is the actionmap
>    $CGI->{mv_todo} = 'search';
>    $CGI->{mv_searchtype} = 'db';
>    $CGI->{mv_coordinate} = 'yes';
>    $CGI->{mv_substring_match} = 'yes';
>    $CGI->{mv_return_fields} = 'sku,sale_price';
>    $CGI->{mv_search_page} = 'results12';    
>    $CGI->{mv_search_file} = 'products,products2';
>    $CGI->{mv_search_field} = 'title';      
>    $CGI->{mv_searchspec} = "$w1";
>    $CGI->{mv_column_op} = 'rm';
> Thanks,
> Andy
> _______________________________________________
> interchange-users mailing list
> interchange-users at icdevgroup.org
> http://www.icdevgroup.org/mailman/listinfo/interchange-users

More information about the interchange-users mailing list