© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
FilamentF
Filament•3y ago•
1 reply
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
bookings
bookings
SET
requester_id
requester_id
= [],
bookings
bookings
.
updated_at
updated_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
magna
magna
.
bookings
bookings
.
requester_id
requester_id
at row 1 (Connection: mysql, SQL: update
bookings
bookings
set
requester_id
requester_id
= [],
bookings
bookings
.
updated_at
updated_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.
BookingResource.php
Filament banner
FilamentJoin
A powerful open source UI framework for Laravel • Build and ship admin panels & apps fast with Livewire
20,307Members
Resources

Similar Threads

Was this page helpful?
Recent Announcements

Similar Threads

Form not submitting when using CKEditor
FilamentFFilament / ❓┊help
2y ago
No data saved when submitting a form...
FilamentFFilament / ❓┊help
2mo ago
How to modify fields when submitting form
FilamentFFilament / ❓┊help
2y ago
Autofocus after submitting form
FilamentFFilament / ❓┊help
2y ago