我只是想尋求幫助。播種時出現此錯誤。有人能幫我嗎？多謝。
錯誤：
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');
});
}
非常感謝。希望有人能幫助我。
uj5u.com熱心網友回復：
希望這可以幫助！
驗證“用戶”表中是否存在“id”30。
這是您嘗試插入或更新的 'employee_jobs_statuses' 表的 ' addedBy_id' 列的值，該值在 'users' 表中不存在。
不要忘記“employee_jobs_statuses”表的“ addedBy_id”列的值取決于“users”表的“id”值。
轉載請註明出處，本文鏈接：https://www.uj5u.com/caozuo/532642.html
標籤：mysql拉拉维尔