just ban domains you want from original settings.. job done ;)

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.

@K!nG

AdminCP > Maintenance > Repair/Optimize Tables > look for the table userregcode, tick repair/optimize and click on continue.

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

I did see that for first two error messages, but third one is different and few mores i just didn't want to paste all of them in here. So you suggesting if i run repair table it will fix it completely or would that just take care of first 2 errors ?

Thanks.

Possibly, yes.

Should do, but depends what the errors are run the repair if any more errors and if they are to do with this plugin post them all but put them in code quotes

When i tried to do repair table i got these errors below.

https://vborg.vbsupport.ru/external/2014/11/10.jpg

Any help will be appreciated.

Thanks.

do check from phpmyadmin :D

I got this working for BOP5 great new plugin if anyone intrested

https://vborg.vbsupport.ru/showthread.php?t=297834

Let me know ;)