Which version of laravel?

7.0

so your migration file is your problem

that’s the voyage package migration

yes but check, the migraiton file generated at 2017,

there was no even laravel 6 in these days.

$table->foreign(‘foreign_key_name’)
->references(‘id’)->on(‘roles’)
->onDelete(‘no action’)
->onUpdate(‘no action’);

Roles table screenshot

this is an example.

also show the list of all migrated ones in this image please.

the order of migrated files also important

But i want roles migration

From where i can analyze

Because both related users and role

Remove big from here

Or

Add bigincrement here

Defenitely resolve

also you should know one more thing

Because two different datatype creTe issue

usage of the usigned() in mgiration files also depends

$table->unsignedBigInteger(‘name’)

Yeah sure not name id

this kind of fields not giving problems laravel 6+ versions

First try and let me know I am sure problem will resolve

Sushant, I try to give him examples, but complaining my advises, so give better ideas if you have or shut up. 🙂

ready now I get an error in this migration voyage

Migration revert karo

Pahle

you have to drop this table manualy

Ya manually migration delete karo

because you had a problem in migration, table was created but not inserted at migrations table

if migrate:rollback not resolve

Okey sir you have more knowlege than me what i can i am telling i am not always right sir

in all the way its a fresh installation as I think, so instead trying to rollback each time after a change in migration files,
php artisan migrate:fresh

rollback will not handle that

Yeah right

if I were you, I would make passive all the foreign key parts of the migrations, and after all works with no any errors, I would have create additional migration file which contains all these relationships

I get a second migration error

show ?

php artisan migrate:fresh

I put it on and I got that error

if you dont mind, let me check it myself

do you have AnyDesk ? pm me

drop user_roles table manualy