Month: August 2011

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

MSSQL 2008 R2 Cannot Restore Backup “Being used by another database”

When using SQL Server Management Studio to restore a backed-up database that you’ve created from a database already being used in your current instance of SQL/SQLExpress, you may receive an error similar to the following:

Posted in SQL Server, SQL Server Management Studio

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