[ForceHSS]

Originally Posted by K!nG

Hi All,

I used to have a lot of spammers register on my forum, but once i start using this hack not a single bot/spammer was able to register. Starting last week i start getting database errors and at that point i was using version 2.0.5 and disbale the mod which stopped all database errors. Today i decided to update to version 2.0.7 by thinking may be it will fix the issue.
Once i update and enable the mod. I start receiving database errors again and from past 2 weeks i had 989 spammers registered and i am hating it.

below are some errors i am pasting and i will appreciate if someone can help me in fixing this

Thanks in advance.

Database error in vBulletin 4.2.2:

Invalid SQL:
DELETE FROM userregcode WHERE dayscounter < 1416332758 AND wheretoapply = 0;

MySQL Error : Table './username_****forum/userregcode' is marked as crashed and should be repaired
Error Number : 145
Request Date : Tuesday, November 18th 2014 @ 12:45:58 PM
Error Date : Tuesday, November 18th 2014 @ 12:45:58 PM
Script : http://www.*****.com/xperience.php?g...&sort=xn&pp=30
Referrer :
IP Address : 188.165.xx.xx
Username : Unregistered
Classname : vB_Database
MySQL Version :


Another one :

Database error in vBulletin 4.2.2:

Invalid SQL:
DELETE FROM userregcode WHERE dayscounter < 1416332691 AND wheretoapply = 0;

MySQL Error : Table './username_****forum/userregcode' is marked as crashed and should be repaired
Error Number : 145
Request Date : Tuesday, November 18th 2014 @ 12:44:50 PM
Error Date : Tuesday, November 18th 2014 @ 12:44:51 PM
Script : http://www.****.com/activity.php
Referrer :
IP Address : 123.125.xx.xx
Username : Unregistered
Classname : vB_Database
MySQL Version :

Another one is:

Database error in vBulletin 4.2.2:

Invalid SQL:
INSERT INTO userregcode VALUES(NULL,'ennor86@proconview.com','9ce1a5a1e5a3 0b5cefd8ed1551f62d7f',1,1416165285,0);;

MySQL Error : Duplicate entry '93138' for key 'PRIMARY'
Error Number : 1062
Request Date : Tuesday, November 11th 2014 @ 02:14:44 PM
Error Date : Tuesday, November 11th 2014 @ 02:14:45 PM
Script : http://www.****.com/register.php
Referrer : http://www.****.com/register.php?
IP Address : 46.22.xxx.xxx
Username : Unregistered
Classname : vB_Database
MySQL Version :


Thanks.

You need to run repair on the table. Just take the time and read the error it does tell you what to do.