Mukesh Chapagain Blog

Magento: Admin login error after website transfer

December 26, 2014June 4, 2013 by Mukesh Chapagain

I recently transferred a Magento website from one webhost to another. Frontend part is working fine. I am able to view products and cms pages. I am also able to view the admin login page. However, when try logging to admin, I get error page showing the following SQL query: SELECT `e`.*, SUM((e.base_subtotal-IFNULL(e.base_subtotal_refunded,0)-IFNULL(e.base_subtotal_canceled,0)-IFNULL(e.base_discount_amount,0)+IFNULL(e.base_discount_refunded,0))*e.base_to_global_rate) AS `revenue`, … Read more

Magento: Send confirmation email on new customer registration

May 20, 2013 by Mukesh Chapagain

Magento has the feature to verify the authenticity of newly registered customers before activating their account. When a user registers to your Magento shop, then he/she will get a confirmation email with a confirmation link. The customer’s account will be activated only after he/she clicks that confirmation link. By default this feature is not activated … Read more

[SOLVED] Login screen goes black after upgrade to Ubuntu 13.04

May 13, 2013 by Mukesh Chapagain

I recently upgraded from Ubuntu 12.10 to Ubuntu 13.04. It went successfully. After I restarted my computer, I get a black screen at the time of login. Hence, I am unable to insert my login to my computer. However, I was able to login in recovery mode. I googled for solutions. Used the keywords like … Read more

Magento: You cannot define a correlation name ‘attribute_idx’ more than once [SOLVED]

December 26, 2014May 6, 2013 by Mukesh Chapagain

Problem: I am having the following error when I browse Layered Navigation on Magento. You cannot define a correlation name ‘attribute_idx’ more than once Cause: This is because a block has been duplicated. You have to check your layout xml files to check if you have included same block at same place twice. Solution: To … Read more

[SOLVED] Warning: Your Magento folder does not have sufficient write permissions

April 22, 2013 by Mukesh Chapagain

You might get this error when you go to Magento Connect Manager (System -> Magento Connect -> Magento Connect Manager) of your Magento installation. This means that Magento Connect is unable to write files to your server. Warning: Your Magento folder does not have sufficient write permissions. The solution to this problem is to set … Read more

Magento: Unable to select custom attribute on product collection

December 26, 2014April 15, 2013 by Mukesh Chapagain

Problem: I had added a new product attribute. Suppose the attribute code is ‘test’. I have been trying to fetch/select that newly added product attribute. Here is my Magento collection code:- $collection = Mage::getModel('catalog/product') ->getCollection() ->addAttributeToSelect('test') ->addAttributeToFilter('url_key', 'SOME_URL_KEY') ->getFirstItem(); I don’t see the attribute ‘test’ when I print the collection data. echo "<pre>"; print_r($collection->getData()); echo … Read more

Vi commands: Simple and Quick tutorial [Linux]

April 8, 2013 by Mukesh Chapagain

VI is a display oriented interactive text editor originally created for the Unix operating system. It is available by default on all UNIX systems. It is supplied with all Linux distributions. Here is a simple and quick VI command tutorial. Note: VI commands are CASE SENSITIVE. Modes There are two modes in vi: command mode … Read more

Magento: Add/Edit Date Field in Admin Form

December 26, 2014April 2, 2013 by Mukesh Chapagain

Let’s suppose that you have a custom Magento module named ‘YourModule’. You have a custom database table for the module. There is a date field in the table. Now, your requirement is that your module should be able to display and edit the date field from admin section. This article shows how you can display … Read more

Magento: Add new tab to Customer Account Section

August 16, 2015March 25, 2013 by Mukesh Chapagain

Suppose, you have a custom Magento module and you wanted to add a custom tab to “Customer My Account” section, i.e. the frontend part displayed after customer login. Here is the solution:- Let’s suppose, your module’s name is Yourmodule. 1) Add these xml code in app/design/frontend/your_package/your_theme/layout/yourmodule.xml Note:- In default Magento settings, your_package = default & … Read more