Im using the package “robmorgan/phinx”: “^0.15”
I run to an issue with Phinx migration, when I run command phinx migrate with the config file, This error occurs.
vendorbinphinx migrate -c "Device/conf.php"
This is detail error:
TypeError: PhinxDbAdapterPdoAdapter::createPdoConnection(): Argument #2 ($username) must be of type ?string, bool given, called in C:ApplicationswampwwwyodamigrationsrcvendorrobmorganphinxsrcPhinxDbAdapterMysqlAdapter.php on line 158 and defined in C:ApplicationswampwwwyodamigrationsrcvendorrobmorganphinxsrcPhinxDbAdapterPdoAdapter.php:85
Stack trace:
#0 C:ApplicationswampwwwyodamigrationsrcvendorrobmorganphinxsrcPhinxDbAdapterMysqlAdapter.php(158): PhinxDbAdapterPdoAdapter->createPdoConnection('mysql:host=;dbn...', false, false, Array)
#1 C:ApplicationswampwwwyodamigrationsrcvendorrobmorganphinxsrcPhinxDbAdapterPdoAdapter.php(169): PhinxDbAdapterMysqlAdapter->connect()
#2 C:ApplicationswampwwwyodamigrationsrcvendorrobmorganphinxsrcPhinxDbAdapterPdoAdapter.php(256): PhinxDbAdapterPdoAdapter->getConnection()
#3 C:ApplicationswampwwwyodamigrationsrcvendorrobmorganphinxsrcPhinxDbAdapterPdoAdapter.php(277): PhinxDbAdapterPdoAdapter->query('SELECT * FROM `...')
#4 C:ApplicationswampwwwyodamigrationsrcvendorrobmorganphinxsrcPhinxDbAdapterPdoAdapter.php(413): PhinxDbAdapterPdoAdapter->fetchAll('SELECT * FROM `...')
#5 C:ApplicationswampwwwyodamigrationsrcvendorrobmorganphinxsrcPhinxDbAdapterPdoAdapter.php(385): PhinxDbAdapterPdoAdapter->getVersionLog()
#6 C:ApplicationswampwwwyodamigrationsrcvendorrobmorganphinxsrcPhinxDbAdapterAdapterWrapper.php(206): PhinxDbAdapterPdoAdapter->getVersions()
#7 C:ApplicationswampwwwyodamigrationsrcvendorrobmorganphinxsrcPhinxMigrationManagerEnvironment.php(254): PhinxDbAdapterAdapterWrapper->getVersions()
#8 C:ApplicationswampwwwyodamigrationsrcvendorrobmorganphinxsrcPhinxMigrationManager.php(316): PhinxMigrationManagerEnvironment->getVersions()
#9 C:ApplicationswampwwwyodamigrationsrcvendorrobmorganphinxsrcPhinxConsoleCommandMigrate.php(124): PhinxMigrationManager->migrate('dev', NULL, false)
#10 C:ApplicationswampwwwyodamigrationsrcvendorsymfonyconsoleCommandCommand.php(326): PhinxConsoleCommandMigrate->execute(Object(SymfonyComponentConsoleInputArgvInput), Object(SymfonyComponentConsoleOutputConsoleOutput))
#11 C:ApplicationswampwwwyodamigrationsrcvendorsymfonyconsoleApplication.php(1063): SymfonyComponentConsoleCommandCommand->run(Object(SymfonyComponentConsoleInputArgvInput), Object(SymfonyComponentConsoleOutputConsoleOutput))
#12 C:ApplicationswampwwwyodamigrationsrcvendorsymfonyconsoleApplication.php(320): SymfonyComponentConsoleApplication->doRunCommand(Object(PhinxConsoleCommandMigrate), Object(SymfonyComponentConsoleInputArgvInput), Object(SymfonyComponentConsoleOutputConsoleOutput))
#13 C:ApplicationswampwwwyodamigrationsrcvendorrobmorganphinxsrcPhinxConsolePhinxApplication.php(69): SymfonyComponentConsoleApplication->doRun(Object(SymfonyComponentConsoleInputArgvInput), Object(SymfonyComponentConsoleOutputConsoleOutput))
#14 C:ApplicationswampwwwyodamigrationsrcvendorsymfonyconsoleApplication.php(174): PhinxConsolePhinxApplication->doRun(Object(SymfonyComponentConsoleInputArgvInput), Object(SymfonyComponentConsoleOutputConsoleOutput)) #15 C:Applicationswampwwwyodamigrationsrcvendorrobmorganphinxbinphinx(28): SymfonyComponentConsoleApplication->run()
#16 C:Applicationswampwwwyodamigrationsrcvendorbinphinx(120): include('C:\Applications...')
#17 {main}
My conf file content :
$conf = [
"paths" => [
"migrations" => __DIR__,
],
"environments" => [
"default_migration_table" => "phinxlog",
"default_environment" => "dev",
"dev" => [
"adapter" => "mysql",
"host" => getenv('DB_HOST', '127.0.0.1'),
"name" => getenv("DB_DATABASE_CATALOG_DEVICE"),
"user" => getenv('DB_USERNAME', 'forge'),
"pass" => getenv('DB_PASSWORD', ''),
"charset" => "utf8",
"collation" => "utf8_general_ci",
],
],
];