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?

1 Answer 1

  • 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.

Your Answer

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

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