DARKF3D3 Posted August 13, 2013 Share Posted August 13, 2013 (edited) I don't know what happen, i haven't modified any file, after i migrated my website to a new server the search stop working. All I write in the search form doesn't get result also for the ajax search that doesn't appear. I also update the search indexes but it doesn't works anymore. Someone could help me? Prestashop is 1.4.9 ============================ FIX ============================ in file /classes/search.php replace "d800" with "e800". =========================================================== Edited August 14, 2013 by DARKF3D3 (see edit history) Link to comment Share on other sites More sharing options...
vekia Posted August 13, 2013 Share Posted August 13, 2013 is there any chance to test your website? if so, please share the url, i will check it with pleasure Link to comment Share on other sites More sharing options...
DARKF3D3 Posted August 13, 2013 Author Share Posted August 13, 2013 Oh yes, it's the website in signature Link to comment Share on other sites More sharing options...
vekia Posted August 13, 2013 Share Posted August 13, 2013 i just thought that the problem is only with ajax query, but ufortunately not. There is something wrong. have you tried to rebuild the search index? (preferences > search) Link to comment Share on other sites More sharing options...
swsindonesia Posted August 13, 2013 Share Posted August 13, 2013 Hi, Have you try to run Indexation again? Preferences -> Search Does it show that all products has been indexed ? Link to comment Share on other sites More sharing options...
DARKF3D3 Posted August 13, 2013 Author Share Posted August 13, 2013 Yes I try a lot of time to reindex the product, and it show 397 product indexed, so they're all indexed but i try a lot of word but i never get result Link to comment Share on other sites More sharing options...
swsindonesia Posted August 13, 2013 Share Posted August 13, 2013 Have you properly setup the weight for your search preferences? You might wanna try to truncate these tables: ps_search_index, ps_search_keyword (make BACKUP first!), then rebuild the index. There's a chance something went wrong with the index during your migration. Link to comment Share on other sites More sharing options...
DARKF3D3 Posted August 13, 2013 Author Share Posted August 13, 2013 From top to the bottom the weight are: 6, 10, 1, 1, 3, 3, 4, 2, 2. There's not something to do that from backoffice, like a tool that repair DB? I don't like to put hands on my DB, I'm not so confident with it. Link to comment Share on other sites More sharing options...
swsindonesia Posted August 14, 2013 Share Posted August 14, 2013 The back-office and indexation look fine, you may wanna touch the database a little bit. A repair to those tables is pretty much easy to do, although I'm not really sure that would help. My suggestion was to truncate / clear up / delete all record from ps_search_index and ps_search_keyword tables (Make proper backup first), then redo the indexation, that should give your shop a fresh start of index. Link to comment Share on other sites More sharing options...
DARKF3D3 Posted August 14, 2013 Author Share Posted August 14, 2013 I look with phpmyadmin and the tables "ps_search_index" and "ps_search_word" are empty, I don't understand why... Link to comment Share on other sites More sharing options...
DARKF3D3 Posted August 14, 2013 Author Share Posted August 14, 2013 Fortunatelly i solved thanks to this topic: http://www.prestashop.com/forums/topic/163074-search-broken-both-ajax-and-normal-search/ The fix is very easy, in file /classes/search.php replace "d800" with "e800". I don't know why and how it changed during migration, but now it works! Link to comment Share on other sites More sharing options...
Dave Angel Posted February 25, 2015 Share Posted February 25, 2015 Even did the job on PS1.3.6 Good Job. Link to comment Share on other sites More sharing options...
Recommended Posts