Support ⇒ Troubleshootings ⇒ ForumPermissions- Group Perms- unable to set as moderator ⇒ Community Forums ⇒ CPG Dragonfly™ CMS
Forum IndexTroubleshootings

ForumPermissions- Group Perms- unable to set as moderator Reply to topic


Im trying to assign a group as moderator over certain forums. I go to /admin.php?op=Forums&do=ug_auth&mode=group select the group, click look up group change the setting to is moderator for the forums needed and click submit. Page goes, I click return to return to group permissions. nothing changed. I am unsure as to why. I remember this being an issue a long time ago but was unable to find the thread. I am not finding any errors or issues in the debug information.

Fresh install of Df 9.4
CMS Version 9.4.0.0
PHP Version 5.6.25
MySQL Version 5.6.31 (client: mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $)
GD Version bundled (2.1.0 compatible)
CMS path /home/carlg/public_html/
Core path /home/carlg/public_html/includes/
Session save_path /home/carlg/tmp
Process Owner carlg (504)
File Owner carlg (504)
Group 516

debug info while on the permissions have been updated page:
admin/modules/forums/admin_ug_auth.php 0.0003 - LINE 19: SELECT COUNT(*) FROM bk_bbforums 0.0002 - LINE 173: SELECT * FROM bk_bbforums ORDER BY forum_order 0.0002 - LINE 186: SELECT * FROM bk_bbauth_access WHERE group_id = '6' 0.0019 - LINE 286: SELECT u.user_id FROM bk_bbauth_access aa, bk_bbuser_group ug, bkuser_users u WHERE ug.group_id = aa.group_id AND u.user_id = ug.user_id AND u.user_level NOT IN (3, 2) GROUP BY u.user_id HAVING SUM(aa.auth_mod) > 0 0.0005 - LINE 335: SELECT u.user_id FROM bkuser_users u LEFT JOIN bk_bbuser_group ug ON ug.user_id = u.user_id LEFT JOIN bk_bbauth_access aa ON aa.group_id = ug.group_id WHERE u.user_level NOT IN (1, 2) GROUP BY u.user_id HAVING SUM(aa.auth_mod) = 0

debug info for after i am returned to the group permissions page:
admin/modules/forums/admin_ug_auth.php 0.0009 - LINE 19: SELECT COUNT(*) FROM bk_bbforums 0.0004 - LINE 657: SELECT group_id, group_name FROM bk_bbgroups WHERE group_single_user <> 1

What am I missing?

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Multiple Setups


Exactly the same problem! Also same thing on assign User as moderator as assign Group - exactly.

Everything seems to work, it displays success, but redisplay the moderator/forum and nothing has changed. Looking through debug code on successful confirmation page there is no UPDATE command being executed!

