Notice: Any messages purporting to come from this site telling you that your password has expired, or that you need to "verify" your details, making threats, or asking for money, are
spam. We do not email users with any such messages. If you have lost your password you can obtain a new one by using the
password reset link.
Entire forum
➜ Forum software
➜ Administration
➜ Possible Bug
It is now over 60 days since the last post. This thread is closed.
Refresh page
| Posted by
| Kris
USA (198 posts) Bio
|
| Date
| Fri 22 Aug 2003 07:21 PM (UTC) Amended on Fri 22 Aug 2003 07:23 PM (UTC) by Kris
|
| Message
| When editing a forum user's profile, take notice of the dropdown menu for 'moderator'. It defaults to the first section; it doesn't give any options for something like '(no section)'. I have someone who was set as moderator of a section, and now I can't disable that access without blocking the user entirely. As far as I can tell, no moderator topic has been set for this user within that or any other section; looks like he has access to the whole section from what I can tell.
If that's a bug, could you suggest a fix? If not, how would I go about making this guy no longer a moderator of the entire 'Announcements' section on my forum (without having to make him the moderator of a different section instead)? I'd like to get that quietly disabled before he realizes he still has that sort of access =)
| | Top |
|
| Posted by
| Nick Gammon
Australia (23,052 posts) Bio
Forum Administrator |
| Date
| Reply #1 on Fri 22 Aug 2003 09:57 PM (UTC) |
| Message
| It's a set-up issue. Both the section and topic tables (bbsection and bbtopic) need an entry for "no section" and "no topic".
Using straight SQL (execute SQL command, or the command-line mySQL) you could enter this:
INSERT INTO bbsection (bbsection_id, section_name) VALUES (0, '(no section)')
Then do:
SELECT * FROM bbsection
You should see your "no section" as bbsection_id of zero. However if auto_increment is on, it ignores the zero, and puts it in as the next sequential number. You don't want that, so if this is the case, make a note of the number (say it is 42) and then do this:
UPDATE bbsection SET bbsection_id = 0 WHERE bbsection_id = 42
That will correct the id from 42 to 0.
Then do the same for bbtopic:
INSERT INTO bbtopic (bbtopic_id, bbsection_id, topic_name) VALUES (0, 0, '(no topic)')
Then do:
SELECT * FROM bbtopic
Again, if the new entry for "no topic" is not bbtopic_id of zero (but is, say 88) do this:
UPDATE bbtopic SET bbtopic_id = 0 WHERE bbtopic_id = 88
|
- Nick Gammon
www.gammon.com.au, www.mushclient.com | | Top |
|
The dates and times for posts above are shown in Universal Co-ordinated Time (UTC).
To show them in your local time you can join the forum, and then set the 'time correction' field in your profile to the number of hours difference between your location and UTC time.
13,548 views.
It is now over 60 days since the last post. This thread is closed.
Refresh page
![[Go to top]](/images/gototop.gif)
top