Can't save pivot data

Need Help
#1

with OC 3.5.x, no error no exception the code just stopped at the $mypivot->save() when I try to update a relationship and some jsonable inside.
The code is using a pivot model

#2

Can you provide any code, that can help us resolve your problem?

#3

mostly the code is $mypivot->save() after updating some variable in the pivot instance such as

$mypivot = UserCoursePivot::where('course_id', $id)->where('user_id', $user_id)->first();
$mypivot->current_module = $next_module;
$mypivot->last_digest_at = $now;
$mypivot->save();

I think the issue is coming from manipulating a pivot model directly.

the table of the pivot model does not have an id column, so maybe that’s why the save method is having trouble to work?

#4

Yeah, you’re probably right that the problem comes from saving the data directly with the pivot model.
I would suggest that you either go the relation attach route (especially if you are using model or relation events or other triggers - might come in handy if I’m interpreting your code correctly) or use the DB facade if you really want to circumvent everything.

If you are adamant on using the pivot model directly, you might find something in the trait \Illuminate\Database\Eloquent\Relations\Concerns\AsPivot, function setKeysForSaveQuery.

#5

yeah that was the problem, I used another model to access the pivot data, update adn save them without issue.