Why is this laravel eloquent query running so SLOWLY? I have a query running in a Laravel job that executes very slowly and inconsistently. Sometimes it takes 1-2 minutes to fetch the result, while at other times it completes in…
I'm working on a Laravel application and I need help with filtering titles based on their relationships with practices, quizzes, and contests. Specifically, I want to retrieve titles that have associated practices but do not have any associated quizzes or…
In my Laravel app, I have User, List and ListItem models, with a one-to-many relationship between User and List and many-to-many relationships between User and ListItem and between List and ListItem. Each User should be able to tag the ListItems…
I'm developing a Laravel 11 application that asks users to submit data, which is then saved to a database. My migrations have successfully created the necessary tables, but I'm having an issue. I can't seem to save data to the…
i am casting an array [1,2] and in my model I have this setup protected $casts = [ 'skills' => 'array' ]; and I have my relationship setup like this public function skills(){ return $this->hasMany(Skill::class,'id'); } now my problem is…
I want a single row of player through his playerNo field which is later added and updated. I am doing this. $player = Account::where('playerNo', 99)->get(); Result I am getting is many objects of players that only has player object with…
I'm having performance issues with MySQL, despite having indexes when using both join and order by . The query is currently taking 77 seconds to complete. The purpose of the query is to order the table alphabetically. Background I have…
I'm using latest version of Laravel. I'm trying to setup a model method relationship that passes through other intermediary tables. Understanding the table structure below, my goal is retrieve a collection of Students (only) which are enrolled in a course…
So I'm currently struggling with my AlbumController's store function, where i need to store an album in my albums table, including the indexes of the pictures selected to be included in the album, in which the pictures included are then…
Laravel docs recommends using attempts to deal with Deadlocks (https://shorturl.at/bsKta) But, the handleTransactionException() method inside the transaction() method has a comment: On a deadlock, MySQL rolls back the entire transaction so we can't just retry the query. We have to…