G
Asked
php artisan migrate
**************************************
* Application In Production! *
**************************************
Do you really wish to run this command? (yes/no) [no]:
> y
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(255) not null, `tokenable_id` bigint unsigned not null, `name` varchar(255) 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 vendor/laravel/framework/src/Illuminate/Database/Connection.php:716
712▕ // If an exception occurs when attempting to run a query, we'll format the error
713▕ // message to include the bindings with SQL, which will make this exception a
714▕ // lot more helpful to the developer instead of just the database's errors.
715▕ catch (Exception $e) {
➜ 716▕ throw new QueryException(
717▕ $query, $this->prepareBindings($bindings), $e
718▕ );
719▕ }
720▕ }
+32 vendor frames
33 artisan:37
Illuminate\Foundation\Console\Kernel::handle()
**************************************
* Application In Production! *
**************************************
Do you really wish to run this command? (yes/no) [no]:
> y
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(255) not null, `tokenable_id` bigint unsigned not null, `name` varchar(255) 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 vendor/laravel/framework/src/Illuminate/Database/Connection.php:716
712▕ // If an exception occurs when attempting to run a query, we'll format the error
713▕ // message to include the bindings with SQL, which will make this exception a
714▕ // lot more helpful to the developer instead of just the database's errors.
715▕ catch (Exception $e) {
➜ 716▕ throw new QueryException(
717▕ $query, $this->prepareBindings($bindings), $e
718▕ );
719▕ }
720▕ }
+32 vendor frames
33 artisan:37
Illuminate\Foundation\Console\Kernel::handle()
- GAnsweredphp artisan migrate:status
+------+---------------------------------------------------------------+-------+
| Ran? | Migration | Batch |
+------+---------------------------------------------------------------+-------+
| Yes | 2017_02_21_070324_create_attachments_table | 2 |
| Yes | 2017_03_17_070324_alter_attachments_table_extend_filetype | 2 |
| Yes | 2017_08_21_201100_alter_attachments_table_add_group_column | 2 |
| No | 2019_12_14_000001_create_personal_access_tokens_table | |
| No | 2022_01_19_000000_modify_failed_jobs_table | |
| No | 2022_03_10_113257_add_event_column_to_activity_log_table | |
| No | 2022_03_10_113258_add_batch_uuid_column_to_activity_log_table | |
| No | 2022_03_29_162019_create_model_names_table | |
+------+---------------------------------------------------------------+-------+ - GAnsweredfixed it
- MSAnsweredHello,
Looks like the migrations were not saved. I am flad that you get it fixed.
Thank you for updating - Login to Reply