[Split] PHP warnings when I search myself in permissions

[harryk]

Hi,

I know the topic is old but there was no solution and I had the same issue.

7 is "ROLE_USER_LIMITED" in phpbb_acl_roles. That seems to be left over in some changes. When you select your settings with your user_id, you should see group_id=7

Code: Select all

SELECT *
FROM phpbb_user_group
WHERE user_pending = 0 AND user_id = <your user_id>

You can delete 7 from phpbb_user_group

Code: Select all

DELETE FROM phpbb_user_group WHERE user_id = <your user_id> AND group_id = 7;

If you want a revertable way, export the table row before deleting:

Code: Select all

SELECT * FROM phpbb_user_group WHERE user_id = <your user_id>;

Regards
Harald

[Brf]

Roles and Groups are not the same thing.
Group 7 is the Newly Registered users. Do not delete that from phpbb_user_group.

[harryk]

In our forum, it's 155, not 7. That may be cause by a plugin which relaced 7 with 155.

[Brf]

If your newly registered users group is 155, then your groups are numbered improperly. The groups table is set to auto-increment from 1, by 1, and Newly registered Users is the 7th group added, so it should always be 7.

[thecoalman]

The Group ID's will depend on the history of the forum. Mine all start low 800's but it goes back to phpBB2 install. Not sure why the high numbers but even if you look at the team page here the only one single digits is the Developers group which is 4. Customization team on the other hand is 6 digits.

[Brf]

The Group ID's will depend on the history of the forum.

The single-digit ones would be for new installs. The conversion from phpBB-2 or 3.0 would add the NRU group at the end. Sometimes we see boards, like these two, where the NRU group has a high number, but the user_group table is using the wrong number. I do not know why that would be since the vanilla code looks up the actual group's number when adding a new user to the user_group table.

[harryk]

Hello Brf,

the group management is pretty complex. Can you provide a repair script in SQL or PHP?

Regards
Harald