我想用 Laravel eloquent 更新來更新我的資料庫，但回應總是500
這是我的模型
class Tunggakan extends Model
{
protected $table = 'kredit_tunggakan';
/**
* @var array
*/
}
這是功能
public function statusTunggakan(){
$status = Tunggakan::find(2);
$status -> id_status = 77;
$status -> save();
}
這是路線
Route::prefix('tunggakan')->group(function () {
Route::post('/statusTunggakan','TunggakanControl@statusTunggakan');
});
例外：
[2022-03-24 11:20:14] production.ERROR: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'kredit_tunggakan.updated_at' in 'field list' (SQL: update kredit_tunggakan set id_status = 77, kredit_tunggakan.updated_at = 2022-03-24 11:20:14 where id = 2) {"exception":"[object] (Illuminate\\Database\\QueryException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'kredit_tunggakan.updated_at' in 'field list' (SQL: update kredit_tunggakan set id_status = 77, kredit_tunggakan.updated_at = 2022-03-24 11:20:14 where id = 2)
之前謝謝你的幫助..
uj5u.com熱心網友回復：
看例外：
Column not found: 1054 Unknown column 'kredit_tunggakan.updated_at
好像您的資料庫表中沒有updated_at列。有兩種解決方案：
I：創建/更新您的遷移以包含timestamp欄位：
$table->timestamps();
二：更新記錄時設定timestamps為：false
$status = Tunggakan::find(2);
$status->timestamps = false;
$status -> id_status = 77;
$status -> save();
轉載請註明出處，本文鏈接：https://www.uj5u.com/houduan/448887.html
下一篇：匯出mysql資料庫表