Nothing, error.

@alpha1 if you have profile spam for users who are part of the group that is pending activation (e.g. those bots that did not click the email link) then permission them with lower options in that group so that they can do basically nothing. We don't allow such things especially signatures unless they are a member of the registered user group.

That stuff is all part of vBulletin, not this mod.

@JorgeX yes I can add it if it becomes a popular request sometime in version 2.

Why are these errors occurring? the registrations are stopped, but I am getting these dB errors for some of them....

vBulletin 4.0.8, no other dB errors exist except these. Additionally, should there be an index on the glowhostspamomatic_remotecache table?, as there is none after install.

That is an error generated by the MySQL server not the script itself. The most common reason for the MySQL server has gone away error is that the server timed out and closed the connection.

You can read more about this problem and ask your host to increase the timeout if it is set too low. There can be other reasons as well. Here is a link that explains the error.

http://dev.mysql.com/doc/refman/5.0/en/gone-away.html

As for the index, probably I will look at it a little closer later today and add it into the 2.0 version if its not there already.

My database is highly tuned, and there are no timeouts that occur on anything except this mod. I have a deep DBA background and have tuned as much as can be on MySQL dB. This is not a shot at you, by any means, however, I am quite sure my dB parameters are all in proper order, and considering the tables for this mod are very small, a simple insert or select should not induce the classic "MySQL has gone away errors". The question remains as to why this is only occurring against tables for this mod. None are crashed, however, I will re-analyze & check to ensure I am correct.

Thanks for your response, along with this mod, it is quite effective.

<<update>> I increased the wait timeout too see if that addresses the issue, and will refine from there if it does.

I seem to be getting a lot of excess hits to my database from reported spammer IPs who are not logged but have a lot of page views this is causing long delays for legitimate users , will this mod address that ? As small as my forum is I hate to go to a virtual dedicated server to accommodate spammers. Or should I just blame Network solutions for their poor service since April .

Sorry, I am not following. Can you describe in more detail what you mean about hits to your database from reported spammers? Do you mean they are being blocked but still are looking at your site which is overloading it?

Why not block the IPs using .htaccess or if NetSol is that terrible, I know of a great host...

Having the same issue. Actually, similar. The submit button does nothing when you click on it... doesnt appear to be "pressed" or anything.

VB 4.0.6

Spam-O-Matic has caught and nailed about 50 fake spammer registration attempts since I installed it. I could not be happier. I am running 4.0.8 and since I have installed the mod, not one phony spammer has gotten through, yet not one legitimate participant's registration has been blocked.

Thanks for the great spam-roller!

+1 Great work!