Unable to PM groups anymore, since 3.0.4 upgrade. Pls Help

Get help with installation and running phpBB 3.0.x here. Please do not post bug reports, feature requests, or MOD-related questions here.
Scam Warning
Forum rules
END OF SUPPORT: 1 January 2017 (announcement)
sp3ctre
Registered User
Posts: 307
Joined: Sun Jul 15, 2007 11:06 am

Re: Unable to PM groups anymore, since 3.0.4 upgrade. Pls Help

Post by sp3ctre »

Ok, I have an update.

I created a fresh installation of PHPBB and copied over the config.php file so it looked at the broken installation.

I went into the control panel, cleared the cache (which I had not previously done!) and went to check the permissions.

It is exactly the same, I cant PM groups.

This must mean it's something in the DB. Can anyone assist me with debugging this please, as it's confusing the hell out of me?

Thanks

Jim
User avatar
DavidIQ
Customisations Team Leader
Customisations Team Leader
Posts: 17413
Joined: Thu Jan 06, 2005 1:30 pm
Location: Fishkill, NY
Name: David Colón
Contact:

Re: Unable to PM groups anymore, since 3.0.4 upgrade. Pls Help

Post by DavidIQ »

Try running these queries and see if anything comes up:

Code: Select all

SELECT * FROM phpbb_acl_groups WHERE auth_option_id IN (SELECT auth_option_id FROM phpbb_acl_options WHERE auth_option = 'u_masspm_group') AND auth_setting = 0

Code: Select all

SELECT * FROM phpbb_acl_roles_data WHERE auth_option_id IN (SELECT auth_option_id FROM phpbb_acl_options WHERE auth_option = 'u_masspm_group') AND auth_setting = 0

Code: Select all

SELECT * FROM phpbb_acl_users WHERE auth_option_id IN (SELECT auth_option_id FROM phpbb_acl_options WHERE auth_option = 'u_masspm_group') AND auth_setting = 0
Apply to become a Jr. Extension Validator
My extensions | In need of phpBB services? | Was I helpful today?
No unsolicited PMs unless you're planning on asking for paid help.
sp3ctre
Registered User
Posts: 307
Joined: Sun Jul 15, 2007 11:06 am

Re: Unable to PM groups anymore, since 3.0.4 upgrade. Pls Help

Post by sp3ctre »

DavidIQ wrote:Try running these queries and see if anything comes up:

Code: Select all

SELECT * FROM phpbb_acl_groups WHERE auth_option_id IN (SELECT auth_option_id FROM phpbb_acl_options WHERE auth_option = 'u_masspm_group') AND auth_setting = 0
No rows returned

Code: Select all

SELECT * FROM phpbb_acl_roles_data WHERE auth_option_id IN (SELECT auth_option_id FROM phpbb_acl_options WHERE auth_option = 'u_masspm_group') AND auth_setting = 0
8,19,0

Code: Select all

SELECT * FROM phpbb_acl_users WHERE auth_option_id IN (SELECT auth_option_id FROM phpbb_acl_options WHERE auth_option = 'u_masspm_group') AND auth_setting = 0
No rows returned


Thanks for the reply DavidIQ. Any idea what's happened?

J
User avatar
DavidIQ
Customisations Team Leader
Customisations Team Leader
Posts: 17413
Joined: Thu Jan 06, 2005 1:30 pm
Location: Fishkill, NY
Name: David Colón
Contact:

Re: Unable to PM groups anymore, since 3.0.4 upgrade. Pls Help

Post by DavidIQ »

EDIT: hold that thought...
Apply to become a Jr. Extension Validator
My extensions | In need of phpBB services? | Was I helpful today?
No unsolicited PMs unless you're planning on asking for paid help.
sp3ctre
Registered User
Posts: 307
Joined: Sun Jul 15, 2007 11:06 am

Re: Unable to PM groups anymore, since 3.0.4 upgrade. Pls Help

Post by sp3ctre »

