Be part of JetBrains PHPverse 2026 on June 9 – a free online event bringing PHP devs worldwide together.

mohammadkhallaf's avatar

SQLSTATE[HY000]: General error: 1364 Field 'date' doesn't have a default value


 public function store(Request $request)
    {
        $this->validate($request, [
            'personal_id' => 'required|exists:customers,personal_id',
            'test_id' => 'required|exists:tests,id',
            'amount' => 'required|integer',
            'date' => 'required'
        ]);
        $finances = Finance::create([
            'customer_id' => customer::where('personal_id', $request->personal_id)->first()->id,
            'test_id' => $request->test_id,
            'date' => $request->date,
            'amount' => $request->amount,
            'remaining' => $request->amount ,
            'note' => $request->note
        ]);

        return redirect()->back()->with('success', 'تم اضافة معلومات مالية جديدة');
    }
0 likes
2 replies
Sinnbeck's avatar

Check if date is in the $fillable array on the Finance model

Please or to participate in this conversation.