Yiic Mysql Isn't Working

[haosmark]

I’m trying to learn Yii and currently am reading a book on it. My problem is that I can’t seem to connect to mysql via yiic (it’s working fine via browser).

The following is the error log:

2013/01/28 23:57:23 [error] [exception.CDbException] exception ‘CDbException’ with message ‘CDbConnection failed to open the DB connection: could not find driver’ in C:\xampp\htdocs\yii\framework\db\CDbConnection.php:381

Stack trace:

#0 C:\xampp\htdocs\yii\framework\db\CDbConnection.php(330): CDbConnection->open()

#1 C:\xampp\htdocs\yii\framework\db\CDbConnection.php(308): CDbConnection->setActive(true)

#2 C:\xampp\htdocs\yii\framework\base\CModule.php(387): CDbConnection->init()

#3 C:\xampp\htdocs\yii\framework\cli\commands\MigrateCommand.php(442): CModule->getComponent(‘db’)

#4 C:\xampp\htdocs\yii\framework\cli\commands\MigrateCommand.php(451): MigrateCommand->getDbConnection()

#5 C:\xampp\htdocs\yii\framework\cli\commands\MigrateCommand.php(482): MigrateCommand->getMigrationHistory(-1)

#6 C:\xampp\htdocs\yii\framework\cli\commands\MigrateCommand.php(84): MigrateCommand->getNewMigrations()

#7 [internal function]: MigrateCommand->actionUp(Array)

#8 C:\xampp\htdocs\yii\framework\console\CConsoleCommand.php(172): ReflectionMethod->invokeArgs(Object(MigrateCommand), Array)

#9 C:\xampp\htdocs\yii\framework\console\CConsoleCommandRunner.php(67): CConsoleCommand->run(Array)

#10 C:\xampp\htdocs\yii\framework\console\CConsoleApplication.php(91): CConsoleCommandRunner->run(Array)

#11 C:\xampp\htdocs\yii\framework\base\CApplication.php(169): CConsoleApplication->processRequest()

#12 C:\xampp\htdocs\yii\framework\yiic.php(33): CApplication->run()

#13 C:\xampp\htdocs\trackstar\protected\yiic.php(7): require_once(‘C:\xampp\htdocs…’)

#14 {main}

---

my mysql configuration in console.php is the same as in main.php

'db'=>array(

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

                        'emulatePrepare' => true,

                        'username' => 'root',

                        'password' => '',

                        'charset' => 'utf8',

                ),

For whatever reason it doesn’t want to work. Does anyone know how to fix this?

P.S. I posted this same question in “Web Application Development With Yii And PHP” but no one replied. I’m only double posting in hopes that more people are reading this section and the problem will go away sooner.

Thanks for the help in advance.

[outrage (Site Sense Web)]

I notice you have framework in a different folder.

In your application you may need to change the path in protected/yiic.php or use yiic from the framework folder.

Here’s what it looks like.

// change the following paths if necessary

$yiic=dirname(__FILE__).'/../framework/yiic.php';

$config=dirname(__FILE__).'/config/console.php';


require_once($yiic);

[haosmark]

I notice you have framework in a different folder.

In your application you may need to change the path in protected/yiic.php or use yiic from the framework folder.

Here’s what it looks like.

// change the following paths if necessary

$yiic=dirname(__FILE__).'/../framework/yiic.php';

$config=dirname(__FILE__).'/config/console.php';


require_once($yiic);

Sadly that didn’t help. It points to correct location.

This is the content of yiic.php:

<?php


// change the following paths if necessary

$yiic=dirname(__FILE__).'/../../yii/framework/yiic.php';

$config=dirname(__FILE__).'/config/console.php';


require_once($yiic);

Edit: I guess yiic was reading different php install on my system. I removed system path to my old php installation and it works now.