Possible Bug

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 =)

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