[Blog] Ex-moderator stil receiving Blog report emails

[mike406]

---

One of my ex-moderators (super moderator) has contacted me saying that he has been getting Blog report emails. He's been stripped of all advanced moderator permissions (both global and forum specific) and is only in the Registered group.

I went ahead and took a look at the blog_moderators table with phpmyadmin. For some reason, his userid is still entered into the table. Is it safe to delete the entry?

What also concerns me is that I notice that all of my old super-mods are still in the tables (moderator and blog_moderator). I can only assume they are receiving blog report emails as well. Does this mean that I will have to manually delete their database entries every time I remove a supermod from the usergroup?

My current understanding of how these 2 tables work, is that they keep track of their set permissions (since there will not be a table entry if you never edited their specific permissions). Shouldn't these delete themselves when the mod is removed from the usergroups?

Thanks.

[Hartmut]

And there is no entry in AdminCP -> vBulletin Blog -> Blog Moderators anymore?

[mike406]

Nope, he doesn't appear in Blog Moderators or Super Moderators because he's been removed from the usergroup.

[setishock]

Run your maintenance programs from the ACP to force the system to update it's info.

[mike406]

Which one/s should I run?

[Hartmut]

You could try AdminCP -> Maintenance -> Fix broken user profiles but i dont believe that this will work. If not, then let me know and I will send you the query for this.

[mike406]

I do not think it helped as they still appear in the databases. I find it odd that this only affects Blogs though. There are some old mod userids in the forum moderator table, but they don't seem to be causing anything negative.

[Hartmut]

Still weird... fetch up that user's userid and send the following query, BEFORE this please backup your database:

DELETE FROM `blog_moderator` WHERE USERID = userid_from_old_moderator_here; 

[mike406]

Thanks that did remove the entries. Though I have a feeling that this will continue to occur as I switch moderators out. I'll have to remember to check on the databases whenever I remove a moderator I suppose.

[Hartmut]

This should be done automatically by vBulletin.

[mike406]

vB does automatically remove the database entries for my Blog Mods and standard Forum Mods because I use the 'Remove' link. However I don't see such a link for my Super/Global Mods so I usually just remove them from the usergroup and put them back into Registered (which leaves the database entry as leftover). Is this the incorrect process of removing a Super Mod?

[Hartmut]

Usually yes, that's why I'm a bit confused. Maybe a product causes this error...???

[mike406]

Hmm... Well I do have some products installed, none of which I am aware of that would mess with moderator privileges or anything like that. Thanks for your help again, I'll see if I can get this worked out.