Category: MySQL

How to Fix Magento Product Flat Data Index Stuck on Processing

Magento Product Flat Data Index Processing

If you’ve ever gone in to re-index your Product Flat Data index, and noticed that the orange Processing… status icon won’t go away, you are not alone! It’s quite a common problem, especially for those that have backed-up and restored

Posted in Magento, Magento Enterprise, Magento Fixes, Magento Professional, MySQL

Magento – Batch / Bulk Edit Tax Class on All Products

If you’ve ever worked (or are working, good luck!) on a Magento product, and have already added in all of your products either by hand or importing, you know how tedious it is to go through each one again and

Posted in Magento, Magento Enterprise, Magento Professional, MySQL

Magento General Error 1005 Can’t Create Table Fix/Workaround

I was working with Magento EE 1.9.1.1, and ran into an issue on the Index Management screen – one of my indexes (Category Flat Data) was stuck in “Processing” mode. Viewing the exception log, I saw that this was being

Posted in Magento, Magento Enterprise, MySQL, PHP