Skip to content

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

@lassopic

Description

@lassopic

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

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions