Level 67
Are they the same database name? It looks like the migrations have already run and this table already exists. Show your setup/config/settings for 2 databases.
1 like
Mar 31, 2018
2
Level 2
Unable to deploy to forge with multiple databases
Illuminate\Database\QueryException : SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'password_resets' already exists (SQL: create table `password_resets` (`email` varchar(255) not null, `token` varchar(255) not null, `deleted_at` timestamp null, `created_at` timestamp null) default character set utf8mb4 collate utf8mb4_unicode_ci)
at /home/forge/admin.fundtheneedy.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php: 664
660| // If an exception occurs when attempting to run a query, we'll format the error
661| // message to include the bindings with SQL, which will make this exception a
662| // lot more helpful to the developer instead of just the database's errors.
663| catch (Exception $e) {
> 664| throw new QueryException(
665| $query, $this->prepareBindings($bindings), $e
666| );
667| }
668|
Exception trace:
1 PDOException::("SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'password_resets' already exists")
/home/forge/admin.fundtheneedy.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php : 458
2 PDOStatement::execute()
/home/forge/admin.fundtheneedy.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php : 458
Please use the argument -v to see more details.
Got two databases in database.php
Level 67
Another possible issue is you might not be specifying which database connection to use in your migrations, so they all use the "default" database connection.
Schema::connection('foo')->create('users', function (Blueprint $table) {
$table->increments('id');
});
Please or to participate in this conversation.