yii2: Big problem with migrate function
Hi,
In your framework, you’ve a very big problem with the migrate command.
When i make a migrate command, i’ve this exception : MacBook-Pro-de-Lionel:~ lionel$ /Users/lionel/Site/yii2-advanced/yii migrate Yii Migration Tool (based on Yii v2.0.0-dev)
exception 'PDOException' with message 'SQLSTATE[HY000] [2002] No such file or directory' in /Users/lionel/Site/yii2-advanced/vendor/yiisoft/yii2/db/Connection.php:355
Stack trace:
#0 /Users/lionel/Site/yii2-advanced/vendor/yiisoft/yii2/db/Connection.php(355): PDO->__construct('mysql:host=loca...', 'root', 'root', NULL)
#1 /Users/lionel/Site/yii2-advanced/vendor/yiisoft/yii2/db/Connection.php(311): yii\db\Connection->createPdoInstance()
#2 /Users/lionel/Site/yii2-advanced/vendor/yiisoft/yii2/db/Connection.php(385): yii\db\Connection->open()
#3 /Users/lionel/Site/yii2-advanced/vendor/yiisoft/yii2/db/mysql/Schema.php(188): yii\db\Connection->createCommand('SHOW FULL COLUM...')
#4 /Users/lionel/Site/yii2-advanced/vendor/yiisoft/yii2/db/mysql/Schema.php(93): yii\db\mysql\Schema->findColumns(Object(yii\db\TableSchema))
#5 /Users/lionel/Site/yii2-advanced/vendor/yiisoft/yii2/db/Schema.php(114): yii\db\mysql\Schema->loadTableSchema('tbl_migration')
#6 /Users/lionel/Site/yii2-advanced/vendor/yiisoft/yii2/console/controllers/MigrateController.php(577): yii\db\Schema->getTableSchema('{{%migration}}', true)
#7 /Users/lionel/Site/yii2-advanced/vendor/yiisoft/yii2/console/controllers/MigrateController.php(617): yii\console\controllers\MigrateController->getMigrationHistory(-1)
#8 /Users/lionel/Site/yii2-advanced/vendor/yiisoft/yii2/console/controllers/MigrateController.php(153): yii\console\controllers\MigrateController->getNewMigrations()
#9 [internal function]: yii\console\controllers\MigrateController->actionUp(0)
#10 /Users/lionel/Site/yii2-advanced/vendor/yiisoft/yii2/base/InlineAction.php(53): call_user_func_array(Array, Array)
#11 /Users/lionel/Site/yii2-advanced/vendor/yiisoft/yii2/base/Controller.php(128): yii\base\InlineAction->runWithParams(Array)
#12 /Users/lionel/Site/yii2-advanced/vendor/yiisoft/yii2/console/Controller.php(82): yii\base\Controller->runAction('', Array)
#13 /Users/lionel/Site/yii2-advanced/vendor/yiisoft/yii2/base/Module.php(586): yii\console\Controller->runAction('', Array)
#14 /Users/lionel/Site/yii2-advanced/vendor/yiisoft/yii2/console/Application.php(131): yii\base\Module->runAction('migrate', Array)
#15 /Users/lionel/Site/yii2-advanced/vendor/yiisoft/yii2/console/Application.php(99): yii\console\Application->runAction('migrate', Array)
#16 /Users/lionel/Site/yii2-advanced/vendor/yiisoft/yii2/base/Application.php(289): yii\console\Application->handleRequest(Object(yii\console\Request))
#17 /Users/lionel/Site/yii2-advanced/yii(30): yii\base\Application->run()
#18 {main}
Next exception 'yii\db\Exception' with message 'SQLSTATE[HY000] [2002] No such file or directory' in /Users/lionel/Site/yii2-advanced/vendor/yiisoft/yii2/db/Connection.php:316
Stack trace:
#0 /Users/lionel/Site/yii2-advanced/vendor/yiisoft/yii2/db/Connection.php(385): yii\db\Connection->open()
#1 /Users/lionel/Site/yii2-advanced/vendor/yiisoft/yii2/db/mysql/Schema.php(188): yii\db\Connection->createCommand('SHOW FULL COLUM...')
#2 /Users/lionel/Site/yii2-advanced/vendor/yiisoft/yii2/db/mysql/Schema.php(93): yii\db\mysql\Schema->findColumns(Object(yii\db\TableSchema))
#3 /Users/lionel/Site/yii2-advanced/vendor/yiisoft/yii2/db/Schema.php(114): yii\db\mysql\Schema->loadTableSchema('tbl_migration')
#4 /Users/lionel/Site/yii2-advanced/vendor/yiisoft/yii2/console/controllers/MigrateController.php(577): yii\db\Schema->getTableSchema('{{%migration}}', true)
#5 /Users/lionel/Site/yii2-advanced/vendor/yiisoft/yii2/console/controllers/MigrateController.php(617): yii\console\controllers\MigrateController->getMigrationHistory(-1)
#6 /Users/lionel/Site/yii2-advanced/vendor/yiisoft/yii2/console/controllers/MigrateController.php(153): yii\console\controllers\MigrateController->getNewMigrations()
#7 [internal function]: yii\console\controllers\MigrateController->actionUp(0)
#8 /Users/lionel/Site/yii2-advanced/vendor/yiisoft/yii2/base/InlineAction.php(53): call_user_func_array(Array, Array)
#9 /Users/lionel/Site/yii2-advanced/vendor/yiisoft/yii2/base/Controller.php(128): yii\base\InlineAction->runWithParams(Array)
#10 /Users/lionel/Site/yii2-advanced/vendor/yiisoft/yii2/console/Controller.php(82): yii\base\Controller->runAction('', Array)
#11 /Users/lionel/Site/yii2-advanced/vendor/yiisoft/yii2/base/Module.php(586): yii\console\Controller->runAction('', Array)
#12 /Users/lionel/Site/yii2-advanced/vendor/yiisoft/yii2/console/Application.php(131): yii\base\Module->runAction('migrate', Array)
#13 /Users/lionel/Site/yii2-advanced/vendor/yiisoft/yii2/console/Application.php(99): yii\console\Application->runAction('migrate', Array)
#14 /Users/lionel/Site/yii2-advanced/vendor/yiisoft/yii2/base/Application.php(289): yii\console\Application->handleRequest(Object(yii\console\Request))
#15 /Users/lionel/Site/yii2-advanced/yii(30): yii\base\Application->run()
#16 {main}
Additional Information:
Please correct this problem to i can test your dev application
Thank you for your quickly answer Lionel
About this issue
- Original URL
- State: closed
- Created 10 years ago
- Comments: 16 (3 by maintainers)
It’s not Yii issue but MySQL configuration. Try “127.0.0.1” instead of “localhost” in DB connection string. In some cases it helps.
extension=php_mysql.dll extension=php_mysqli.dll extension=php_pdo_mysql.dll remove comment from these three line(by removing 😉 in your php configuration file. my problem has been solved by doing this.