Guest Posted March 24, 2006 Posted March 24, 2006 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
Guest Posted March 24, 2006 Posted March 24, 2006 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
Recommended Posts
Archived
This topic is now archived and is closed to further replies.