0

Every time I re-index the table catalogsearch_fulltext_scope1 gets emptied. Since the table is empty we're unable to search product names or descriptions on the front end. All search results come up with no results.

If we use advanced search SKU and custom Attributes work.

If I add a manual entry into catalogsearch_fulltext_scope1 then it is searchable. As soon as the site is re-indexed it empties the table.

The server did crash (due to host having issues) and it's been happening every since.

No errors running re-index and no errors in any of the logs.

As far as Magento is concerned it thinks it's all working, but something is stopping the catalogsearch_fulltext_scope1 table from filling up with entries.

Which means search on the front end doesn't work at all. It's strange that SKU still works in advanced search.

Products are all showing correctly in their categories both front end and back end. Adding new products and editing existing products are all updating correctly as well - it's just the search.

Has anybody faced this issue before?

Magento 2.2.1, 600 odd products, MariaDB, standard MySQL search

Everything was working fine pre-crash.

  • Additional information request. Post on pastebin.com or here. RAM size of your MySQL Host server A) complete (not edited) my.cnf or my.ini Text results of: B) SHOW GLOBAL STATUS; after minimum 24 hours UPTIME C) SHOW GLOBAL VARIABLES; D) complete MySQLTuner report AND Optional very helpful information, if available includes - htop OR top OR mytop for most active apps, ulimit -a for a linux/unix list of limits, iostat -xm 5 3 when system is busy for an idea of IOPS by device, df -h for a linux/unix free space list by device, for server tuning analysis. – Wilson Hauck Dec 12 '18 at 15:06
  • Do you still have to add a manual entry after re-index? Providing the information requested Dec 12, 18 could be beneficial for you. Let us analyze your MySQL instance data. – Wilson Hauck Jan 26 at 19:49
0

I am having the same problem. I don't know what's causing it. and to make things more interesting, when I downloaded a copy of magento on a local xampp server. After I run the re-index command, the table was generated.

Uploaded the system back on the hosting and then got deleted again.

Then I thought, that there is something wrong with the hosting. I contacted the hosting company, and they assured me that there is nothing wrong.

The problem is that I still cannot work :(

  • That's interesting @robert. Did your host have any server crashes or issues prior to you noticing it wasn't working anymore? Do you get any errors in your logs? – Justin Dec 13 '18 at 5:31
  • @Justin, no I don't have any errors in my log, and when I contacted the hosting provider, he said that on their side there is nothing that it is showing a problem... so I have been left with the problem and cannot find what is causing it – Robert Micallef Dec 17 '18 at 10:55
  • @WilsonHauck No, I did not fix the problem. To solve my problem I have changed the hosting service and now it is working fine :) – Robert Micallef Jan 29 at 14:19
0

Not necessarily a solution, but upgrading to a newer version (in this case 2.2.7) resolved the issue.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.