tivicrdotcom Posted April 4, 2013 Share Posted April 4, 2013 (edited) So I have about 400 products and been running my online shop since 2010 but suddenly when you search for something that it's known to be in stock, it simply returns the phrase: Sorry, no results were found. Odd enough if I run a search query in the admin area it does return results, so the problem seems to be at the front end. I am thinking it may be the cache or something related, does any one has a clue? I am running: Prestashop version: 1.4.6.2 Server information: Linux #1 SMP Wed Dec 19 07:05:20 UTC 2012 x86_64 Server software version: Apache PHP version: 5.3.21 MySQL version: 5.0.96-log You can check the site live by visiting http://www.tivicr.com Thanks in advance! Edited April 23, 2013 by tivicrdotcom (see edit history) Link to comment Share on other sites More sharing options...
tomerg3 Posted April 4, 2013 Share Posted April 4, 2013 Did you try to rebuild the search index from the backoffice (Preferences->Search) Link to comment Share on other sites More sharing options...
tivicrdotcom Posted April 8, 2013 Author Share Posted April 8, 2013 Hi Tomer, as always on top of the game, thanks a lot. I indeed tried that: The "indexed" products have been analyzed by PrestaShop and will appear in the results of the front office search. Indexed products: 405 / 405. Even when I click on Re-build entire index, I get an update successful but still end up with the same problem, receiving search results empty, or not finding anything. Could it be a db issue? Link to comment Share on other sites More sharing options...
tomerg3 Posted April 8, 2013 Share Posted April 8, 2013 It could be, try to use phpMyAdmin, select all the tables, and choose "check" from the drop down at the bottom, and see if any have errors. If so, do the same and select "repair" Link to comment Share on other sites More sharing options...
tivicrdotcom Posted April 9, 2013 Author Share Posted April 9, 2013 Tomer, again thanks. I ran the check option and returned all tables with an OK so maybe is not a db issue. Weird enough it just happen out of the blue since I haven't worked hardcore my site lately. Any other thing that comes to mind? Again, thanks! Link to comment Share on other sites More sharing options...
tomerg3 Posted April 9, 2013 Share Posted April 9, 2013 Do you get results using the search in the backoffice? Link to comment Share on other sites More sharing options...
tivicrdotcom Posted April 10, 2013 Author Share Posted April 10, 2013 Good question Tomer, and I do get results from within the backoffice so the problem is only at the front office level, weird isn't it? Link to comment Share on other sites More sharing options...
Lapuntu Posted April 12, 2013 Share Posted April 12, 2013 (edited) Weird or not, i got the same problem in my Prestashop... almost the same version than yours and the same problem mechanic... DB is Ok, BackOffice Works Ok but FrontOffice dont show any result : / Edit: Btw i got solved mine... maybe i can help you if you can answer with a Yes, to this question: What is your prestashop table prefix? "ps_"? or anotherone? Edited April 12, 2013 by Lapuntu (see edit history) Link to comment Share on other sites More sharing options...
tivicrdotcom Posted April 20, 2013 Author Share Posted April 20, 2013 Thanks Lapuntu. My db tables prefix are indeed "ps_". How did you solved it? I don't even know why the problem arised because I haven't worked anything internally (code) lately. Anyhow, I appreciate your help. Link to comment Share on other sites More sharing options...
tivicrdotcom Posted April 21, 2013 Author Share Posted April 21, 2013 Tomer so I have a few sites under my domain tivicr, being floreticas.com one of then which also presents the same issue: No results found when searching so the problem is at domain level, any clues? Link to comment Share on other sites More sharing options...
tomerg3 Posted April 21, 2013 Share Posted April 21, 2013 Nope, nothing comes to mind. May need to add some debug code, and see where exactly the query breaks or why it returns no results. Link to comment Share on other sites More sharing options...
tivicrdotcom Posted April 23, 2013 Author Share Posted April 23, 2013 It sounds complex Link to comment Share on other sites More sharing options...
tivicrdotcom Posted April 23, 2013 Author Share Posted April 23, 2013 Ok so I found a solution. classes/search.php Replace line 56 with: x{a806}\x{a80b}\x{a823}-\x{a82b}\x{e000}-\x{f8ff}\x{fb1e}\x{fb29}\x{fd3e} Rebuild index and voilá, it works! Thanks Tomer and Lapuntu for participating along the way. Pura Vida, AJ Link to comment Share on other sites More sharing options...
therefinerz Posted March 21, 2016 Share Posted March 21, 2016 Ok so I found a solution. classes/search.php Replace line 56 with: x{a806}\x{a80b}\x{a823}-\x{a82b}\x{e000}-\x{f8ff}\x{fb1e}\x{fb29}\x{fd3e} Rebuild index and voilá, it works! Thanks Tomer and Lapuntu for participating along the way. Pura Vida, AJ Doesnt work Link to comment Share on other sites More sharing options...
Recommended Posts