No query results for model [App\Player]

Maybe this $this->post_repository->getPostFields() is not returning anything.

I put die() above the return, still the same problem, this also happens when I am not logged in, so the Auth Middleware doesn't even have a chance to redirect me. I am very lost with this...

Try this return view('players.add',['postFields'=> $this->post_repository->getPostFields()]);

No luck with that either, it is breaking before it even gets to the Middleware (because if I am logged out I get the same error). Could there be something messed up?

Are you sure you dont have another route above that? If your die() isnt even being called that is a big sign, otherwise a middleware is interfering

You need to show your whole controller, you're using $this in your controller so I'm assuming you have some custom methods, maybe even a constructor?

Yes I am sure there is not another route above that, my routes.php file:

<?php

/*
|--------------------------------------------------------------------------
| Application Routes
|--------------------------------------------------------------------------
|
| Here is where you can register all of the routes for an application.
| It's a breeze. Simply tell Laravel the URIs it should respond to
| and give it the controller to call when that URI is requested.
|
*/

Route::get('/', function () {
    return view('welcome');
});

Route::auth();
Route::get('register/verify/{confirmation_code}', 'Auth\AuthController@verify');

Route::get('posts', 'UserController@posts');
Route::get('settings', 'UserController@settings');

Route::get('players', 'PlayerController@index');
Route::get('player/{player}', 'PlayerController@view');
Route::post('players', 'PlayerController@search');
Route::get('player/add', 'PlayerController@add')->middleware('auth');
Route::get('player/edit/{player}', 'PlayerController@edit')->middleware('auth');
Route::post('player', 'PlayerController@store')->middleware('auth');
Route::put('player/{player}', 'PlayerController@change')->middleware('auth');
Route::delete('player/delete/{player}', 'PlayerController@destroy')->middleware('auth');

Route::get('teams', 'TeamController@index');
Route::get('team/{team}', 'TeamController@view');
Route::post('teams', 'TeamController@search');
Route::get('team/add', 'TeamController@add')->middleware('auth');
Route::get('team/edit/{team}', 'TeamController@edit')->middleware('auth');
Route::post('team', 'TeamController@store')->middleware('auth');
Route::put('team/{team}', 'TeamController@change')->middleware('auth');
Route::delete('team/delete/{team}', 'TeamController@destroy')->middleware('auth');

My controller is around 200 lines long, but here is what is above:

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;

use App\Player;
use App\Repositories\PlayerRepository;
use App\Repositories\PostRepository;

class PlayerController extends Controller
{
    protected $player_repository, $post_repository;
    
    public function __construct(PlayerRepository $player_repository, PostRepository $post_repository)
    {
        $this->player_repository = $player_repository;
        $this->post_repository = $post_repository;
    }
    
    public function index(Request $request)
    {
        $players = $this->player_repository->getPlayerPosts();
        $post_fields = $this->post_repository->getPostFields();
        
        $array = array_merge($players, $post_fields);
        
        return view('players.index', $array);
    }
    
    public function add(Request $request)
    {
        return view('players.add', $this->post_repository->getPostFields());
    }

If it is something with my Middleware, what can I do to debug it? It seems to have happened completely at random, I don't know where to start.

@clarkeylogic what happens if you try this..

Route::get('players', 'PlayerController@index');
Route::get('player/add', 'PlayerController@add')->middleware('auth'); // move this above player/{player}
Route::get('player/{player}', 'PlayerController@view'); // move this below player/add
Route::post('players', 'PlayerController@search');

It works :) Thank you very much!

So I need to sort my routes by when the function appears on the controller?

Laravel doesn't know that /add is not included in /{player}. That's why you need to put /add first, so it matches it first.

Another option is to define what {player} is..

Route::get('player/{player}', 'PlayerController@view')->where('player', '[0-9]+'); // if it's id, only digits

documentation

Of course, this flew right past my head :S