Problem with migrating this "2016_07_29_171128_create_foreign_keys"

[mrvx]

Migrating: 2016_07_29_171128_create_foreign_keys

Illuminate\Database\QueryException : SQLSTATE[HY000]: General error: 1215 Cannot add foreign key constraint (SQL: alter table chatter_discussion add constraint chatter_discussion_user_id_foreign foreign key (user_id) references users (id) on delete cascade on update cascade)

at /Users/veikoteekel/PhpstormProjects/pillamail2/pillamail/vendor/laravel/framework/src/Illuminate/Database/Connection.php:664
660| // If an exception occurs when attempting to run a query, we'll format the error
661| // message to include the bindings with SQL, which will make this exception a
662| // lot more helpful to the developer instead of just the database's errors.
663| catch (Exception $e) {

664| throw new QueryException(
665| $query, $this->prepareBindings($bindings), $e
666| );
667| }
668|

Exception trace:

1 PDOException::("SQLSTATE[HY000]: General error: 1215 Cannot add foreign key constraint")
/Users/veikoteekel/PhpstormProjects/pillamail2/pillamail/vendor/laravel/framework/src/Illuminate/Database/Connection.php:458

2 PDOStatement::execute()
/Users/veikoteekel/PhpstormProjects/pillamail2/pillamail/vendor/laravel/framework/src/Illuminate/Database/Connection.php:458

Please use the argument -v to see more details.

[baraegh]

same here

[baraegh]

I have fixed this issue by using increment('id') instead of id() in 2014_10_12_000000_create_users_table.php file
& I use $table->unsignedInteger('user_id'); instead of $table->integer('user_id')->unsigned();
in 2016_07_29_171118_create_chatter_discussion_table.php file

[JamieCee20]

That did work however, now this error responds after changing the unsignedBigIntegers.

General error: 1005 Can't create table dashhound.chatter_discussion (errno: 121 "Duplicate key on write or update") (SQL: alter table chatter_discussion add constraint chatter_discussion_chatter_category_id_foreign foreign key (chatter_category_id) references chatter_categories (id) on delete cascade)

[mahdi4k]

That did work however, now this error responds after changing the unsignedBigIntegers.

General error: 1005 Can't create table dashhound.chatter_discussion (errno: 121 "Duplicate key on write or update") (SQL: alter table chatter_discussion add constraint chatter_discussion_chatter_category_id_foreign foreign key (chatter_category_id) references chatter_categories (id) on delete cascade)

first you need to fresh database next use migrate

[JamieCee20]

That did work however, now this error responds after changing the unsignedBigIntegers.
General error: 1005 Can't create table dashhound.chatter_discussion (errno: 121 "Duplicate key on write or update") (SQL: alter table chatter_discussion add constraint chatter_discussion_chatter_category_id_foreign foreign key (chatter_category_id) references chatter_categories (id) on delete cascade)

first you need to fresh database next use migrate

I did manage to get it working eveentually, apologies for not updating the issue. I've since created my own due to it being a university project and looks good having my own.

[yazan-1999]

Migrating: 2016_07_29_171118_create_chatter_post_table
Migrated: 2016_07_29_171118_create_chatter_post_table (0.02 seconds)
Migrating: 2016_07_29_171128_create_foreign_keys

Illuminate\Database\QueryException

SQLSTATE[HY000]: General error: 1005 Can't create table forum.chatter_discussion (errno: 150 "Foreign key constraint is incorrectly formed") (SQL: alter table chatter_discussion add constraint chatter_discussion_user_id_foreign foreign key (user_id) references users (id) on delete cascade on update cascade)

at vendor/laravel/framework/src/Illuminate/Database/Connection.php:671
667| // If an exception occurs when attempting to run a query, we'll format the error
668| // message to include the bindings with SQL, which will make this exception a
669| // lot more helpful to the developer instead of just the database's errors.
670| catch (Exception $e) {

671| throw new QueryException(
672| $query, $this->prepareBindings($bindings), $e
673| );
674| }
675|

  +12 vendor frames 

13 database/migrations/2016_07_29_171128_create_foreign_keys.php:17
Illuminate\Support\Facades\Facade::__callStatic()

  +21 vendor frames 

35 artisan:37
Illuminate\Foundation\Console\Kernel::handle()

increments('id'); $table->integer('chatter_category_id')->unsigned()->default('1'); $table->string('title'); $table->unsignedInteger('user_id'); $table->boolean('sticky')->default(false); $table->integer('views')->unsigned()->default('0'); $table->boolean('answered')->default(0); $table->timestamps(); }); } public function down() { Schema::drop('chatter_discussion'); } }

[yazan-1999]

help please ;(