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;

}

The following two tabs change content below.

• Bio
• Latest Posts

Chandra Shekhar

GCP Architect

Chandra Shekhar Pandey is Google certified Cloud engineer, I am Magento2 Trained developer. Having huge experience in designing cloud solution. I have around 12 years of experience with world enterprise IT companies and fortune 500 clients. During my architecture design I am always caring about high availability, fast performance and resilient system. From the programmer background I have huge experience in LAMP stack as well. Throughout my carrier I have worked on Retail, E-Learning, Video Conferencing and social media domain. The motive of creating cutehits was just to share the knowledge/solutions I get to know during my day to day life so that if possible I can help someone for same problems/solutions. CuteHits.com is a really a very effort for sharing knowledge to rest of the world. For any query/suggestion about same you can contact me on below details:- Email: shekharmca2005 at gmail.com Phone: +91-9560201363

Latest posts by Chandra Shekhar (see all)

• Best practices for micro service design - January 23, 2022
• Spring Boot - January 23, 2022
• Java - January 23, 2022