vinoalvino Posted August 31, 2008 Share Posted August 31, 2008 My search not working at all! Tags search is working ...Why? Link to comment Share on other sites More sharing options...
Damien Metzger Posted August 31, 2008 Share Posted August 31, 2008 Hi,It is due to your MySQL configuration.The fulltext mode of MySQL automatically skip words less than 4 characters long. For example, if you're looking for "a big bottle of wine", it will only search for "bottle" and "wine", considering that the other words are useless for the search.Of course, you can change this setting in your configuration. Link to comment Share on other sites More sharing options...
Bruno Leveque Posted August 31, 2008 Share Posted August 31, 2008 Ps: variable to modify is "ft_min_word_len" in your my.cnf configuration file Link to comment Share on other sites More sharing options...
vinoalvino Posted September 1, 2008 Author Share Posted September 1, 2008 Tks for the answer but It not work to with "wine" "red" "Tuscany" "sassicaia" ... all tags word ... Link to comment Share on other sites More sharing options...
Bruno Leveque Posted September 1, 2008 Share Posted September 1, 2008 Strange... - could you give us an url to your shop- could you give us by PM url to your phpMyAdmin + access codesBest regards, Link to comment Share on other sites More sharing options...
vinoalvino Posted September 1, 2008 Author Share Posted September 1, 2008 I'm working on local wamp test web site, I'm making a lot of test. but ...sorry :red: In my test I add a field 'description' in table Product ... The query error was #1052 - Column 'description' in where clause is ambiguoussolved! Link to comment Share on other sites More sharing options...
andrew Posted September 2, 2008 Share Posted September 2, 2008 Hi I have the same problem (I haven't added that description field though) , if I search using Tags it is working perfectly, but if I search with the search it returns nothing (or sometimes an unexpected result).I have even created a whole new test domain installed from scratch since the release of version 1.005Version 0.97 used to work (the search) beautifully - giving the % score as well.Take a look at http://www.brilliantbikes.com/testIn the tags there is an item PAW-12 - the search finds itSearch for PAW-12 in the search box and it is not found.Search in the backoffice and it's also found.Any help would REALLY be appreciated.- Andrew Link to comment Share on other sites More sharing options...
Damien Metzger Posted September 2, 2008 Share Posted September 2, 2008 A fulltext issue. It isn't as good as it seemed. I'll try to patch it. Link to comment Share on other sites More sharing options...
andrew Posted September 10, 2008 Share Posted September 10, 2008 Any news on a fix?- Andrew Link to comment Share on other sites More sharing options...
Damien Metzger Posted September 10, 2008 Share Posted September 10, 2008 I think I replaced the" - " by blanks in the search, and it worked. But it was a long time ago (1 week ) so I can't remember exactly. I'll have to look at what I've done. Link to comment Share on other sites More sharing options...
rawkinrich Posted November 24, 2008 Share Posted November 24, 2008 Hi all,I'm having the same issue. My host (i'm on a shared server) has changed the MySQL to search words with 3 characters and more. But still some searches aren't returning products for some search terms and they now say its the Prestashop search function which is at fault. They say, quote"Apologies, but its seems to be issue with the search script.Its searching with you and had as independent search."Basically, I'm searching for 'if i had you". A product description has this included, but is not being included in the search results. My host say something about an independant search?Any help on this guys?Thanks all Link to comment Share on other sites More sharing options...
daYmo Posted December 9, 2008 Share Posted December 9, 2008 Hi,the problem is in the file /classes/Search.php file where there are "mistakes" using Mysql MATCH function.As a matter of fact, some characters like "-" and " " souhld be replaced with "+" so as to search for both words in the query.Coz if you look for a product reference like "SM-58" and do not replace that "-" ... then it will search for products that contains "SM" but not "58" !So... characters "-", " " should be replaced by "+". And then you can modify the query so as to adapt to what fields are really important in your shop (for instance I focused on Reference, Name and description and it works fine). Link to comment Share on other sites More sharing options...
rcking Posted February 13, 2009 Share Posted February 13, 2009 Can you post your search.php please? still dont work on newest presta Link to comment Share on other sites More sharing options...
daYmo Posted February 13, 2009 Share Posted February 13, 2009 no :-p coz it depends on your version.Give me your file & I'll give it back to you. Or.. OK I'll post a Search.php file from PS 1.1 version.But by now I'm on...... week end !I'll give it to you on monday morning or tomorrow.... ok let's say tomorrowCiao Link to comment Share on other sites More sharing options...
rcking Posted February 13, 2009 Share Posted February 13, 2009 Hi, i really appreciate that! Here is my file. Search.php Link to comment Share on other sites More sharing options...
rcking Posted February 13, 2009 Share Posted February 13, 2009 Btw. my shop si www.rcking.eu try search CX450-01-06 or 01-06 or 06 ... Link to comment Share on other sites More sharing options...
VIXUS Posted February 13, 2009 Share Posted February 13, 2009 no :-p coz it depends on your version.Give me your file & I'll give it back to you. Or.. OK I'll post a Search.php file from PS 1.1 version.But by now I'm on...... week end !I'll give it to you on monday morning or tomorrow.... ok let's say tomorrowCiao Great mate, i have some search problems as well, this may help. Link to comment Share on other sites More sharing options...
daYmo Posted February 16, 2009 Share Posted February 16, 2009 Voici pour la v1.1A voir si c'est utile mais je pense inclure les meta tags aussi ...Ciao Search.php Link to comment Share on other sites More sharing options...
rcking Posted February 16, 2009 Share Posted February 16, 2009 VIVAT!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! THANKS A LOT!!!! Link to comment Share on other sites More sharing options...
daYmo Posted February 16, 2009 Share Posted February 16, 2009 does it work ok for you ? see ya Link to comment Share on other sites More sharing options...
rcking Posted February 16, 2009 Share Posted February 16, 2009 YEAH! EXACTLY WHAT I NEED! Thank you again! Link to comment Share on other sites More sharing options...
tegou Posted May 8, 2009 Share Posted May 8, 2009 hi, i have tryed your file search.phpbut there is a problem, the search works bettern, he find more.the problem ist, that he make blank pages at the end of the produkts see the screenshot Link to comment Share on other sites More sharing options...
ukbill69 Posted June 20, 2009 Share Posted June 20, 2009 The search.php files doesnt work, just shows a blank page when you search. This is dead annoying and I sware im loosing business because people cant find what they are looking for. Link to comment Share on other sites More sharing options...
rafy Posted February 4, 2010 Share Posted February 4, 2010 is this problem replacing "-" with "+" a problem in version1.2.5?thanks Link to comment Share on other sites More sharing options...
chrilisa Posted May 18, 2010 Share Posted May 18, 2010 Hi,It is due to your MySQL configuration.The fulltext mode of MySQL automatically skip words less than 4 characters long. For example, if you're looking for "a big bottle of wine", it will only search for "bottle" and "wine", considering that the other words are useless for the search.Of course, you can change this setting in your configuration. how to modify the configuration Link to comment Share on other sites More sharing options...
Recommended Posts