[Forum] Deleting a thread from Database in vBulletin 4

[Expert1]

My forum is based on vBulletin 4 and the problem I am facing is with a particular thread. Lot of spamming is been done on that thread due which my site has become very slow and I get this very unusual error called Database Error whenever I post or perform any action on forum. I found that particular thread but the problem is I cannot view it if I am logged in as admin in order to remove it. If I am logged out I can view that specific thread. The only possible thing I find is to delete that thread from the database. Now can someone please help me out by providing the information to delete that particular thread from the database. How should I delete it from the DB? Help.

[Mark.B]

Can you please post the database error you are getting?

[Expert1]

I am getting and error max_user_connections. My hosting given me 50 connection and they cannot increase. They saying there is some script using lots of CPU.

[Mark.B]

Don't touch your database over that error. If your host is refusing to increase it for that reason - and you have no addons that could be causing the issue - then find another host. No amount of playing in the database will fix it, and will almost certainly break things if you don't know what you're doing.

Sounds like you've exceeded the resources your host is prepared to allow - move onto to someone else is my advice.

[djbaxter]

That may well be because he's getting spam-bombed, though.

Go into AdminCP and shut down your forum: Settings >> Options >> Turn Your vBulletin On and Off >> vBulletin Active = No

You may need a little while to release the connections but you should then be able to go into the thread as an Admin and clean it up - or delete it.

Then you are really going to need some better anti-spam protection:

1. Install Spammers suck! to blobk spam-bots.

2. Then install either vbStopForumSpam or [GlowHost] Spam-O-Matic - Spam Firewall stops forum spam.

3. Then you can try turning your forum back on.

[Mark.B]

Could well be but in the long run I'd go with a new host. Whenever you get a host who starts blaming the script on your server, clearly without any investigation, then they have no idea of your needs and it's time to go.

[Expert1]

getting database error while installing Spam o matic. can u guide me compete procedure to install it.

Database error in vBulletin 4.2.0:

Invalid SQL:
CREATE TABLE IF NOT EXISTS `glowhostspamomatic_log`(
                                    `date` DATETIME NOT NULL,
                                    `ip` VARCHAR(15) NOT NULL,
                                    `email` VARCHAR(255) NOT NULL,
                                    `username` VARCHAR(255) NOT NULL,
                                    `message` VARCHAR(255) NOT NULL,
                                    `is_blocked` TINYINT NOT NULL DEFAULT "0",
                                    `user_hash` VARCHAR(50) NOT NULL,
                                    `user_id` INT NOT NULL
                                 ) TYPE=MyISAM;;

MySQL Error   : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 10
Error Number  : 1064
Request Date  : Thursday, December 6th 2012 @ 12:58:27 AM
Error Date    : Thursday, December 6th 2012 @ 12:58:27 AM
Script        : http://www.techhotfix.com/forum/admincp/plugin.php?do=productimport
Referrer      : http://www.techhotfix.com/forum/admincp/plugin.php?do=productadd
IP Address    : ***.***.***.**
Username      : *****
Classname     : vB_Database
MySQL Version : 5.5.28-log

[djbaxter]

The error and the solution has been posted many times in the [GlowHost] Spam-O-Matic - Spam Firewall stops forum spam thread at vBulletin.org. Ask there if you can't find it,

[Mark.B]

Indeed....we are unable to provide support for modifications here, so you'd need to ask at www.vbulletin.org, as stated.