UBB.Developers Forums UBB.threads 7 Development How Do I? can't add moderators.....?

says they're added but they don't show up and there rights don't work!

originally a UBB.classic board, went to UBBT5, then UBBT6.0, now at UBBT 6.1 with Blams templates

http://www.audi-sport.net

You need to assign the moderators to specific forums..... select "Assign a Moderator" from the "Admin" menu. Then they will have Mod "powers" in the forums they are assigned to.

Hope that helps!

yeah no I'm not that daft
that doesn't work for some reason..........

how are the mod listings actually stored, I mean could I go into the database and manually add them?

I'm not sure. I stay clear of the Database as much as possible.

What powers do they not have. Does the "edit" button not appear for them in their forums... No Admin menu?

the admin menu says they have moderator powers but they see no admin menu, they don't show up in the mod listing for the forums they are supposed to have been selected to moderate and they can't edit stuff either

You might look at this post. Those queries may help you see how moderators are stored in the database. There are several tables involved.

Did you just do all those upgrades now? Or were they done over a period of time?

upgrades have been done over a period of time..
am I the only one having this problem?
it's very annoying as it's a staandard feature in a complete version that has never worked for me?

so any ideas?????

If they don't see the admin menu, then you might try checking their U_Status field. You can do this with a sql query:

SELECT U_Status FROM w3t_Users WHERE U_Username='username'

tried that, they come up as moderators but they can't edit a thing!

Is this a problem you've had all along, or did it start with your latest upgrade?

Did you look at the queries in the link I posted above? That shows you how the moderators are stored in the database.

it's a problem I've had all along, just thought it was a bug initially and that it would be fixed with the next release and the next release........


Results from your SQL command

Results from your SQL command

Here are the results of your command: "SELECT Mod_Board,Mod_Username FROM w3t_Moderators WHERE Mod_Username='Wando™'".
Mod_Board Mod_Username
UBB1 Wando™
UBB2 Wando™
UBB3 Wando™
UBB4 Wando™
UBB5 Wando™
UBB6 Wando™
UBB7 Wando™
UBB8 Wando™
UBB9 Wando™
UBB10 Wando™
UBB11 Wando™
UBB12 Wando™
UBB13 Wando™
UBB14 Wando™
UBB15 Wando™
UBB16 Wando™
UBB18 Wando™
UBB19 Wando™
UBB20 Wando™
UBB21 Wando™
UBB22 Wando™
wando Wando™
UBB23 Wando™
events Wando™
welcome Wando™
UBB24 Wando™
Kylie Wando™
ladies Wando™
wannabes Wando™
dealer Wando™
news Wando™
tuners Wando™
admin Wando™
diesel Wando™
AVForum Wando™
UBB17 Wando™
UBB25 Wando™
calendar Wando™


Results from your SQL command

Here are the results of your command: "SELECT Bo_Number,Bo_Moderators FROM w3t_Boards WHERE Bo_Moderators LIKE '%Wando™%' ".
Bo_Number Bo_Moderators
29 ,Wando™,
17 ,Wando™,Bushy,
25 ,Wando™,
26 ,Wando™,
27 ,Wando™,danksy,
28 ,Wando™,
31 ,Wando™,PhilT,
30 ,Bison,Wando™,PhilT,Dave,
32 ,Wando™,PhilT,
33 ,Wando™,
34 ,Wando™,
35 ,Wando™,
36 ,Wando™,
37 ,Wando™,
38 ,Wando™,



Results from your SQL command

Here are the results of your command: "SELECT U_Username,U_Number,U_Status,U_Groups,U_Title FROM w3t_Users WHERE U_Username = 'Wando™' ".
U_Username U_Number U_Status U_Groups U_Title
Wando™ 24 Administrator -3-1-2-5-6-7-8-9-



Results from your SQL command

Here are the results of your command: "SELECT G_Name,G_Id FROM w3t_Groups WHERE G_Name='Moderators' ".
G_Name G_Id
Moderators 2




Does that help?

The earlier versions of the classic import script didn't import moderators correctly. Supposedly that's been fixed.

Could you re-run those queries, replacing XYZ with one of the moderators who is having problems? Then we can see whether the database needs to be fixed.

just tried to assign a moderator again........

I can assign to some forums but not others.....

how strange is that?