500 Internal Server Error: Mismatch between target GID (XXX) and GID (XXX) of file

Today (at the time of writing) I tried to install Magento 1.7.0.0 via SSH as ‘root’ user using following bash script: #!/bin/bash wget http://www.magentocommerce.com/downloads/assets/1.7.0.0/magento-1.7.0.0.tar.gz wget http://www.magentocommerce.com/downloads/assets/1.2.0/magento-sample-data-1.2.0.tar.gz tar -zxvf magento-1.7.0.0.tar.gz tar -zxvf magento-sample-data-1.2.0.tar.gz mv magento-sample-data-1.2.0/media/* magento/media/ mv magento-sample-data-1.2.0/magento_sample_data_for_1.2.0.sql magento/data.sql mv magento/* magento/.htaccess . chmod -R o+w media mysql -u dbUserName -pdbPass dbName < data.sql chmod o+w …

Read more

Getting super attributes info using raw SQL in Magento

Introduction While creating a configurable product, you need to create an attribute(s) which will be used as a select option(s) for the customer(For Example Color, Size, etc.). These kinda attributes are called super attributes or configurable attributes. In this article, we will be discussing how to get different info about super attributes using raw SQL. …

Read more

Magento EAV structure & role of eav_attribute’s backend_type field

Introduction: Magento database is based on EAV(Entity Attribute Value) architecture. And it uses this architecture, especially for categories, products, customers & customer addresses. Before Magento version 1.4.x it used EAV structure for orders as well but thereafter order’s EAV structure has been converted to a flat structure. From the definition of EAV: Entity(E): Entity actually …

Read more

is_file() vs file_exists()

Introduction If you do not know how to use is_file() and file_exists() properly, then you will end up pulling out your hair. Here we will talk about a scenario which will clarify the usage of is_file() vs file_exists(). Case: We are trying to show the gallery images from a table which has the field: ‘imagepath’ …

Read more

Configuring Magento for Development / Debug Mode

Configuring Magento for Development/Debug Mode

Configuring Magento for Development / Debug Mode: 1. Disable Cache System > Cache Management > Select All [check-boxes] > Actions = Disable > Submit 2. Re-Index All System > Index Management > Select All [check-boxes] > Actions = Reindex Data > Submit 3. Disable Compilation System > Tools > Compilation > Disable Note: By default …

Read more