[mv] Search Engine Problems

["DEG" <davidgindelberger@yahoo.com>]

******    message to minivend-users from "DEG" <davidgindelberger@yahoo.com>     ******

I am using MV 3.14 with redhat 6.1 and have had a few problems with the
search engine. I generate the products database from a tab seperated text
file that i make with filemaker and edit to replace the linefeeds for unix.
This file is then imported in to MV and reviewed with minimate. All looks
fine.  I do a search: unique items show up multiple times, matching items do
not show and non-matching items are displayed.  I tried trashing the
products.gdbm file and the session.gdbm file and restarting - no luck:
Also, one line searches give similar results. Here are the snippets of HTML
for the search pages (2 different pages):


[set Keyword]
mv_search_field=title
mv_search_field=author
mv_search_field=info
[/set]
<TABLE WIDTH="720" BORDER="0" CELLSPACING="0" CELLPADDING="0" HEIGHT="122">
<TR>
<TD WIDTH="55" ></TD>
<TD HEIGHT="70" COLSPAN="3"><CENTER>[rotate]</CENTER></TD>
</TR>
<TR>
<TD WIDTH="55"></TD>
<TD WIDTH="451" HEIGHT="10" ALIGN="RIGHT">
<IMG SRC="menu.jpg" WIDTH="451" HEIGHT="114" USEMAP="#MENU" BORDER="0"></TD>
<TD WIDTH="200" BGCOLOR="#FFFFCC" HEIGHT="100">
<CENTER><FONT SIZE="2">
<FORM ACTION="[process-search]" METHOD="POST">
<INPUT NAME="mv_searchspec" SIZE="15" TYPE="text">
<INPUT TYPE="submit" NAME="mv_todo" VALUE="Search">
<INPUT TYPE="hidden" NAME="mv_substring_match" VALUE="yes">
<INPUT TYPE="hidden" NAME="mv_searchtype" VALUE="text">
<INPUT TYPE="hidden" NAME="mv_matchlimit" VALUE=10>
<INPUT TYPE="hidden" NAME="mv_min_string" VALUE=4>
<INPUT TYPE="hidden" NAME="mv_max_matches" VALUE=1>
<!--mv_max_matches doesn't work!!??-->
<BR>
Search by:
<BR>
<SELECT NAME="mv_search_field">
<OPTION VALUE="Keyword" SELECTED>Keyword
<OPTION VALUE="title">Title
<OPTION VALUE="author">Author
<OPTION VALUE="ISBN">ISBN
</SELECT>
</CENTER></FONT>
</TD>
</TR>
</TABLE>
</FORM>


And the second page:

 <TD COLSPAN=2 ALIGN=CENTER>
  <FORM ACTION="[process-search]" METHOD="POST">
  <INPUT NAME="mv_searchspec" SIZE="20" TYPE="text">
  <INPUT TYPE="hidden" NAME="mv_all_chars" VALUE=1>
  <INPUT TYPE="submit" NAME="mv_todo" VALUE="Search">
  <INPUT TYPE="hidden" NAME="mv_searchtype" VALUE="text">
  <INPUT TYPE="hidden" NAME="mv_search_file" VALUE="products">
 </TD>
 <TD VALIGN=CENTER >
  <BR>
  <FONT SIZE=-1>
  <SELECT NAME="sort_field1">
   <OPTION VALUE="products:title"> Title
   <OPTION VALUE="products:author"> Author
   <OPTION VALUE="products:ISBN:n"> ISBN
   <OPTION VALUE="">[L]none[/L]
  </SELECT>
  <SELECT NAME="sort_field2">
   <OPTION VALUE=""> none
   <OPTION VALUE="products:author"> [L]Author[/L]
   <OPTION VALUE="products:ISBN:n"> [L]ISBN[/L]
   <OPTION VALUE="products:title"> [L]Title[/L]
  </SELECT>
  <SELECT NAME="sort_field3">
   <OPTION VALUE=""> none
   <OPTION VALUE="products:ISBN:n">[L]ISBN[/L]
   <OPTION VALUE="products:title:"> [L]Title[/L]
   <OPTION VALUE="products:author:"> [L]Author[/L]

  </SELECT>
  </FONT>
 </TD>

<TR>
 <TD VALIGN=TOP WIDTH=200><BR><BR>
  <INPUT TYPE="radio" NAME="mv_orsearch" VALUE="no">&nbsp;[L]Must match
all[/L]<BR>
  <INPUT TYPE="radio" NAME="mv_orsearch" VALUE="yes" CHECKED>&nbsp;[L]Match
any[/L]<BR>
  <INPUT TYPE="checkbox" NAME="mv_substring_match" VALUE="yes"
CHECKED>&nbsp;[L]Match substrings[/L]
 </TD>
 <TD VALIGN=TOP><BR><BR>
  <B>[L]Fields to search[/L]:<B><BR>
  <INPUT TYPE="radio" NAME="mv_search_field" VALUE="author">
   [L]Author[/L]<BR>
  <INPUT TYPE="radio" NAME="mv_search_field" VALUE="title" CHECKED>
   [L]Title[/L]<BR>
  <INPUT TYPE="radio" NAME="mv_search_field" VALUE="ISBN">
   [L]ISBN[/L]<BR>
 </TD>
</FORM>

 <TD COLSPAN=2 ALIGN=CENTER><BR><BR>
 <B><I>Search by Category: </B></I><BR>(UPDATE&nbsp;THIS!)
 <FORM ACTION="[process-search]" METHOD="POST"
ENCTYPE="x-www-form-urlencoded">
 <INPUT TYPE="hidden" NAME="mv_search_field" VALUE="subcategory">
 <SELECT NAME="mv_searchspec" >
   <OPTION VALUE="lit"> Literature
   <OPTION VALUE="free"> Free Stuff
   <OPTION VALUE="science"> Science
   <OPTION VALUE="scifi"> Sci-Fi
   <OPTION VALUE="western"> Western
   </SELECT>
  <INPUT TYPE="submit" NAME="mv_todo" VALUE="Search">
  <INPUT TYPE="hidden" NAME="mv_searchtype" VALUE="glimpse">
  <INPUT TYPE="hidden" NAME="mv_search_file" VALUE="products">
 <BR><BR>
 </FORM>
 </TD>


Any help would be appreciated!!!

TIA
Dave

-
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