CDbConnection.connectionString cannot be empty.

anoble · December 13, 2011, 6:14pm

I have been trying to get yii for a week now, with no joy. After stumbling through the perils of yiic and finally getting a test site up and running, I thought I might have success. Wrong! Now its a database connection issue. I have read through all the posts in this regard but cannot find a solution. Here is the code I have in my main.php ( the username and password have been changed to protect the innocent.)

‘db’=>array(

    'connectionString' =&gt; 'mysql:host=localhost;dbname=tracker',


    'emulatePrepare' =&gt; true,


    'username' =&gt; 'myuser',


    'password' =&gt; 'mypass',


    'charset' =&gt; 'utf8',


    ),

I am so frustrated that I am almost considering cakePHP because I at least can get a db running. help…

Thanks,

Adrian

jacmoe · December 13, 2011, 7:24pm

That code in main.php - is it in the ‘components’ array?

Are you testing using a browser or on the command line?

Does the database ‘tracker’ exist on your local mysql server?

anoble · December 13, 2011, 8:48pm

Yes, it is in the components array and I can connect to the database via the command line.