Laravel 5违反完整性约束 [英] Laravel 5 Integrity constraint violation

问题描述

我遵循了 laracast系列，并停留在某个位置. /p>

通过尝试提交博客帖子，我收到以下错误消息:

Connection.php第713行中的

QueryException:SQLSTATE [23000]:违反完整性约束:1452无法添加或更新子行:外键约束失败(codeshare.articles，CONSTRAINT articles_user_id_foreign FOREIGN KEY( user_id)在删除级联上的引用users(id)(SQL:插入articles(title，body，published_at，updated_at，created_at)值(lorem， ipsum，2016-07-19 10:11:49，2016-07-19 10:11:49，2016-07-19 10:11:49))

奇怪的是，已提交的文章存储在数据库中，并且也出现在我的文章视图中.

ArticlesController:

public function store(ArticleRequest $request) {
Auth::user()->articles()->save(new article($request->all()));
Article::create($request->all());
return redirect('articles');
}

商品型号:

public function user() {
$this->belongsTo('App\User'); //user_id
}

模式:

public function up()
{
    Schema::create('articles', function (Blueprint $table) {
        $table->increments('id');
        $table->integer('user_id')->unsigned();
        $table->string('title');
        $table->text('body');
        $table->timestamp('created_at');
        $table->timestamp('published_at');

        $table->foreign('user_id')
              ->references('id')
              ->on('users')
              ->onDelete('cascade');

    });
}

你知道例外的原因是什么吗?

解决方案

您可以尝试省略此行

Article::create($request->all());

因为您已经将文章保存为

Auth::user()->articles()->save(new Article($request->all()));

I followed a laracast series and stuck at some point.

I got the following error message by trying to submit a blog post:

QueryException in Connection.php line 713: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (codeshare.articles, CONSTRAINT articles_user_id_foreign FOREIGN KEY (user_id) REFERENCES users (id) ON DELETE CASCADE) (SQL: insert into articles (title, body, published_at, updated_at, created_at) values (lorem, ipsum, 2016-07-19 10:11:49, 2016-07-19 10:11:49, 2016-07-19 10:11:49))

The strange thing is, that the submitted article is stored to the DB and also appears in my articles view.

ArticlesController:

public function store(ArticleRequest $request) {
Auth::user()->articles()->save(new article($request->all()));
Article::create($request->all());
return redirect('articles');
}

Article Model:

public function user() {
$this->belongsTo('App\User'); //user_id
}

Schema:

public function up()
{
    Schema::create('articles', function (Blueprint $table) {
        $table->increments('id');
        $table->integer('user_id')->unsigned();
        $table->string('title');
        $table->text('body');
        $table->timestamp('created_at');
        $table->timestamp('published_at');

        $table->foreign('user_id')
              ->references('id')
              ->on('users')
              ->onDelete('cascade');

    });
}

Any idea what's the reason for the exception?

解决方案

You can try to leave out this line

Article::create($request->all());

since you are already saving the article with

Auth::user()->articles()->save(new Article($request->all()));

这篇关于Laravel 5违反完整性约束的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！