MagePsycho - PHP5 / Magento Certified Full Stack Developer

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

May 19, 2019April 29, 2012 by Raj KB

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 …

Share8

8 Shares

Getting super attributes info using raw SQL in Magento

May 21, 2019April 22, 2012 by Raj KB

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. …

Share17

17 Shares

Magento EAV structure & role of eav_attribute’s backend_type field

May 19, 2019April 8, 2012 by Raj KB

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 …

Share16

16 Shares

is_file() vs file_exists()

June 22, 2019March 19, 2012 by Raj KB

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’ …

Share8

8 Shares

Configuring Magento for Development / Debug Mode

March 8, 2020March 10, 2012 by Raj KB

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 …

Share24

24 Shares