CDbException

So recently I upgraded to XAMPP for OS X 5.6.30


PHP Version 5.6.30

this version doesnot seem to support InnoDB.

7399

Screen Shot 2017-06-04 at 5.29.47 PM.png

Infact I really didn’t care about it unless php mysql didnt start up . :angry:

So I changed the following in my.cnf file


skip-innodb

default-storage-engine=MyISAM

now when I try to run localhost/appname

I got the error :-[


CDbCommand failed to execute the SQL statement: SQLSTATE[42000]: Syntax error or access violation: 1286 Unknown storage engine 'InnoDB'

my database configuration remains unchanged as below




'db'=>array(

			'connectionString' => 'mysql:host=localhost;dbname=boatdb',

			'emulatePrepare' => true,

			'username' => 'root',

			'password' => '123',

			'charset' => 'utf8',

			),



please help!!