C:\Study\php\newblog>php artisan migrate
Migrating: 2019_12_14_000001_create_personal_access_tokens_table
Illuminate\Database\QueryException
SQLSTATE[42S01]: Base table or view already exists: 1050 Table ‘personal_access_tokens’ already exists (SQL: create table personal_access_tokens
(id
bigint unsigned not null auto_increment primary key, tokenable_type
varchar(191) not null, tokenable_id
bigint unsigned not null, name
varchar(191) not null, token
varchar(64) not null, abilities
text null, last_used_at
timestamp null, created_at
timestamp null, updated_at
timestamp null) default character set utf8mb4 collate ‘utf8mb4_unicode_ci’)
at C:\Study\php\newblog\vendor\laravel\framework\src\Illuminate\Database\Connection.php:712
708▕ // If an exception occurs when attempting to run a query, we’ll format the error
709▕ // message to include the bindings with SQL, which will make this exception a
710▕ // lot more helpful to the developer instead of just the database’s errors.
711▕ catch (Exception $e) {
➜ 712▕ throw new QueryException(
713▕ $query, $this->prepareBindings($bindings), $e
714▕ );
715▕ }
716▕ }
1 C:\Study\php\newblog\vendor\laravel\framework\src\Illuminate\Database\Connection.php:501
PDOException::(“SQLSTATE[42S01]: Base table or view already exists: 1050 Table ‘personal_access_tokens’ already exists”)
2 C:\Study\php\newblog\vendor\laravel\framework\src\Illuminate\Database\Connection.php:501
PDOStatement::execute()
求解!!
本作品採用《CC 協議》,轉載必須註明作者和本文連結