Magento Installation Issue on xampp

 

Reason for Installation Issue on xampp server: You might have latest version of PHP available through xampp server and you are trying to install older version of Magento. On which some of the PHP files support older way to get the things. For example xml tag closing etc.. but you might have some compulsion to use that combination. So you must have solution of such issues.

Below we are targeting some common problems of magento installation issues.

Issue 1: PHP Extensions “0” must be loaded.

Resolution: Open app/code/core/Mage/Install/etc/config.xml and search for “pdo_mysql” and instead of <pdo_mysql/> update it with <pdo_mysql>1</pdo_mysql>

Issue 2: Database server does not support the InnoDB storage engine.

Resolution : open file “app/code/core/Mage/Install/Model/Installer/Db/Mysql4.php” and search for “SHOW VARIABLES” . You will find it under supportEngine function. In this function change “SHOW VARIABLES” to “SHOW ENGINES”. And instead of “have_innodb” change “InnoDB”So instead of function . And “YES” should be changed with “NO”


public function supportEngine()
 {       
   $variables = $this->_getConnection()->fetchPairs('SHOW VARIABLES');
   return (!isset($variables['have_innodb']) || $variables['have_innodb'] != 'YES') ? false : true;
 }

 

The function would be


public function supportEngine()

{

$variables = $this->_getConnection()->fetchPairs('SHOW ENGINES');
return (!isset($variables['have_innodb']) || $variables['have_innodb'] != 'YES') ? false : true;

}

Related posts:

The following two tabs change content below.

Chandra Shekhar

Consultant at Infogain
Chandra Shekhar is a LAMP Developer,Thinker,Blogger and currently working as Magento(Ecommerce) specialist.. I am always open to learn new things in LAMP as well as other newer technology. In the journey of my last 9 years of web and product development, I have decided to share my knowledge and experience to Open Source Community in 2011. In this regard I have started CuteHits.com. Since then I am actively sharing my knowledge on various LAMP technology through CuteHits.com’s technical ... Read More about Chandra Shekhar

Latest posts by Chandra Shekhar (see all)