I have just re-index the data using custom script and its generate this error :

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 '= 'abs', ( - i.price), IF( = 'fixed', , ROUND(i.price * ( / 100), 4)))), 0) AS `' at line 1

I have tried by making the catalog_product_flat_1 table but still the same issue

  • What is the custom script and why are you using it? Does Magento's native reindexer give the same problem?
    – BlueC
    Apr 21, 2016 at 20:39
  • Yeah that is also giving the same problem.. @BlueC
    – Xabby
    Apr 23, 2016 at 15:52

1 Answer 1


Execute the below-mentioned command from Magento root folder

cd shell/
php -f indexer.php -- reindex all

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.