SMPlayer is a free and open source media player for Windows and Linux. It is a graphical user interface (GUI) for the award-winning MPlayer. SMPlayer is a very good alternative to VLC media player. It is faster than VLC and can play almost all video and audio formats. You don’t need to download and install … Read more
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 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
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
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
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
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 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
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