I had a weird problem few days back , where I had magento installed at my root and one subfolder as well. Now, when I was trying to access the Magento admin of the subfolder, then I was automatically getting redirected the main root site. So, here is how to fix this, 1. Cleared the var/cache folder. 2. Cleared the var/session folder. 3. Open this file, app/code/core/Mage/Core/Model/Session/Abstract/Varien.php And find those lines, [php]if (isset($cookieParams['domain'])) { $cookieParams['domain'] = $cookie->getDomain(); }[/php] It should not be commented out code. ...

Normally, when we sit developing the Magento themes, I hear this question from my guys, "What is the php code to get the Product SKU display?". So, I thought of posting the solution here. So, here it is, [php] <?php $_product = $this->getProduct(); echo $_product->getSku(); ?> [/php]...

Today when I was trying to import a database to a new server, then I started getting such errors, ERROR 1064 (42000) at line 382: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'USING BTREE, So, here is how I fixed it : 1 . Opened the SQL file and searches for this line , [php]UNIQUE KEY `IDX_BASE` (`entity_type_id`,`entity_id`,`attribute_id`,`store_id`) USING BTREE,[/php] Then just replaced it with, [php]UNIQUE KEY `IDX_BASE` USING BTREE (`entity_type_id`,`entity_id`,`attribute_id`,`store_id`),[/php]...

While running the Index Management at Magento backend, you may get an error like this, Cannot initialize the indexer process So, here are the possible solutions, 1. Make sure, the var/locks folder is writable. 2. Delete all the .locks file from the var/locks folder. 3. Run this SQL Query on your phpmyadmin, DELETE FROM catalog_category_product_index; 4. Try Magento Cleanup Tool to reset all the File Permissions. 5. Get a better Magento Optimized Web Hosting and move your whole site files folders and database to that....

Today, when I was trying to setup a Magento store for a customer , I saw the products were not coming up on the frontend. So, I went to SYSTEM > INDEX MANAGEMENT , to reindex all the data.. But when I did that, it dint go through and said, "There was a problem with reindexing process" So, here is what I did to fix the problem, 1. Did a File Permissions Reset using this . Another solution is using Magento Clean Up Tool. 2. Went to var/cache folder on Magento root and cleaned the whole cache folder. Also made sure that cache folder is writable. If still things doesnt work for you, then the final solution is getting a magento optimized hosting and t...

If you have recently moved your site to a new server or getting any such error, Undefined index:  0 in app/code/core/Mage/Core/Model/Mysql4/Config.php on line 92 Then its dude to the wrong things which happened in your database. In order to fix, goto phpmyadmin and check those 3 tables, core_store core_store_group core_website You can see that the store_id for ADMIN is set to 2 on those 2 tables. While the correct  store_id on all those 3 tables should 0 for the ADMIN and 1 for the DEFAULT SITE. So, just edit that and thats it. You are done....

If you are using Magento 1.4.1 or just upgraded any of your old Magento sites to the latest Magento version, then you may be getting a very weird error on your checkout page, that the checkout CONTINUE button on payment screen, either on Authorize.net or PayPal , just doesnt work. The cause of this error is, Magento Team has introduced a new javascript file, which validates the credit card numbers, etc on the payment screen. So, if you are using the default theme, then you should not get this problem. But if you are using any custom theme, then you have to do some changes on your files. Few symptoms of this problem is, you will see such errors, Please ...

Before importing database dump to new database make sure to run these statements first: [php] SET SQL_MODE=''; SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0; SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO'; [/php] After import run this to restore original modes: [php]SET SQL_MODE=IFNULL(@OLD_SQL_MODE,''); SET FOREIGN_KEY_CHECKS=IFNULL(@OLD_FOREIGN_KEY_CHECKS,0); [/php]...