Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Search adds "+" between keywords


Guest

Recommended Posts

Posted

I installed 'Search enhancement' mod that removes "s" from the end of plural words to help get better search results. This works great, but the only problem is, it adds an "+" in the actual search box between words and there for returns 0 results.

 

I've systematically removed all code that i've added to see if this solves the problem... nothing.. I even removed EVERYTHING except the MySQL changes.. still does it. So It must be something in the mySQL that I added with this mod.

 

Here is what the module says to add to the database:

 

CREATE TABLE `search_queries` (
 `search_id` int(11) NOT NULL auto_increment,
 `search_text` tinytext,
 PRIMARY KEY  (`search_id`)
) TYPE=MyISAM AUTO_INCREMENT=24;

CREATE TABLE `search_queries_sorted` (
 `search_id` smallint(6) NOT NULL auto_increment,
 `search_text` tinytext NOT NULL,
 `search_count` int(11) NOT NULL default '0',
 PRIMARY KEY  (`search_id`)
) TYPE=MyISAM AUTO_INCREMENT=134;

CREATE TABLE `searchword_swap` (
 `sws_id` mediumint(11) NOT NULL auto_increment,
 `sws_word` varchar(100) NOT NULL default '',
 `sws_replacement` varchar(100) NOT NULL default '',
 PRIMARY KEY  (`sws_id`)
) TYPE=MyISAM AUTO_INCREMENT=28;

 

Is there something that is in there telling it to join keywords with a "+"? I'm not very good with mySQL stuff.

 

You can give it a go at defensemaster.com

 

Thanks again to everyone!

 

-Jrock

Posted

I found a solution, and unlike half the post in here where people say they found a solution and do not tell what it was, I will tell everyone what I found:

 

In advanced_search_results.php find:

 

header('location: ' . tep_href_link( FILENAME_ADVANCED_SEARCH_RESULT , 'search_in_description=1&s=1&keywords=' . urlencode($pwstr_replace) . '' ));

 

and replacing urlencode with rawurlencode

 

-Jrock

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...