I have migrated from Magento1.9 to Magento2.3.3.

When running the reindexer command I got the following error: index catalogsearch_fulltext_scope1: does not support DELETE (enabled=0) [ DELETE FROM catalogsearch_fulltext_scope1 WHERE id > 0], all other indexes run just fine.

Error logs don’t appear to be throwing any errors related to this issue.

UPDATE Thought the issue was related to DB Triggers having the wrong user, but all triggers are owned by the same user


I found a fix. The change logs table for search was massive. Once I got that truncated the site was able to run the reindex with no more errors

| improve this answer | |

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.