Quicktip: Magento 1.7.0.2 shows Database server does not support InnoDB storage engine

During configuration of Magento 1.7.0.2 (in fact whole 1.7.x branch) you may encounter such error:

Database server does not support InnoDB storage engine

Of course your MySQL server has InnoDB enabled so what to do? Answer is simple but ugly, go to app/code/core/Mage/Install/Model/Installer/Db/Mysql4.php and replace:

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

with

public function supportEngine(){
 $variables = $this->_getConnection()->fetchPairs('SHOW ENGINES');
 return(isset($variables['InnoDB'])&& $variables['InnoDB']!='NO');
 }