weird error in middleware when using select2_from_ajax with FetchOperation

[prescriptionlifeline]

In my UserCrudController I have this field:

        CRUD::field([
            'name' => 'spouse',
            'label' => 'Spouse',
            'type' => 'select2_from_ajax',
            'entity' => 'spouse',
            'attribute' => 'lastNameFirstName',
            'data_source' => backpack_url('user/fetch/spouse'),
            'method' => 'POST',
        ]);

(lastNameFirstName is a generated column).

Here's the FetchOperation method I added to the Crud controller:

    protected function fetchSpouse()
    {
        return $this->fetch([
            'model' => User::class, // required
            'searchable_attributes' => ['lastNameFirstName'],
            'paginate' => 10, // items to show per page
            'searchOperator' => 'LIKE',
            'query' => function($model) {
                return $model->withTrashed();
            } // to filter the results that are returned
        ]);
    }

Here's the method in my User model:

    public function spouse()
    {
        return $this->hasOne(User::class, 'spouseID');
    }

Anyway, when I add a spouse and hit the Save button I get an error from one of the middleware I've defined in config/backpack/base.php, which doesn't make any sense to me. In particular, I'm getting this error:

[array_key_exists(): Argument #2 ($array) must be of type array, string given](https://mywebsite.com/admin/user/21#top)

Here's the middleware that's giving that error:

https://github.com/Laravel-Backpack/CRUD/blob/6.7.15/src/app/Http/Middleware/CheckIfAdmin.php

It's the return $next($request); line in handle(), in particular, that's giving that error.

If I leave the Spouse field blank I don't get that error - I only get it if I fill that field in.

Any ideas?

[pxpm]

@prescriptionlifeline When that error throws, you have a Vendor Frames dropdown on the left menu of the error page.

Open that dropdown and there you can find where the error is actually thrown. The fact that it shows that middleware is because Backpack stack is initialized in a middleware.

Alternatively you can click on the top righ "Share", and share the full error report with us.

Let me know if that helps.

[prescriptionlifeline]

It does not. In fact, I get the same exact error.

My User model:

<?php

namespace App\Models;

use Backpack\CRUD\app\Models\Traits\CrudTrait;
// use Illuminate\Contracts\Auth\MustVerifyEmail;
use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Foundation\Auth\User as Authenticatable;
use Illuminate\Notifications\Notifiable;
use Laravel\Sanctum\HasApiTokens;
use Illuminate\Auth\Notifications\VerifyEmail;
use Illuminate\Database\Eloquent\SoftDeletes;
use Illuminate\Database\Eloquent\Casts\Attribute;

class User extends Authenticatable
{
    use CrudTrait;
    use HasApiTokens, HasFactory, Notifiable, SoftDeletes;

    protected $appends = ['last_first_name'];

    /**
     * The attributes that are mass assignable.
     *
     * @var array<int, string>
     */
    protected $fillable = [
        'name',
        'firstName',
        'lastName',
        'email',
	'password',
	'isAdmin',
        'phoneCell',
        'phoneHome',
        'phoneWork',
        'address',
        'city',
        'state',
        'zip',
        'notes',
        'uniformAgreement',
        'spouseID',
    ];

    /**
     * The attributes that should be hidden for serialization.
     *
     * @var array<int, string>
     */
    protected $hidden = [
        'password',
        'remember_token',
    ];

    /**
     * The attributes that should be cast.
     *
     * @var array<string, string>
     */
    protected $casts = [
        'email_verified_at' => 'datetime',
        'password' => 'hashed',
    ];

    protected static function booted()
    {
        static::creating(function ($user) {
            $user->password = '';
            $user->name = $user->firstName . ' ' . $user->lastName;
        });
        static::updating(function ($user) {
            $user->name = $user->firstName . ' ' . $user->lastName;
        });
        static::created(function ($user) {
            $password = generateRandomString(8);
            $user->password = $password;
            $user->save();

            VerifyEmail::createUrlUsing(fn() => $password);
            $user->sendEmailVerificationNotification();

            return $user;
        });
    }

    public function currentDues()
    {
        return $this->hasOne(Dues::class, 'userId')->where('year', date('Y'));
    }

    public function spouse()
    {
        return $this->hasOne(User::class, 'spouseID');
    }

    protected function lastFirstName(): Attribute
    {
        return Attribute::make(
            get: fn (mixed $value, array $attributes) => $attributes['lastName'] . ', ' . $attributes['firstName'],
        );
    }
}

My new CRUD field:

        CRUD::field([
            'name' => 'spouse', 
            'label' => 'Spouse',
            'type' => 'select2_from_ajax',
            'entity' => 'spouse',
            'attribute' => 'last_first_name',
            'data_source' => backpack_url('user/fetch/spouse'),
            'method' => 'POST',
            'fake' => false,
        ]);

(I've tried it with and without 'fake' => false, and that doesn't make a difference)

And my new FetchOperation:

    protected function fetchSpouse()
    {
        return $this->fetch([
            'model' => User::class,
            'query' => function($model) {
                $search = request()->input('q') ?? false;
                if ($search) {
                    return $model->withTrashed()->whereRaw('CONCAT(`lastName`,", ",`firstName`) LIKE "' . $search . '%"');
                }else{
                    return $model->withTrashed();
                }
            },
            'searchable_attributes' => []
        ]);
    }

[prescriptionlifeline]

For pretty much every other CRUD field the name attribute corresponds to the column name. In my case the column name is spouseID. If I set the name attribute to that vs spouse I get this error:

Call to undefined method App\Models\User::spouseID()

It may be related with the fact that your column doesn't "exist" in the database ?

That seems hard to imagine since it shouldn't even be writing to that column. The only column that this CRUD field should be updating is the spouseID column.

[prescriptionlifeline]

The issue is present even if I do it with a single field vs some sort of emulated field. For good measure I also updated every composer package I have. At this point I am increasingly convinced that this is a bug, hence this new bug report against backpack/crud:

Laravel-Backpack/CRUD#5630

[prescriptionlifeline]

The solution was to change my relationship in my User model:

public function spouse()
{
-    return $this->hasOne(User::class, 'spouse_id');
+    return $this->belongsTo(User::class, 'spouse_id');
}