Question: I Get This Error While Php Artisan Migrate

I Get This Error While Php Artisan Migrate

php artisan migrate ************************************** * Application In Production! * ************************************** Do you really wish to run this command? (yes/n

G

Gent

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()
  • G

    Gent

    Answered
    php 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 | |
    +------+---------------------------------------------------------------+-------+
  • G

    Gent

    Answered
    fixed it
  • MS

    Mian Saleem

    Answered
    Hello,

    Looks like the migrations were not saved. I am flad that you get it fixed.

    Thank you for updating
  • Login to Reply