The permission role "" unexpectedly does not exist

Get help with installation and running phpBB 3.3.x here. Please do not post bug reports, feature requests, or extension related questions here.
goldencoin5
Registered User
Posts: 43
Joined: Tue May 14, 2013 9:04 pm

The permission role "" unexpectedly does not exist

Post by goldencoin5 »

whenever i try to reinstall majority of my extensions on my board Version: 3.3.4, getting following error in ACP:

Code: Select all

[phpBB Debug] PHP Warning: in file [ROOT]/phpbb/db/migration/tool/permission.php on line 428: Trying to access array offset on value of type bool
[phpBB Debug] PHP Warning: in file [ROOT]/phpbb/db/migration/tool/permission.php on line 429: Trying to access array offset on value of type bool

Code: Select all

The permission role "" unexpectedly does not exist.
whereas live board is running perfectly with the same extensions since board was upgraded from 3.3.3 to 3.3.4
apparently i did not delete any of the active permission roles to my remembrance.
can't figure it out why its happening?
guidance required

Using:
Server version: 10.5.12-MariaDB-0+deb11u1 - Debian 11
Protocol version: 10
Apache
Database client version: libmysql - mysqlnd 8.0.11
PHP extension: mysqli curl mbstring
PHP version: 8.0.11 FPM
PHPBB board Version: 3.3.4
User avatar
stevemaury
Support Team Member
Support Team Member
Posts: 52767
Joined: Thu Nov 02, 2006 12:21 am
Location: The U.P.
Name: Steve
Contact:

Re: The permission role "" unexpectedly does not exist

Post by stevemaury »

Export your acl_roles and acl_roles_data tables and attach them here with a .txt extension.
I can stop all your spam. I can upgrade or update your Board. PM or email me. (Paid support)
goldencoin5
Registered User
Posts: 43
Joined: Tue May 14, 2013 9:04 pm

Re: The permission role "" unexpectedly does not exist

Post by goldencoin5 »

stevemaury wrote: Mon Oct 25, 2021 1:32 pm Export your acl_roles and acl_roles_data tables and attach them here with a .txt extension.
test enviroment:
from extension migrations, if i delete these two lines mentioned below containing 'ROLE_USER_STANDARD' and 'REGISTERED' i was able to get the problematic extension installed again.

// Add permissions sets

Code: Select all

['permission.permission_set', ['ROLE_USER_STANDARD', 'u_pm_mediaembed']],
['permission.permission_set', ['REGISTERED', 'u_pm_mediaembed', 'group']],
phpbb_acl_roles.txt
(1.63 KiB) Downloaded 20 times
phpbb_acl_roles_data.txt
(4.35 KiB) Downloaded 9 times
User avatar
Brf
Support Team Member
Support Team Member
Posts: 53379
Joined: Tue May 10, 2005 7:47 pm
Location: {postrow.POSTER_FROM}
Contact:

Re: The permission role "" unexpectedly does not exist

Post by Brf »

I am guessing those permissions are part of the media-embed extension.
goldencoin5
Registered User
Posts: 43
Joined: Tue May 14, 2013 9:04 pm

Re: The permission role "" unexpectedly does not exist

Post by goldencoin5 »

Brf wrote: Mon Oct 25, 2021 4:19 pm I am guessing those permissions are part of the media-embed extension.
its not a guess, its true
but i am getting the same issue upon reinstalling all other extensions containing 'ROLE_USER_STANDARD' and 'REGISTERED' in their migrations.

another examples:

Code: Select all

['permission.permission_set', ['REGISTERED', 'u_viewthanks', 'group', true]],
['permission.permission_set', ['ROLE_USER_STANDARD', 'u_viewthanks', 'role', true]],
and

Code: Select all

['permission.permission_set', ['REGISTERED', 'u_viewtoplist', 'group', true]],
['permission.permission_set', ['ROLE_USER_STANDARD', 'u_viewtoplist', 'role', true]],
User avatar
Brf
Support Team Member
Support Team Member
Posts: 53379
Joined: Tue May 10, 2005 7:47 pm
Location: {postrow.POSTER_FROM}
Contact:

Re: The permission role "" unexpectedly does not exist

Post by Brf »

That suggests that either the permission itself does not exist, or that the group and role do not exist.
User avatar
3Di
I've Been Banned!
Posts: 17538
Joined: Mon Apr 04, 2005 11:09 pm
Location: I'm with Ukraine 🇺🇦
Name: Marco
Contact:

