3

Summary The exception log becomes bloated with "main.CRITICAL: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'catalogsearch_fulltext_scope1' doesn't exist". sometimes reindexing cycle is working properly.but sometime it's not generated/rename from catalogsearch_fulltext_scope1_tmp folder. If we check in database, table is not exist but if you try to create, it will show table is already exists. and if we rename 'catalogsearch_fulltext_scope1_tmp' table to 'catalogsearch_fulltext_scope1', it will show table is already exist. If you try to delete it, it will show table is not exist

Environment Magento 2.2.5 and possibly earlier versions PHP 7.0 Custom extensions are installed but are up to date with magento version

Steps to reproduce 1.Check that cron jobs are set up and running 2.Check exceptions log

Expected result On indexing cycle, no errors should occur.

Actual result On indexing cycle, error "main.CRITICAL: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'catalogsearch_fulltext_scope1' doesn't exist" appears.

2

I just fixed same issue on my server. Access to server and run:

("Magento" is my database name)

cd /var/lib/mysql/Magento
rm -rf catalogsearch_fulltext_scope1.ibd
php bin/magento indexer:reindex catalogsearch_fulltext

After that, the table catalogsearch_fulltext_scope1 will be regenerated.

I hope this helps someone else.

| improve this answer | |
  • Wondering if it was really necessary to delete the database file? Seems a bit of a nuclear option, wouldn't the reindex have repopulated catalogsearch_fulltext_scope1 anyway? – Doug McLean Jul 15 at 8:17

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.