Issues with re-indexing process on magento store

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

Solutions

Execute the below-mentioned command from Magento root folder

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

Similar questions

Magento - Website/Store level indexing
We are working on Magento 1.7.0.2 (community). We have created multiple websites. Our query is, is there way to indexing on selected website or store? like website or store level configuration. Consider the the scenario, we have 3 website (WEBSITE1, WEBSITE2, WEBSITE3) and 3 store (STORE1, STORE1, STORE1) 1. If we update WEBSITE1 and STORE1 then in...
Magento 1.9.3.1 Innoext Advanced Store Pricing (Version: 1.2.1.0) Module Product Price indexing issue Unknown column 'cwd.date' in 'field list'
When I tried to Integrate Innoext_AdvancedStorePricing Module in Magento 1.9.3.1 and tried to reindex the Product Prices, it failed with an error message: Column not found: 1054 Unknown column 'cwd.date' in 'field list', query was: INSERT INTO catalog_product_index_price_final_idx SELECT e.entity_id, cg.customer_group_id, cw.website_id, IF(IFNULL(t...
Reindexing - Will my store load slower immediately after re-indexing has been completed?
I understand that during re-indexing my store may be slower, and also that after the flushing the cache, pages will load slower because they are un-cached, however I don't understand indexing well enough. Immediately after re-indexing is complete, would you expect pages to load any slower than immediately before commencing re-index (all other thing...
Request Path for Specified Store already exists during Indexing
In magento 1.9, whenever I save any configurable product in admin panel, all the product urls goes to 404 unless I do reindexing. In reindexing there are 8 processes, 7 of which works fine but the 8th one Vendor Product Url Rewrite get stuck with Reindexing Required And the error I get is Request Path for Specified Store already exists during Index...
Getting the product info from different store in checkout process
I have two stores. View one is in English and the other is the translation, each product has the same price and information but the difference is the translation. I want all orders in the back-end with the same items information taking in to account the fact the site/view that the item was ordered from. For example suppose I have the item with a na...
Do you need to create an integration to drive store process or can it be done via rest API?
We are working on integrating our ERP system with a Magento store. To this point, we have been developing a REST API connection to the store which is working fine. The goal is to be able to take orders from the Magento store, create them in the ERP system, and then update the store as the order is processed by our normal business processes. Is it p...

Also ask

We use cookies to deliver the best possible experience on our website. By continuing to use this site, accepting or closing this box, you consent to our use of cookies. To learn more, visit our privacy policy.