F

Filament•3y ago

Alex

UPDATE query error when submitting form

Here is the error i'm getting:
SQLSTATE[HY000]: General error: 1366 Incorrect integer value: '[]' for column 'requester_id' at row 1
update bookingsbookings SET requester_idrequester_id = [], bookingsbookings.updated_atupdated_at = 2023-11-01 09:11:48 WHERE

id

id

= 3
Flare link: https://flareapp.io/share/353BBd67

I'm not sure why it is trying to run this update query and what the point of it is. Immediately before, it successfully runs an INSERT query as expected that adds the booking to the database, including the correct requester_id that is selected within the form.

Here is a Gist link to my BookingResource.php file:
https://gist.github.com/alexb34n/adc3f7f26f7f94efccd26d6c1aa4f36f

Apologies in advance if it's anything really simple. I'm relatively new to this so still finding my feet.

Flare

SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect integer value: '[]' for column magnamagna.bookingsbookings.requester_idrequester_id at row 1 (Connection: mysql, SQL: update bookingsbookings set requester_idrequester_id = [], bookingsbookings.updated_atupdated_at = 2023-11-01 09:17:23 where

id

id

= 39) - The error occurred at http://127.0.0.1:8000/admin/bookings/create

Gist

BookingResource.php

BookingResource.php. GitHub Gist: instantly share code, notes, and snippets.