找不到列：1054未知列'tbl_destinations.id'在'where子句'中的PDOException:SQLSTATE:在/var/www/html/...Connection.php:338中重写为：找不到列：1054未知列'tbl_destinations.id'在'where子句'中的数据库异常

Question

我的数据库中的 id 字段是 des_id ，如何将其更改为 des_id？

Route::post('Itest/LoadSuppliers', function (Request $request) {
    $request->validate([
        'destination_id' => 'required|exists:mysql.tbl_destinations,des_id',
        'from' => 'required|numeric|min:0',
        'to' => 'required|numeric|min:0',
    ]);
    $destination_id = Destination::where('des_id','=', $request->destination_id)->firstOrFail();
    $from = $request->from;
    $to = $request->to;
    dispatch(new TestJob($destination_id, $from, $to));
    return response()->json([
        'status' => true
    ]);
});

Answer 1

你的代码对我来说看起来不错。

尝试在您的目标模型中进行设置：

protected $primaryKey = 'des_id';