Register forum user name Search FAQ

Gammon Forum

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

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 topic:           Search the forum


[Go to top] top

Information and images on this site are licensed under the Creative Commons Attribution 3.0 Australia License unless stated otherwise.