Relation requests ID from database

Need Help
#1

I configured a relation like this:

fields.yaml

        contributors:
[...]
            type: relation
            useController: true

config_relation

contributors:
    view:
        list: $/<namespace>/<plugin>models/<nameofmyrelation>/columns.yaml
        showCheckboxes: false

columns.yaml

columns:
    player_id:
        type: number
        clickable: false

    player:
        type: text
        relation: player
        select: playername
        clickable: false

Relation within Submission Model

    public $belongsToMany = [
        'players' => [
            Player::class,
            'table' => 'rel_submissions_players',
            'order' => 'playername',
            'timestamps' => true
        ]
]

When I try to edit one of the records in the backend, the following error message appears:
"SQLSTATE[42S22]: Column not found: 1054 Unknown column 'id' in 'field list' ...

Since this is a simple relation I just have the player_id and submission_id in the table and created_at as a date, but for some reason, also a basic id field is within the query.

Why? I thought it’s the checkbox, so I disabled them.
I also thought it’s the link, so I disabled clickable.

Those records do not need to be opened. A display would be enough. But how can I solve this ID problem without creating an id column.

I’m also absolutly sure this worked a few weeks ago… not sure if something changed here in October 3.

Thanks for any help ^^

#2

Hey @LordRazen

Can you share the player relation definition in the model?

#3

Relation within Submission Model

    public $belongsToMany = [
        'players' => [
            Player::class,
            'table' => 'rel_submissions_players',
            'order' => 'playername',
            'timestamps' => true
        ]
]

(There’re also timestamps within this relation table. Didnt think this matters so far)

#4

I’ve added an equivalent test to the test plugin and it seems to be working here: