thedevdojo / chatter

Chatter is a Simple Laravel Forum Package
https://devdojo.com/forums
MIT License
897 stars 295 forks source link

Can't create table - Foreign key constraint is incorrectly formed #278

Open lassopic opened 4 years ago

lassopic commented 4 years ago

Illuminate\Database\QueryException : SQLSTATE[HY000]: General error: 1005 Can't create table ishu_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 C:\xampp\htdocs\2_Laravel_Proj\vendor\laravel\framework\src\Illuminate\Database\Connection.php:669 665| // If an exception occurs when attempting to run a query, we'll format the error 666| // message to include the bindings with SQL, which will make this exception a 667| // lot more helpful to the developer instead of just the database's errors. 668| catch (Exception $e) {

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

Exception trace:

1 PDOException::("SQLSTATE[HY000]: General error: 1005 Can't create table ishu_forum.chatter_discussion (errno: 150 "Foreign key constraint is incorrectly formed")") C:\xampp\htdocs\2_Laravel_Proj\vendor\laravel\framework\src\Illuminate\Database\Connection.php:463

2 PDOStatement::execute() C:\xampp\htdocs\2_Laravel_Proj\vendor\laravel\framework\src\Illuminate\Database\Connection.php:463

goodmuyis commented 4 years ago

Had same issue here Got fix here