Re: The permission role "" unexpectedly does not exist

Post by 3Di »

Please dump the table GROUPS and report.

SELECT * FROM phpbb_groups - change phpbb_ to your DB prefix in case.
🆓 Free support for our extensions also provided here: phpBB Studio
🚀 Looking for a specific feature or alternative option? We will rock you!
Please PM me only to request paid works. Thx. Buy me a coffee -> Image
My development's activity º PhpStorm's proud user º Extensions, Scripts, MOD porting, Update/Upgrades
goldencoin5
Registered User
Posts: 43
Joined: Tue May 14, 2013 9:04 pm

Re: The permission role "" unexpectedly does not exist

Post by goldencoin5 »

3Di wrote: Mon Oct 25, 2021 5:46 pm Please dump the table GROUPS and report.

SELECT * FROM phpbb_groups - change phpbb_ to your DB prefix in case.
phpbb_groups.txt
(1.33 KiB) Downloaded 10 times
goldencoin5
Registered User
Posts: 43
Joined: Tue May 14, 2013 9:04 pm

Re: The permission role "" unexpectedly does not exist

Post by goldencoin5 »

Brf wrote: Mon Oct 25, 2021 5:37 pm That suggests that either the permission itself does not exist, or that the group and role do not exist.
The permission role "" unexpectedly does not exist.

error itself is saying the issue, kindly suggest the possible solution
can't be able to find missing entry in tables still
User avatar
Brf
Support Team Member
Support Team Member
Posts: 53379
Joined: Tue May 10, 2005 7:47 pm
Location: {postrow.POSTER_FROM}
Contact:

Re: The permission role "" unexpectedly does not exist

Post by Brf »

If it is the Role, there should be a "User Role" called "Standard Features".
On it's Edit page, the "Role name" should say ROLE_USER_STANDARD
goldencoin5
Registered User
Posts: 43
Joined: Tue May 14, 2013 9:04 pm

Re: The permission role "" unexpectedly does not exist

Post by goldencoin5 »

Brf wrote: Mon Oct 25, 2021 8:08 pm If it is the Role, there should be a "User Role" called "Standard Features".
On it's Edit page, the "Role name" should say ROLE_USER_STANDARD
its already there
Untitled.png
Untitled.png
Untitled.png (7.48 KiB) Viewed 1066 times
User avatar
Brf
Support Team Member
Support Team Member
Posts: 53379
Joined: Tue May 10, 2005 7:47 pm
Location: {postrow.POSTER_FROM}
Contact:

Re: The permission role "" unexpectedly does not exist

Post by Brf »

Then perhaps the description is missing in your language file en/acp/permissions.php

Code: Select all

'ROLE_USER_STANDARD'		=> 'Standard Features',
goldencoin5
Registered User
Posts: 43
Joined: Tue May 14, 2013 9:04 pm

Re: The permission role "" unexpectedly does not exist

Post by goldencoin5 »

Untitled.png
Untitled.png (4.34 KiB) Viewed 1034 times
goldencoin5
Registered User
Posts: 43
Joined: Tue May 14, 2013 9:04 pm

Re: The permission role "" unexpectedly does not exist

Post by goldencoin5 »

Dug a little deeper, found no issue on 'ROLE_USER_STANDARD'
issue is coming through 'REGISTERED' group

have to delete this single line from migrations before reinstalling the extensions

Code: Select all

['permission.permission_set', ['REGISTERED', 'u_viewthanks', 'group', true]],
or

Code: Select all

['permission.permission_set', ['REGISTERED', 'u_pm_mediaembed', 'group']],
User avatar
3Di
I've Been Banned!
Posts: 17538
Joined: Mon Apr 04, 2005 11:09 pm
Location: I'm with Ukraine 🇺🇦
Name: Marco
Contact:

Re: The permission role "" unexpectedly does not exist

Post by 3Di »

As I suspected, I think you should replace your groups table with a valid backup of it (looking at the file you posted).
🆓 Free support for our extensions also provided here: phpBB Studio
🚀 Looking for a specific feature or alternative option? We will rock you!
Please PM me only to request paid works. Thx. Buy me a coffee -> Image
My development's activity º PhpStorm's proud user º Extensions, Scripts, MOD porting, Update/Upgrades
Post Reply

Return to “[3.3.x] Support Forum”