Yii Framework Forum: CDbException - Yii Framework Forum

Jump to content

Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

CDbException CDbConnection failed to open the DB connection.

#1 User is offline   Sachy 

  • Standard Member
  • PipPip
  • Yii
  • Group: Members
  • Posts: 181
  • Joined: 01-December 13

Posted 04 June 2017 - 10:35 AM

So recently I upgraded to XAMPP for OS X 5.6.30
PHP Version 5.6.30


this version doesnot seem to support InnoDB.
Attached File  Screen Shot 2017-06-04 at 5.29.47 PM.png (95.43K)
Number of downloads: 5

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!!
0

Share this topic:


Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

1 User(s) are reading this topic
0 members, 1 guests, 0 anonymous users