laravel-permission: [5.9.0] Artisan migrate throwing QueryException

After latest update to 5.9.0, php artisan migrate / migrate:fresh is throwing Query Exception.

SQLSTATE[42000]: Syntax error or access violation: 1166 Incorrect column name ‘’ (SQL: create table model_has_permissions (`` bigint unsigned not null, model_type varchar(255) not null, model_id bigint unsigned not null) default character set utf8mb4 collate ‘utf8mb4_unicode_ci’)

Laravel: 9.50.2 Permission package: 5.9.0 PHP: 8.1 DB: mariadb 10.5

Steps to reproduce the behavior:

Create fresh Laravel App
composer require spatie/laravel-permission
Add HasRoles to User
php artisan migrate -> Query Exception

When permissions package is locked to 5.8.0, no QueryException is thrown.

About this issue

Original URL
State: closed
Created a year ago
Comments: 23 (4 by maintainers)

Most upvoted comments

Same here. Clearing cache and performing a fresh migration does not solve the issue. For now, pin the version to 5.8.0 and it will work fine again.

ahoiroman on Feb 6, 2023

v5.9.1 reverted the change.

drbyte on Feb 6, 2023

Hi, can somebody test this commit on 5.9.0 https://github.com/erikn69/laravel-permission/commit/09088c00756bfd2d71bea3f4d6f67fccba895ba5, maybe that fix it

erikn69 on Feb 6, 2023

Hey All. I appreciate all those who tested the reset/refresh cache option and I can personally also confirm it does not work. As @ahoiroman specified, lock your version to 5.8.0 until this is resolved. In my case I did the following in my composer.json file "spatie/laravel-permission": "<5.7",

@mrtorks Unfortunately did not work for me, still have the same issue for 5.7 and 5.8

@AhmedMub perhaps @erikn69 solution might work for you.

mrtorks on Feb 6, 2023

I can confirm alongside @alfinauzikri That @erikn69 's solution works. I tested it on a fresh project using 5.9.0. Great Job all around. @erikn69 I think a PR is warranted.

mrtorks on Feb 6, 2023

@erikn69 you’re correct. The problem started after the last push to spatie:main 2 hours ago

AhmedMub on Feb 6, 2023

Same issue noticed. There is nothing to clear in cache for permissions.

In migration file, the “PermissionRegistrar” class is not instantiated and hence its constructor is not being called & no value set for its static variable $pivotPermission. Hence the migration query showing a blank column name while creating table “model_has_permissions”

ashvin-php on Feb 6, 2023

I confirm the same error here. Can’t run the package migration for 5.9.0.

daniel-cintra on Feb 6, 2023