Migration Issue v3 to v4

[ddarrund]

Hi,

I am trying to migrate from v3 to v4, I got this error below after the restoring the DB either from the sql dump or db backup, once I drop the table, it will create another error on another table and so on:

/var/www/snipeit$ php artisan migrate

---

• Application In Production!     *
  

---

Do you really wish to run this command? (yes/no) [no]:

yes

In Connection.php line 647:

SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'oauth_personal_access_clients' already exists (SQL: create table oauth_persona l_access_clients (id int unsigned not null auto_increment primary key, client_id int not null, created_at timestamp null, updated_at t
imestamp null) default character set utf8mb4 collate utf8mb4_unicode_ci engine = InnoDB)

In PDOStatement.php line 107:

SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'oauth_personal_access_clients' already exists

In PDOStatement.php line 105:

SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'oauth_personal_access_clients' already exists

[Jarli01]

Did you follow the process here: https://snipe-it.readme.io/v4.0/docs/upgrading-to-v4 ?

You need to put the application into maintenance mode and then run through a few more steps.

[ddarrund]

Hi,
I have followed the process you mentioned above and still getting:

php artisan migrate

---

• Application In Production!     *
  

---

Do you really wish to run this command? (yes/no) [no]:

yes

In Connection.php line 647:

SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'oauth_personal_access_clients' already exists (SQL: create table oauth_personal_access_clients
(id int unsigned not null auto_increment primary key, client_id int not null, created_at timestamp null, updated_at timestamp null) default character s
et utf8mb4 collate utf8mb4_unicode_ci engine = InnoDB)

In PDOStatement.php line 107:

SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'oauth_personal_access_clients' already exists

In PDOStatement.php line 105:

SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'oauth_personal_access_clients' already exists

[stale]

Is this still relevant? We haven't heard from anyone in a bit. If so, please comment with any updates or additional detail.
This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Don't take it personally, we just need to keep a handle on things. Thank you for your contributions!

[stale]

This issue has been automatically closed because it has not had recent activity. If you believe this is still an issue, please confirm that this issue is still happening in the most recent version of Snipe-IT and reply to this thread to re-open it.