1

Indexing console enter image description here

Everything else is working perfectly. i also disabled the elasticsearch and checked but error still there. Error is with Query, at last word "AND (())", when i remove this and run directly on Mysql, it works. Where this Query is written so i could fix it.

Thanks

Improve this question

2 Answers 2

Reset to default
1

The query error is related to the custom index "Product Attribute Index", so you should find which module declares this custom index by running this command in your root directory: grep -r "Product Attribute Index" app vendor.

Assume you found it declares in app/code/Asif/ProductAttributeIndexer module, run this command from your root directory: grep -r "</indexer>" app/code/Asif/ProductAttributeIndexer to find the indexer.xml file.

Once you get the indexer.xml, open that file to find Indexer class. Once you found the Indexer class, check the code in the Indexer class. I think that file is the answer to your question:

Where this Query is written so i could fix it.

Improve this answer
2
  • Exactly to the point Answer. really appreciated.
    – Asif hhh
    Commented Oct 29, 2022 at 12:53
  • Glad to hear that. Cheers!
    – Tu Van
    Commented Oct 29, 2022 at 12:53
0

The simple fix i would choose will be that

  • Export your DB in self-contained file
  • open the file in a text editor or any IDE
  • Find this query and fix it
  • Then import this Database again and sync it with your project.
Improve this answer
1
  • Ok i try this out.
    – Asif hhh
    Commented Oct 29, 2022 at 12:21

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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