DavidIQ wrote:UPDATE phpbb_acl_roles_data SET auth_setting = 1 WHERE auth_option_id IN (SELECT auth_option_id FROM phpbb_acl_options WHERE auth_option = 'u_masspm_group')
Hi David,

I checked all the roles and none of them are set to never.

I then ran your script and then cleared the cache... still having the problem though. Very weird! Anything else I can check, or other SQL's to run?

Thanks
Last edited by sp3ctre on Fri Mar 20, 2009 12:09 am, edited 1 time in total.
sp3ctre
Registered User
Posts: 307
Joined: Sun Jul 15, 2007 11:06 am

Re: Unable to PM groups anymore, since 3.0.4 upgrade. Pls Help

Post by sp3ctre »

I am still very confused how the trace says I should have the permissions, yet the user permissions list says "never"?
sp3ctre
Registered User
Posts: 307
Joined: Sun Jul 15, 2007 11:06 am

Re: Unable to PM groups anymore, since 3.0.4 upgrade. Pls Help

Post by sp3ctre »

I just ran the following (119 is the code for u_masspm_group)

Code: Select all

SELECT * FROM phpbb_acl_roles_data WHERE auth_option_id = 119
It returned 5 rows, all with auth_setting set to 1.

Surely this must mean that none of the roles have it set to never?
User avatar
Anon
Former Team Member
Posts: 7019
Joined: Fri Jan 02, 2004 7:33 am
Location: Christchurch, New Zealand

Re: Unable to PM groups anymore, since 3.0.4 upgrade. Pls Help

Post by Anon »

Hi there

When possible, please use the edit function rather than having multiple replies in succession. If you have new info you can edit your post, and remember that replying to bump up your topic isn't allowed if it's less than 6 hours since your latest reply

Thanks :)
sp3ctre
Registered User
Posts: 307
Joined: Sun Jul 15, 2007 11:06 am

Re: Unable to PM groups anymore, since 3.0.4 upgrade. Pls Help

Post by sp3ctre »

HI,

Sorry, I did mean to edit the post, it was not intentional. It was not, however, to bump the topic, as I was told to run some SQL and was reporting my findings, hence I thought I was in dialogue with David so no need to bump.

I really am stuck with this... so any help would be appreciated.
User avatar
DavidIQ
Customisations Team Leader
Customisations Team Leader
Posts: 17413
Joined: Thu Jan 06, 2005 1:30 pm
Location: Fishkill, NY
Name: David Colón
Contact:

Re: Unable to PM groups anymore, since 3.0.4 upgrade. Pls Help

Post by DavidIQ »

Sorry...had hoped you hadn't seen my note on updating the roles table prior to me removing it and then I had to leave...

You've checked all tables involved in this and none of them have the permissions set to "never" so I'm pretty stumped. You said you purged your forum's cache already?

See what this returns:

Code: Select all

SELECT g.group_name, ag.* FROM phpbb_acl_groups ag 
JOIN phpbb_groups g ON g.group_id = ag.group_id
WHERE ag.auth_option_id IN (SELECT auth_option_id FROM phpbb_acl_options WHERE auth_option = 'u_masspm_group')

Code: Select all

SELECT r.role_name, rd.* FROM phpbb_acl_roles_data rd
JOIN phpbb_acl_roles r ON r.role_id = rd.role_id
WHERE auth_option_id IN (SELECT auth_option_id FROM phpbb_acl_options WHERE auth_option = 'u_masspm_group')

Code: Select all

SELECT u.username, au.* FROM phpbb_acl_users au
JOIN phpbb_users u ON u.user_id = au.user_id
WHERE auth_option_id IN (SELECT auth_option_id FROM phpbb_acl_options WHERE auth_option = 'u_masspm_group')
Apply to become a Jr. Extension Validator
My extensions | In need of phpBB services? | Was I helpful today?
No unsolicited PMs unless you're planning on asking for paid help.
sp3ctre
Registered User
Posts: 307
Joined: Sun Jul 15, 2007 11:06 am

