In Form Builder - Relation is failing to save. Presents SQL error.
When saving a resource that has a relation with another resource, it looks like it saves the resource, however presents this SQL error. Also attached at pictures of the models being used, with their relations. The form is using
relationship('host', 'name') as the way to relate the 2 models via the form. (This does present the data correctly, and seems to store it correctly as well, but it's acting as if it needs to update the User Table, when it has no real reason to update that?
Maybe I have something set up wrong.
When trying to use this in a front-end using Livewire, it for some reason isn't caring what is stored for the host. I'll open another help post if that is needed.
8 Replies
The trip table must have user_id foreign key, thats how you relate them.
Check this https://laravel.com/docs/12.x/eloquent-relationships#one-to-many
Eloquent: Relationships - Laravel 12.x - The PHP Framework For Web ...
Laravel is a PHP web application framework with expressive, elegant syntax. We’ve already laid the foundation — freeing you to create without sweating the small things.
hasOne() is used in a one to one relation.
I plan on having a normal user be the host.
To me the data it's pulling is right to be stored in the trip, based on the form. But it's acting like it needs to update the user table?
One host (user) to many (trip)
This i think shows it that it should be right
it can be host_id, user_id. And in the the relation function in the model, you put 'host_id' instead of 'id'
User model has many trips you use hasMany ($this->hasMany(Trip::class))
Trip belongs to a User you use belongsTo ($this->belongsTo(User::class,'host_id'))
I get that when I change the Trip Model to use "host_id" instead of 'id'
Which looks like it's trying to use host_id instead of ID
But it also says it's trying to "update" the users table
which it shouldn't be trying to update it.
I have
$table->foreignId('host_id')->constrained('users'); set up in my trip migration, so that should be correct.
AHHHH I THINK I GOT IT.
So I'm a moron... and missed the piece of BELONGSTO and had... HASMANY
Switching that with my original id piece, worked.
Thank you @Bruno Pereira for guiding me in the right direction... (I didn't realize they weren't interchangable in that way... which is my bad.)glad I could help