拉勒维尔。违反完整性约束: 1452

Question

我只想寻求帮助。我在播种时遇到了这个错误。有人能帮我吗？非常感谢。

错误：

SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`cherithportal`.`employee_jobs_statuses`, CONSTRAINT `employee_jobs_statuses_addedby_id_foreign` FOREIGN KEY (`addedBy_id`) REFERENCES `users` (`id`) ON UPDATE CASCADE) (SQL: insert into `employee_jobs_statuses` (`addedBy_id`, `date_added`, `name`) values (30, 2022-11-11 05:42:40, Assigned), (30, 2022-11-11 05:42:40, Interview Scheduled), (30, 2022-11-11 05:42:40, Interview Not Attended), (30, 2022-11-11 05:42:40, Interview Rescheduled), (30, 2022-11-11 05:42:40, Rejected), (30, 2022-11-11 05:42:40, On Hold), (30, 2022-11-11 05:42:40, Selected), (30, 2022-11-11 05:42:40, Offered), (30, 2022-11-11 05:42:40, Did Not Join), (30, 2022-11-11 05:42:40, Joined))

移徙：

public function up()
    {
        Schema::create('employee_jobs_statuses', function (Blueprint $table) {
            $table->increments('id');
            $table->string('name');
            $table->dateTime('date_added');
            $table->integer('addedBy_id')->unsigned(); 
            $table->timestamps();
            $table->foreign('addedBy_id')->references('id')->on('users');
        });
    }

非常感谢。希望有人能帮我。

Answer 1

希望这能有所帮助！

验证“id”30是否存在于“用户”表中。

下面是试图插入或更新“用户”表中不存在的“employee_jobs_statuses”表的“employee_jobs_statuses”列的值。

不要忘记，"addedBy_id“表的"employee_jobs_statuses”列的值依赖于“用户”表的"id“值。