Re: Unable to PM groups anymore, since 3.0.4 upgrade. Pls Help

Post by sp3ctre »

DavidIQ wrote:Sorry...had hoped you hadn't seen my note on updating the roles table prior to me removing it and then I had to leave...

You've checked all tables involved in this and none of them have the permissions set to "never" so I'm pretty stumped. You said you purged your forum's cache already?

See what this returns:

Code: Select all

SELECT g.group_name, ag.* FROM phpbb_acl_groups ag 
JOIN phpbb_groups g ON g.group_id = ag.group_id
WHERE ag.auth_option_id IN (SELECT auth_option_id FROM phpbb_acl_options WHERE auth_option = 'u_masspm_group')

Results:
Z4 Mods  		33  	0  	119  	0  	1
ADMINISTRATORS  	38  	0  	119  	0  	1

Code: Select all

SELECT r.role_name, rd.* FROM phpbb_acl_roles_data rd
JOIN phpbb_acl_roles r ON r.role_id = rd.role_id
WHERE auth_option_id IN (SELECT auth_option_id FROM phpbb_acl_options WHERE auth_option = 'u_masspm_group')

Results:
ROLE_USER_FULL  	5  	119  	1
ROLE_USER_STANDARD 	6 	119 	1
ROLE_USER_LIMITED 	7 	119 	1
ROLE_USER_NOPM 		8 	119 	1
ROLE_USER_NOAVATAR 	9 	119 	1

Code: Select all

SELECT u.username, au.* FROM phpbb_acl_users au
JOIN phpbb_users u ON u.user_id = au.user_id
WHERE auth_option_id IN (SELECT auth_option_id FROM phpbb_acl_options WHERE auth_option = 'u_masspm_group')

Results:
dark horse  	18  	0  	119  	0  	1
Thanks David,

I have added the results above. The "Dark Horse" users was a test user I used to add the permission to. This user is experiencing the same problem, but my other user didnt appear in the results (although the other user is an admin)
User avatar
DavidIQ
Customisations Team Leader
Customisations Team Leader
Posts: 17413
Joined: Thu Jan 06, 2005 1:30 pm
Location: Fishkill, NY
Name: David Colón
Contact:

Re: Unable to PM groups anymore, since 3.0.4 upgrade. Pls Help

Post by DavidIQ »

Can you try purging your forum cache again and try sending a PM to a group?
Apply to become a Jr. Extension Validator
My extensions | In need of phpBB services? | Was I helpful today?
No unsolicited PMs unless you're planning on asking for paid help.
sp3ctre
Registered User
Posts: 307
Joined: Sun Jul 15, 2007 11:06 am

Re: Unable to PM groups anymore, since 3.0.4 upgrade. Pls Help

Post by sp3ctre »

DavidIQ wrote:Can you try purging your forum cache again and try sending a PM to a group?
I purged the cache again but I don't get the option to PM to a group, there is no group drop down box.
User avatar
DavidIQ
Customisations Team Leader
Customisations Team Leader
Posts: 17413
Joined: Thu Jan 06, 2005 1:30 pm
Location: Fishkill, NY
Name: David Colón
Contact:

Re: Unable to PM groups anymore, since 3.0.4 upgrade. Pls Help

Post by DavidIQ »

Are any of your groups set to be able to receive PMs?
Apply to become a Jr. Extension Validator
My extensions | In need of phpBB services? | Was I helpful today?
No unsolicited PMs unless you're planning on asking for paid help.
sp3ctre
Registered User
Posts: 307
Joined: Sun Jul 15, 2007 11:06 am

Re: Unable to PM groups anymore, since 3.0.4 upgrade. Pls Help

Post by sp3ctre »

DavidIQ wrote:Are any of your groups set to be able to receive PMs?
Yes, the Registered users group (and some of the the others) has "Group able to receive private messages" ticked.
Locked

Return to “[3.0.x] Support Forum”