Interestingly Unsetting a User (ie. changing to 'Is Not Moderator') works fine! (I didn't have any Groups as Moderator, so could not test if Unset works in that case.)

DF 9.4

Note existing Users already set as Moderators are operating fine, it just I couldn't add the new one yesterday.

Worst case: Which db file needs to be set to do it manually?

TIA!

Pro_News CM™ - Content Management for Dragonfly CMS™

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Linux / 1.3.39 - 2.4.9 / 5.5.42 - 5.6.16 / 5.4.37 - 5.5.11 / 9.4


This has been a bug for a while earlier vrs did not do this
however their is a workaround we have been using...
I will see if i can find it

Dragonfly 9.4 Running on PHP 7.x + MariaDB
dragonfly9php7support.com/

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
PHP Version 7.0.6 + MariaDB + Dragonfly 9.4 Modified


Go To:

User Forum Permissions
Username: XXXXXXXX

Advance Mode>>>

Set "Post Files" > ON

Then you can add as moderator


SAME Goes for >>> Group Forum Permissions

Last to do:

Clear (delete) Your Cache

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
PHP Version 7.0.6 + MariaDB + Dragonfly 9.4 Modified

Last edited by bulldog500 on Mon Sep 05, 2016 11:21 pm; edited 2 times in total


I am unable to do that.
Doesnt give the option.
puu.sh/r1kVS/c0f5c41e5a.png

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Multiple Setups


Unusual Configuration for Your Forums

Try this:

Temp re-config the forum(s) in question to allow something like maybe (posting files)or(poll create)

then you will have an option > select to yes (ON) and submit
then change to is-moderator and submit
then re-set your forum back to where you had it

Then manually delete your cache specifically (Forums_forum_moderators.php)


The reason you need to delete cache manually is that for years now the bug was this line

Cache::array_delete('forum_moderators', 'Forums');

in

admin_ug_auth.php
The line to delete cache Never executes because
it should be before the:

message_die(GENERAL_MESSAGE, $message);


.......

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
PHP Version 7.0.6 + MariaDB + Dragonfly 9.4 Modified

Last edited by bulldog500 on Tue Sep 06, 2016 9:47 pm; edited 1 time in total


that screenshot is how thatsection of the page is by default, except the color change. its a fresh install. so only css has been changed.

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Multiple Setups


Problem found!

in admin/modules/forums/admin_ug_auth.php
- $change_mod_list[$forum_id]['auth_mod'] + $change_mod_list[$forum_id]

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Fedora 25 / Apache 2.4.27 / MariaDB 10.1.26 / PHP 7.1.10 / Mercurial

Last edited by DJ Maze on Tue Jan 16, 2018 5:26 am; edited 1 time in total


Fantastic !!!!!
This has been a bug for years now

I have a site with 20 or so admins throughout forums
I will test file out>>

Thank You

DJ Maze,
If 9.4 were updated it would be great.
Attachment: admin_ug_auth.rar
Description File With changes
Filename admin_ug_auth.rar
Filesize 6.12 KiB
Downloaded 9 Time(s)
You are not allowed to view/download this attachment

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
PHP Version 7.0.6 + MariaDB + Dragonfly 9.4 Modified

Last edited by bulldog500 on Wed Sep 07, 2016 11:41 am; edited 4 times in total


Yes it works for me!

bulldog500 workaround only works for Forums set as Private, as then the individual permissions are available to tweak.

With this fix though, you are likely going to run into Open Bug 1155 (List of Moderators doesn't Update).

Attached is my own solution to this. May not be the most elegant way, but it works, and would be very rarely executed on the average site. Code below includes both 1155 and DJ Maze's fix from above.

It used to work fine in DF 9.2.1, but was broken in 9.4 (I skipped everything in between - long story!).

But thanks to everyone for their quick response, dug me out of a hole!
Attachment: admin_ug_auth.php.zip
Description Above fix plus Bug 1155
Filename admin_ug_auth.php.zip
Filesize 6.08 KiB
Downloaded 3 Time(s)
You are not allowed to view/download this attachment

Pro_News CM™ - Content Management for Dragonfly CMS™

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Linux / 1.3.39 - 2.4.9 / 5.5.42 - 5.6.16 / 5.4.37 - 5.5.11 / 9.4


Check Line about 359: In Original 9.4.xxx File

- message_die(GENERAL_MESSAGE, $message); Cache::array_delete('forum_moderators', 'Forums'); + message_die(GENERAL_MESSAGE, $message);
This was corrected in MY upload.

This updates List of Moderators in ALL cases: NO Update Bug
Attachment: admin_ug_auth.zip
Description This is in ZIP Format<br /> Same file as my post above
Filename admin_ug_auth.zip
Filesize 6.35 KiB
Downloaded 8 Time(s)
You are not allowed to view/download this attachment

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
PHP Version 7.0.6 + MariaDB + Dragonfly 9.4 Modified

Last edited by bulldog500 on Wed Sep 07, 2016 2:22 pm; edited 5 times in total


I've pushed the changes to the SCM at bitbucket.org/dragonfl...f85/?at=v9

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Fedora 25 / Apache 2.4.27 / MariaDB 10.1.26 / PHP 7.1.10 / Mercurial

Last edited by DJ Maze on Wed Sep 07, 2016 6:32 pm; edited 1 time in total


Thank You

Dragonfly 9.4 Running on PHP 7.x + MariaDB
dragonfly9php7support.com/

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
PHP Version 7.0.6 + MariaDB + Dragonfly 9.4 Modified


@bulldog500, Thanks again. Hadn't seen that, I just added DJ Maze's fix to my existing module (along with its clumsy correction) Wink

I've now switched to your/the released version!

Pro_News CM™ - Content Management for Dragonfly CMS™

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Linux / 1.3.39 - 2.4.9 / 5.5.42 - 5.6.16 / 5.4.37 - 5.5.11 / 9.4


very nice thanks very much

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Multiple Setups

All times are UTC


Jump to: