Skip to content

Adding ability with MYSQL 9 #667

@justasSendrauskas

Description

@justasSendrauskas

When trying to add ability with:
Bouncer::allow('some-viewer')->to('view-something')

the query dies with
Column not found: 1054 Unknown column 'entity_type' in 'where clause' (Connection: mysql, SQL: select * from abilities where ``.entity_type is null and `name` in (view-something) and (`abilities`.`scope` is null))

the column is there but it builds query with ''.'entity_type'.

However adding Bouncer::allow('some-viewer')->to('view-something', '*') seems to fix the issue.

But other methods like $this->can('admin', User::class) die with the same error where reference of the table is an empty string:
''.'name' in (admin, *)

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions