0

I am getting the following error in my magento store when I try to access one particular product.

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '))' at line 1, query was: SELECT main_table.* FROM catalog_category_flat_store_1 AS main_table WHERE (())

Every other product is working fine in my magento store. When I try to open the product page of one particular product I am getting the above magento error. Can anyone kindly tell me how to sort this out?

Manashvi Birla
8,8739 gold badges29 silver badges53 bronze badges
asked Jul 17, 2017 at 11:27

1 Answer 1

0
  • Enable Magento log from System -> Configuration -> Advanced (Developer) -> Log Settings.
  • Ensure that there is nothing in <Magento_Root>/var/log folder. Reload the product page for which you are getting the error.
  • Now check for the logs in <Magento_Root>/var/log folder.

Hopefully, you would get some clue from here.

answered Jul 17, 2017 at 12:32

Your Answer

Draft saved
Draft discarded

Sign up or log in

Sign up using Google
Sign up using Email and Password

Post as a guest

Required, but never shown

Post as a guest

Required, but never shown

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

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.