I just upgraded a Magento shop and I had problem on ‘Shipping Methods‘ sections of onepage checkout. No shipping methods were displayed and I was getting the following message over there: Sorry, no quotes are available for this order at this time magento I had enabled ‘Table Rates‘ shipping method. Solution: – Login to your … Read more
Here are solution to some errors that I faced while upgrade Magento. Error 1: Parse error: syntax error, unexpected T_OBJECT_OPERATOR in downloader/pearlib/php/System.php on line 400 Solution: Edit file named ‘pear‘. This file is present on root folder of your Magento installation. Add the following lines at the beginning of file: MAGE_PEAR_PHP_BIN=/usr/local/bin/php5; export MAGE_PEAR_PHP_BIN Error 2: … Read more
Suppose, you have ID of some products and you want to load them at once in Magento, then here is a solution:- Suppose, you have 5 products ID: 5, 22, 45, 75, 88 You can store them in one array: $productIds = array(5, 22, 45, 75, 88); Then, you can use MySQL’s IN() clause for … Read more
Here is a step-by-step guide on moving Magento site from one server to another. This can be from localhost to server or from server to localhost or from one server to another. Step 1: Enable maintenance mode This is to be done so that no users could place any order while you are backing up … 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
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