2017-05-06 21:05:46 [-][-][-][error][yii\db\Exception] PDOException: SQLSTATE[HY000] [1049] Unknown database 'yii2advanced' in E:\xampp\htdocs\yii2-advanced-api\vendor\yiisoft\yii2\db\Connection.php:630 Stack trace: #0 E:\xampp\htdocs\yii2-advanced-api\vendor\yiisoft\yii2\db\Connection.php(630): PDO->__construct('mysql:host=loca...', 'root', 'root', NULL) #1 E:\xampp\htdocs\yii2-advanced-api\vendor\yiisoft\yii2\db\Connection.php(563): yii\db\Connection->createPdoInstance() #2 E:\xampp\htdocs\yii2-advanced-api\vendor\yiisoft\yii2\db\Connection.php(912): yii\db\Connection->open() #3 E:\xampp\htdocs\yii2-advanced-api\vendor\yiisoft\yii2\db\Connection.php(899): yii\db\Connection->getMasterPdo() #4 E:\xampp\htdocs\yii2-advanced-api\vendor\yiisoft\yii2\db\Command.php(219): yii\db\Connection->getSlavePdo() #5 E:\xampp\htdocs\yii2-advanced-api\vendor\yiisoft\yii2\db\Command.php(896): yii\db\Command->prepare(true) #6 E:\xampp\htdocs\yii2-advanced-api\vendor\yiisoft\yii2\db\Command.php(362): yii\db\Command->queryInternal('fetchAll', NULL) #7 E:\xampp\htdocs\yii2-advanced-api\vendor\yiisoft\yii2\db\mysql\Schema.php(199): yii\db\Command->queryAll() #8 E:\xampp\htdocs\yii2-advanced-api\vendor\yiisoft\yii2\db\mysql\Schema.php(98): yii\db\mysql\Schema->findColumns(Object(yii\db\TableSchema)) #9 E:\xampp\htdocs\yii2-advanced-api\vendor\yiisoft\yii2\db\Schema.php(152): yii\db\mysql\Schema->loadTableSchema('migration') #10 E:\xampp\htdocs\yii2-advanced-api\vendor\yiisoft\yii2\console\controllers\MigrateController.php(199): yii\db\Schema->getTableSchema('{{%migration}}', true) #11 E:\xampp\htdocs\yii2-advanced-api\vendor\yiisoft\yii2\console\controllers\BaseMigrateController.php(774): yii\console\controllers\MigrateController->getMigrationHistory(NULL) #12 E:\xampp\htdocs\yii2-advanced-api\vendor\yiisoft\yii2\console\controllers\BaseMigrateController.php(138): yii\console\controllers\BaseMigrateController->getNewMigrations() #13 [internal function]: yii\console\controllers\BaseMigrateController->actionUp(0) #14 E:\xampp\htdocs\yii2-advanced-api\vendor\yiisoft\yii2\base\InlineAction.php(57): call_user_func_array(Array, Array) #15 E:\xampp\htdocs\yii2-advanced-api\vendor\yiisoft\yii2\base\Controller.php(156): yii\base\InlineAction->runWithParams(Array) #16 E:\xampp\htdocs\yii2-advanced-api\vendor\yiisoft\yii2\console\Controller.php(128): yii\base\Controller->runAction('', Array) #17 E:\xampp\htdocs\yii2-advanced-api\vendor\yiisoft\yii2\base\Module.php(523): yii\console\Controller->runAction('', Array) #18 E:\xampp\htdocs\yii2-advanced-api\vendor\yiisoft\yii2\console\Application.php(180): yii\base\Module->runAction('migrate', Array) #19 E:\xampp\htdocs\yii2-advanced-api\vendor\yiisoft\yii2\console\Application.php(147): yii\console\Application->runAction('migrate', Array) #20 E:\xampp\htdocs\yii2-advanced-api\vendor\yiisoft\yii2\base\Application.php(380): yii\console\Application->handleRequest(Object(yii\console\Request)) #21 E:\xampp\htdocs\yii2-advanced-api\yii(30): yii\base\Application->run() #22 {main} Next yii\db\Exception: SQLSTATE[HY000] [1049] Unknown database 'yii2advanced' in E:\xampp\htdocs\yii2-advanced-api\vendor\yiisoft\yii2\db\Connection.php:568 Stack trace: #0 E:\xampp\htdocs\yii2-advanced-api\vendor\yiisoft\yii2\db\Connection.php(912): yii\db\Connection->open() #1 E:\xampp\htdocs\yii2-advanced-api\vendor\yiisoft\yii2\db\Connection.php(899): yii\db\Connection->getMasterPdo() #2 E:\xampp\htdocs\yii2-advanced-api\vendor\yiisoft\yii2\db\Command.php(219): yii\db\Connection->getSlavePdo() #3 E:\xampp\htdocs\yii2-advanced-api\vendor\yiisoft\yii2\db\Command.php(896): yii\db\Command->prepare(true) #4 E:\xampp\htdocs\yii2-advanced-api\vendor\yiisoft\yii2\db\Command.php(362): yii\db\Command->queryInternal('fetchAll', NULL) #5 E:\xampp\htdocs\yii2-advanced-api\vendor\yiisoft\yii2\db\mysql\Schema.php(199): yii\db\Command->queryAll() #6 E:\xampp\htdocs\yii2-advanced-api\vendor\yiisoft\yii2\db\mysql\Schema.php(98): yii\db\mysql\Schema->findColumns(Object(yii\db\TableSchema)) #7 E:\xampp\htdocs\yii2-advanced-api\vendor\yiisoft\yii2\db\Schema.php(152): yii\db\mysql\Schema->loadTableSchema('migration') #8 E:\xampp\htdocs\yii2-advanced-api\vendor\yiisoft\yii2\console\controllers\MigrateController.php(199): yii\db\Schema->getTableSchema('{{%migration}}', true) #9 E:\xampp\htdocs\yii2-advanced-api\vendor\yiisoft\yii2\console\controllers\BaseMigrateController.php(774): yii\console\controllers\MigrateController->getMigrationHistory(NULL) #10 E:\xampp\htdocs\yii2-advanced-api\vendor\yiisoft\yii2\console\controllers\BaseMigrateController.php(138): yii\console\controllers\BaseMigrateController->getNewMigrations() #11 [internal function]: yii\console\controllers\BaseMigrateController->actionUp(0) #12 E:\xampp\htdocs\yii2-advanced-api\vendor\yiisoft\yii2\base\InlineAction.php(57): call_user_func_array(Array, Array) #13 E:\xampp\htdocs\yii2-advanced-api\vendor\yiisoft\yii2\base\Controller.php(156): yii\base\InlineAction->runWithParams(Array) #14 E:\xampp\htdocs\yii2-advanced-api\vendor\yiisoft\yii2\console\Controller.php(128): yii\base\Controller->runAction('', Array) #15 E:\xampp\htdocs\yii2-advanced-api\vendor\yiisoft\yii2\base\Module.php(523): yii\console\Controller->runAction('', Array) #16 E:\xampp\htdocs\yii2-advanced-api\vendor\yiisoft\yii2\console\Application.php(180): yii\base\Module->runAction('migrate', Array) #17 E:\xampp\htdocs\yii2-advanced-api\vendor\yiisoft\yii2\console\Application.php(147): yii\console\Application->runAction('migrate', Array) #18 E:\xampp\htdocs\yii2-advanced-api\vendor\yiisoft\yii2\base\Application.php(380): yii\console\Application->handleRequest(Object(yii\console\Request)) #19 E:\xampp\htdocs\yii2-advanced-api\yii(30): yii\base\Application->run() #20 {main} Additional Information: 2017-05-06 21:05:45 [-][-][-][info][application] $_SERVER = [ 'ALLUSERSPROFILE' => 'C:\\ProgramData' 'APPDATA' => 'C:\\Users\\medo_\\AppData\\Roaming' 'CommonProgramFiles' => 'C:\\Program Files (x86)\\Common Files' 'CommonProgramFiles(x86)' => 'C:\\Program Files (x86)\\Common Files' 'CommonProgramW6432' => 'C:\\Program Files\\Common Files' 'COMPUTERNAME' => 'DESKTOP-Q7K811K' 'ComSpec' => 'C:\\WINDOWS\\system32\\cmd.exe' 'easyplussdk' => '\"C:\\Program Files (x86)\\Common Files\\lenovo\\easyplussdk\\bin\"' 'FPS_BROWSER_APP_PROFILE_STRING' => 'Internet Explorer' 'FPS_BROWSER_USER_PROFILE_STRING' => 'Default' 'HOMEDRIVE' => 'C:' 'HOMEPATH' => '\\Users\\medo_' 'LOCALAPPDATA' => 'C:\\Users\\medo_\\AppData\\Local' 'LOGONSERVER' => '\\\\DESKTOP-Q7K811K' 'MOZ_PLUGIN_PATH' => 'C:\\Program Files (x86)\\Foxit Software\\Foxit Reader\\plugins\\' 'NUMBER_OF_PROCESSORS' => '4' 'OneDrive' => 'C:\\Users\\medo_\\OneDrive' 'OS' => 'Windows_NT' 'Path' => 'C:\\Program Files\\Java\\jdk1.8.0_45\\bin;E:\\xampp\\php;C:\\ProgramData\\ComposerSetup\\bin;C:\\Users\\medo_\\AppData\\Local\\Microsoft\\WindowsApps;C:\\Users\\medo_\\AppData\\Roaming\\Composer\\vendor\\bin' 'PATHEXT' => '.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC' 'PHP_COMMAND' => 'php.exe' 'PROCESSOR_ARCHITECTURE' => 'x86' 'PROCESSOR_ARCHITEW6432' => 'AMD64' 'PROCESSOR_IDENTIFIER' => 'Intel64 Family 6 Model 58 Stepping 9, GenuineIntel' 'PROCESSOR_LEVEL' => '6' 'PROCESSOR_REVISION' => '3a09' 'ProgramData' => 'C:\\ProgramData' 'ProgramFiles' => 'C:\\Program Files (x86)' 'ProgramFiles(x86)' => 'C:\\Program Files (x86)' 'ProgramW6432' => 'C:\\Program Files' 'PROMPT' => '$P$G' 'PSModulePath' => 'C:\\WINDOWS\\system32\\WindowsPowerShell\\v1.0\\Modules\\' 'PUBLIC' => 'C:\\Users\\Public' 'SESSIONNAME' => 'Console' 'SystemDrive' => 'C:' 'SystemRoot' => 'C:\\WINDOWS' 'TEMP' => 'C:\\Users\\medo_\\AppData\\Local\\Temp' 'TMP' => 'C:\\Users\\medo_\\AppData\\Local\\Temp' 'USERDOMAIN' => 'DESKTOP-Q7K811K' 'USERDOMAIN_ROAMINGPROFILE' => 'DESKTOP-Q7K811K' 'USERNAME' => 'medo_' 'USERPROFILE' => 'C:\\Users\\medo_' 'windir' => 'C:\\WINDOWS' 'YII_PATH' => 'E:\\xampp\\htdocs\\yii2-advanced-api\\' 'PHP_SELF' => 'E:\\xampp\\htdocs\\yii2-advanced-api\\yii' 'SCRIPT_NAME' => 'E:\\xampp\\htdocs\\yii2-advanced-api\\yii' 'SCRIPT_FILENAME' => 'E:\\xampp\\htdocs\\yii2-advanced-api\\yii' 'PATH_TRANSLATED' => 'E:\\xampp\\htdocs\\yii2-advanced-api\\yii' 'DOCUMENT_ROOT' => '' 'REQUEST_TIME_FLOAT' => 1494097545.8396 'REQUEST_TIME' => 1494097545 'argv' => [ 0 => 'E:\\xampp\\htdocs\\yii2-advanced-api\\yii' 1 => 'migrate' ] 'argc' => 2 ] 2017-05-06 21:06:43 [-][-][-][error][yii\db\Exception] PDOException: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'user' already exists in E:\xampp\htdocs\yii2-advanced-api\vendor\yiisoft\yii2\db\Command.php:846 Stack trace: #0 E:\xampp\htdocs\yii2-advanced-api\vendor\yiisoft\yii2\db\Command.php(846): PDOStatement->execute() #1 E:\xampp\htdocs\yii2-advanced-api\vendor\yiisoft\yii2\db\Migration.php(288): yii\db\Command->execute() #2 E:\xampp\htdocs\yii2-advanced-api\console\migrations\m130524_201442_init.php(16): yii\db\Migration->createTable('{{%user}}', Array, 'CHARACTER SET u...') #3 E:\xampp\htdocs\yii2-advanced-api\vendor\yiisoft\yii2\console\controllers\BaseMigrateController.php(654): m130524_201442_init->up() #4 E:\xampp\htdocs\yii2-advanced-api\vendor\yiisoft\yii2\console\controllers\BaseMigrateController.php(166): yii\console\controllers\BaseMigrateController->migrateUp('m130524_201442_...') #5 [internal function]: yii\console\controllers\BaseMigrateController->actionUp(0) #6 E:\xampp\htdocs\yii2-advanced-api\vendor\yiisoft\yii2\base\InlineAction.php(57): call_user_func_array(Array, Array) #7 E:\xampp\htdocs\yii2-advanced-api\vendor\yiisoft\yii2\base\Controller.php(156): yii\base\InlineAction->runWithParams(Array) #8 E:\xampp\htdocs\yii2-advanced-api\vendor\yiisoft\yii2\console\Controller.php(128): yii\base\Controller->runAction('', Array) #9 E:\xampp\htdocs\yii2-advanced-api\vendor\yiisoft\yii2\base\Module.php(523): yii\console\Controller->runAction('', Array) #10 E:\xampp\htdocs\yii2-advanced-api\vendor\yiisoft\yii2\console\Application.php(180): yii\base\Module->runAction('migrate', Array) #11 E:\xampp\htdocs\yii2-advanced-api\vendor\yiisoft\yii2\console\Application.php(147): yii\console\Application->runAction('migrate', Array) #12 E:\xampp\htdocs\yii2-advanced-api\vendor\yiisoft\yii2\base\Application.php(380): yii\console\Application->handleRequest(Object(yii\console\Request)) #13 E:\xampp\htdocs\yii2-advanced-api\yii(30): yii\base\Application->run() #14 {main} Next yii\db\Exception: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'user' already exists The SQL being executed was: CREATE TABLE `user` ( `id` int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY, `username` varchar(255) NOT NULL, `auth_key` varchar(32) NOT NULL, `password_hash` varchar(255) NOT NULL, `password_reset_token` varchar(255), `email` varchar(255) NOT NULL, `role` smallint(6) NOT NULL DEFAULT 10, `status` smallint(6) NOT NULL DEFAULT 10, `created_at` int(11) NOT NULL, `updated_at` int(11) NOT NULL ) CHARACTER SET utf8 COLLATE utf8_general_ci ENGINE=InnoDB in E:\xampp\htdocs\yii2-advanced-api\vendor\yiisoft\yii2\db\Schema.php:636 Stack trace: #0 E:\xampp\htdocs\yii2-advanced-api\vendor\yiisoft\yii2\db\Command.php(856): yii\db\Schema->convertException(Object(PDOException), 'CREATE TABLE `u...') #1 E:\xampp\htdocs\yii2-advanced-api\vendor\yiisoft\yii2\db\Migration.php(288): yii\db\Command->execute() #2 E:\xampp\htdocs\yii2-advanced-api\console\migrations\m130524_201442_init.php(16): yii\db\Migration->createTable('{{%user}}', Array, 'CHARACTER SET u...') #3 E:\xampp\htdocs\yii2-advanced-api\vendor\yiisoft\yii2\console\controllers\BaseMigrateController.php(654): m130524_201442_init->up() #4 E:\xampp\htdocs\yii2-advanced-api\vendor\yiisoft\yii2\console\controllers\BaseMigrateController.php(166): yii\console\controllers\BaseMigrateController->migrateUp('m130524_201442_...') #5 [internal function]: yii\console\controllers\BaseMigrateController->actionUp(0) #6 E:\xampp\htdocs\yii2-advanced-api\vendor\yiisoft\yii2\base\InlineAction.php(57): call_user_func_array(Array, Array) #7 E:\xampp\htdocs\yii2-advanced-api\vendor\yiisoft\yii2\base\Controller.php(156): yii\base\InlineAction->runWithParams(Array) #8 E:\xampp\htdocs\yii2-advanced-api\vendor\yiisoft\yii2\console\Controller.php(128): yii\base\Controller->runAction('', Array) #9 E:\xampp\htdocs\yii2-advanced-api\vendor\yiisoft\yii2\base\Module.php(523): yii\console\Controller->runAction('', Array) #10 E:\xampp\htdocs\yii2-advanced-api\vendor\yiisoft\yii2\console\Application.php(180): yii\base\Module->runAction('migrate', Array) #11 E:\xampp\htdocs\yii2-advanced-api\vendor\yiisoft\yii2\console\Application.php(147): yii\console\Application->runAction('migrate', Array) #12 E:\xampp\htdocs\yii2-advanced-api\vendor\yiisoft\yii2\base\Application.php(380): yii\console\Application->handleRequest(Object(yii\console\Request)) #13 E:\xampp\htdocs\yii2-advanced-api\yii(30): yii\base\Application->run() #14 {main} Additional Information: Array ( [0] => 42S01 [1] => 1050 [2] => Table 'user' already exists ) 2017-05-06 21:06:30 [-][-][-][info][application] $_SERVER = [ 'ALLUSERSPROFILE' => 'C:\\ProgramData' 'APPDATA' => 'C:\\Users\\medo_\\AppData\\Roaming' 'CommonProgramFiles' => 'C:\\Program Files (x86)\\Common Files' 'CommonProgramFiles(x86)' => 'C:\\Program Files (x86)\\Common Files' 'CommonProgramW6432' => 'C:\\Program Files\\Common Files' 'COMPUTERNAME' => 'DESKTOP-Q7K811K' 'ComSpec' => 'C:\\WINDOWS\\system32\\cmd.exe' 'easyplussdk' => '\"C:\\Program Files (x86)\\Common Files\\lenovo\\easyplussdk\\bin\"' 'FPS_BROWSER_APP_PROFILE_STRING' => 'Internet Explorer' 'FPS_BROWSER_USER_PROFILE_STRING' => 'Default' 'HOMEDRIVE' => 'C:' 'HOMEPATH' => '\\Users\\medo_' 'LOCALAPPDATA' => 'C:\\Users\\medo_\\AppData\\Local' 'LOGONSERVER' => '\\\\DESKTOP-Q7K811K' 'MOZ_PLUGIN_PATH' => 'C:\\Program Files (x86)\\Foxit Software\\Foxit Reader\\plugins\\' 'NUMBER_OF_PROCESSORS' => '4' 'OneDrive' => 'C:\\Users\\medo_\\OneDrive' 'OS' => 'Windows_NT' 'Path' => 'C:\\Program Files\\Java\\jdk1.8.0_45\\bin;E:\\xampp\\php;C:\\ProgramData\\ComposerSetup\\bin;C:\\Users\\medo_\\AppData\\Local\\Microsoft\\WindowsApps;C:\\Users\\medo_\\AppData\\Roaming\\Composer\\vendor\\bin' 'PATHEXT' => '.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC' 'PHP_COMMAND' => 'php.exe' 'PROCESSOR_ARCHITECTURE' => 'x86' 'PROCESSOR_ARCHITEW6432' => 'AMD64' 'PROCESSOR_IDENTIFIER' => 'Intel64 Family 6 Model 58 Stepping 9, GenuineIntel' 'PROCESSOR_LEVEL' => '6' 'PROCESSOR_REVISION' => '3a09' 'ProgramData' => 'C:\\ProgramData' 'ProgramFiles' => 'C:\\Program Files (x86)' 'ProgramFiles(x86)' => 'C:\\Program Files (x86)' 'ProgramW6432' => 'C:\\Program Files' 'PROMPT' => '$P$G' 'PSModulePath' => 'C:\\WINDOWS\\system32\\WindowsPowerShell\\v1.0\\Modules\\' 'PUBLIC' => 'C:\\Users\\Public' 'SESSIONNAME' => 'Console' 'SystemDrive' => 'C:' 'SystemRoot' => 'C:\\WINDOWS' 'TEMP' => 'C:\\Users\\medo_\\AppData\\Local\\Temp' 'TMP' => 'C:\\Users\\medo_\\AppData\\Local\\Temp' 'USERDOMAIN' => 'DESKTOP-Q7K811K' 'USERDOMAIN_ROAMINGPROFILE' => 'DESKTOP-Q7K811K' 'USERNAME' => 'medo_' 'USERPROFILE' => 'C:\\Users\\medo_' 'windir' => 'C:\\WINDOWS' 'YII_PATH' => 'E:\\xampp\\htdocs\\yii2-advanced-api\\' 'PHP_SELF' => 'E:\\xampp\\htdocs\\yii2-advanced-api\\yii' 'SCRIPT_NAME' => 'E:\\xampp\\htdocs\\yii2-advanced-api\\yii' 'SCRIPT_FILENAME' => 'E:\\xampp\\htdocs\\yii2-advanced-api\\yii' 'PATH_TRANSLATED' => 'E:\\xampp\\htdocs\\yii2-advanced-api\\yii' 'DOCUMENT_ROOT' => '' 'REQUEST_TIME_FLOAT' => 1494097590.0426 'REQUEST_TIME' => 1494097590 'argv' => [ 0 => 'E:\\xampp\\htdocs\\yii2-advanced-api\\yii' 1 => 'migrate' ] 'argc' => 2 ]