phll

Hello Prestashop people. This is my first post here, I hope I will be clear enough. Some products are not showing in the search result even if they use the same words in the product description. My shop is a vinyl record store. My catalog (more than 7000 products) is updated every morning via CRON My daily cron task: all the products are set at quantity = 0 via sql query in the database all the quantity = 0 are disabled via sql query in the database all the image are erased from the server (/p/*) the catalog is updated from a csv file via the module "Prestashop Importer - import product from csv, xls, xlsx v1.0.35" the image folder is checked and cleaned via the module "elegant image cleaner". the search index is updated completely then I have eBay synchro crons Everything's work smoothly, except that I have recently found a problem with the search result. For exemple, the research of "replica" show up only 4 results, and should at least show up 18 records. e.g. this album https://www.la-face-cachee.com/disques-vinyles-lp-records/rock/(id230460014)_atoll-l-araignee-mal-vinyl containing the word "replica" show up in the result when this one: https://www.la-face-cachee.com/disques-vinyles-lp-records/rock/(id340702941)_atoll-musiciens-magiciens-vinyl or this one https://www.la-face-cachee.com/disques-vinyles-lp-records/rock/(id356270959)_pazop-pazop-vinyl doesn't appear. They have the same description "Replica Records (4)". Of course I tried to re-build the indexation, I tried also to empty the table xx_search_index and xx_search_word, and re-index after, but I have the same bad result every times. I also tried to switch off the languages (only FR is activated now, EN is still there but deactivated), and tried to re-build the index after switching off the search option (Search within word, etc). BUT, when I open and save a missing product, it then appears on the search result. I have really no idea what to do, where to search. Does someone have an idea? Server info: PrestaShop version: 1.6.1.7 Server software version: Apache PHP version: 7.0.19 Memory limit: 1024M Max execution time: 25200 MySQL version: 5.6.35 MySQL engine: InnoDB MySQL driver: DbPDO website url: https://www.la-face-cachee.com Note : I have a mirror of the website for professionals only, all the system is the same, theme, server etc, only the catalog is different (760 products manually added) and the search result work as expected (showing all the "replica" products). Note2 : I've found a weird "word" on the ​xx_search_word : "replicarpccd012", that seems to be a mix of the name "replica" and the "rpccd012" of this product: https://www.la-face-cachee.com/cd/rock/(id355917635)_etron-fou-leloublan-live-at-the-rock-in-opposition-festival-1978-new-london-theatre-cd The fun part is that this product appears also with the "replica" query, as expected with the "Search within word" enabled. Thank you for reading! Phil

Hi ilovekutchi.com, yeah indeed it seems less secure. But after almost 2 years, I have noticed absolutely no problem with this trick. Actually I'm wondering if the Apache Mod_Security module is really disabled on the server, or if it's just the prestashop Mod_Security "interface" who had a bug.. BTW, are you using the last 1.6 version?

Salut, Je me pose les même questions 2 ans après. Pourrais-tu please me faire un retour d'expérience ? As-tu rencontré des problèmes particuliers avec la langue chinoise ? As-tu trouvé une solution intramuros(de Chine pour le serveur ? Merci d'avance ! Phil

I'm happy it helped you !

Hi there ! Tip for the community ! I had the same issue as you. All the website (front and back) was good, except the admin product page. 30-40s to wait only for saving or adding a product. I tried everything (SQL side, disabling modules, caches.....) for hours ! And then, I found the button "disable Apache mod_security module" (prefs/ SEO&URLs). I disabled it and HOURA ! I don't understand why and what it is exactly but know it's speed ! (2-3 sec). I'm so happy I wanted to share ;-) Cheers !

Thanks ! You replied quickly ! Looks perfect. Have a nice day ! Funny shop by the way

Hi there, Hi And63, Thanks for your works ! I tried to use your attached files on my prestashop v1.5.4.1 with quick search block v1.2 and the search doesn't work anymore. Could you explain me what did you change exactly ? I'll try to "patch" my own files. BTW, does anyone run it on 1.5.4.1 ? Thanks again, Phil.