I Get This Error While Php Artisan Migrate

0

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

Question Resolved For: Modern Point of Sale Solution 0 Votes 3 Answers 3.1k Views
Asked by Gent 3 years ago

0

Answered by Mian Saleem

Hello,

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

Thank you for updating

0

Answered by Gent 3 years ago

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 | |
+------+---------------------------------------------------------------+-------+

0

Answered by Gent 3 years ago

fixed it

We use Cookies

We use cookies to ensure that we give you the best experience on our website. By continuing to browse the site you are agreeing to our use of cookies.