[mdawg]

Adding on to the SQL database errors noted by others above, ones in which the punch line is "MySQL Error : MySQL server has gone away," I do believe that most of these have to do with the MU hack. But, isn't this what the MU modification is supposed to do? Delay response?

I have this one particular spammer I MU'ed who is particularly determined to get back on my forums. Or maybe he doesn't even realize he has been MU'ed and just thinks this is the way it is!

Anyway, the errors typically read like this:

Database error in vBulletin 3.8.4:

Invalid SQL:

SELECT forumid, moderatorid, permissions, permissions2
FROM moderator
WHERE userid = 313 AND forumid != -1;

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Tuesday, August 25th 2009 @ 05:38:44 PM
Error Date : Tuesday, August 25th 2009 @ 05:39:15 PM
Script : http://www.XXXYYYXXX.com/forums/
Referrer : http://www.XXXYYYXXX.com/index.php
IP Address : 95.XXX.X.XX
Username : _________
Classname : vB_Database
MySQL Version :

Where the username: ____________ is the user I MU'ed.

(By the way...just FYI, through these database errors I have noticed that the culprit logs on with different (but very similar) IP addresses. So, banning an IP address is not an effective means to keep away a determined spammer.)

But the odd thing is...I am also occasionally getting these database errors for unregistered users:

Invalid SQL:

INSERT INTO cronlog
(varname, dateline, description, type)
VALUES
('vbseo_sitemap_task',
1251271198,
'Google Sitemap Created',
0);

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Wednesday, August 26th 2009 @ 02:19:58 AM
Error Date : Wednesday, August 26th 2009 @ 02:22:24 AM
Script : http://www.XXXYYYXXX.com/forums/cron...and=1251271196
Referrer : http://www.XXXYYYXXX.com/forums/XX-d...ns/___________
IP Address : 97.XX.XXX.XX
Username : Unregistered
Classname : vB_Database
MySQL Version :

And wonder if these cron errors also have to do with this MU add on.

[Paul M]

You almost certainly have a very low mysql timeout value.

[Aclikyano]

this mod >>>
dont have it installed now, but i did before prob when was on 3.7
had me rofl when put it on some annoying members

[mdawg]

Originally Posted by Paul M

You almost certainly have a very low mysql timeout value.

I am on a shared server so I cannot change the value. I believe this server kills queries running longer than 15 seconds.

[bada_bing]

I would like to suggest a few options for this plugin to make it more interactive with the mods.

There should be an icon next to the ban user icon called Miserable Users and whoever has access to use it can dynamically add a user to this groups and show also have the ability to choose a start date/time and end date/time or permanent, that way you dont forget you placed someone in this group as you can torcher them for that time frame then get removed from that group when the time expires.

[princeedward]

this is perfect idea and created for a new vb version....it a bit friendly way to fight back those annoying members, spammers, don't want to follow rules, acting genious and dont want to be corrected always...all in all a BAD, BAD, BAD person...

instead of having a headache now and get angry arguing with them all the time....you will have fun lauging just to think what will gonna happen to this bad members......

surely they will love this as much as you love this mod....

million thanks to the original creator and likewise to Paul M for his time updating this to the latest stand...

[Drache]

where can I edit the server busy message? I can just set unregistered group as miserable user groups and give them 25% chance to see server busy message and require to login to load faster?

[Paul M]

I believe the vb busy message is a phrase called "toobusy".

[krazyness]

Installed

[beatyourtruck]

I love this mod....a great way to get rid of pesky members Thanks Paul! 8)

[KellyT]

Thank you

[Super-six]

Where does this mod load into ACP [controls interface]?

adminCP > vB options > banning options?

[Biker_GA]

AdminCP->Usergroups->Usergroup Manager

[MyCTaK]

I just installed it and test it! Great! I decrease all percent and i hope people will not understand what disaster is upon them! Thanks!
I wanted to suggest option so user can't log out and register new one.
Best: MyCTaKaP

[BigDog56]

Love this one, it's my wife's favorite modification, lol. Upgraded from 3.6 to this one.