[mv] weird errors with mv_matchlimit

[Garey Hoffman <ghoffman@sumaato.com>]

******    message to minivend-users from Garey Hoffman <ghoffman@sumaato.com>     ******

I am doing a simple SQL search that should return a result set from my
products database table. For some reason, the search returns an Apache
"Internal Server Error" when the mv_matchlimit is above 5.  If I set it
to 5 or below, it works great.  It still gives me an error if I take
this parameter out completely.  The datatypes of the mv_search_field
columns are varchar and tinytext (this is a MySQL database).  I search
the maillist archives and didn't find anything that looked like this
type of problem.  Can anyone see if I am doing something wrong here?

Any advice would be greatly appreciated.

TIA

---Garey

----Here's my search form:

<FORM ACTION="[process-search]" METHOD=POST>
	<INPUT TYPE=text NAME="mv_searchspec" SIZE="20">
	<INPUT TYPE="image" SRC="order/search.gif" Width="80" HEIGHT="20"
BORDER="0" VALUE="Search" ALIGN="top">
	<INPUT TYPE="hidden" NAME="mv_matchlimit" VALUE="5">
	<INPUT TYPE=hidden NAME="mv_searchtype" VALUE="sql"> 
	<INPUT TYPE=hidden NAME="mv_search_field" VALUE="category">
	<INPUT TYPE=hidden NAME="mv_search_field" VALUE="description">
	<INPUT TYPE=hidden NAME="mv_search_field" VALUE="keywords">
	<INPUT TYPE="hidden" NAME="mv_doit" VALUE="search">
	<INPUT TYPE="hidden" NAME="mv_substring_match" VALUE="yes">
</FORM>

----Here's the results page:

[search-region send=1]
[search-list]
[on-change 1]
	[condition][item-field category][/condition]
	<B>[item-field category]</B></FONT>
[/on-change 1]

[item-field title]<BR>
[item-field description]<BR>

[if ordered [item-code]]
	<B>This item is currently in your shopping basket.</B>
[/if]
[/search-list]
			
[no-match]
	Sorry, no matches for <B>[value mv_searchspec]</B>. Try changing your
search.<BR>
[/no-match]
			
[more-list]
	Matches [matches] of
	[if value mv_search_match_count > 1]
	[value mv_search_match_count] titles found.
	[/if]
	<BLOCKQUOTE>
	<B>Links to more matches:</B><BR>
	[more]
	</BLOCKQUOTE>
[/more-list]
[/search-region]
-
To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
Archive of past messages: http://www.minivend.com/minivend/minivend-list