[ForceHSS]

Originally Posted by bayoujeeper

Database error in vBulletin 4.2.2:

Invalid SQL:
SELECT * FROM glowhostspamomatic_stats;

MySQL Error : Table 'databasename.glowhostspamomatic_stats' doesn't exist
Error Number : 1146
Request Date : Friday, January 3rd 2014 @ 07:58:53 PM
Error Date : Friday, January 3rd 2014 @ 07:58:54 PM
Script : http://www..com/main/forum.php
Referrer : http://www./main/admincp/index.php?do=head
IP Address :
Username :
Classname : vB_Database
MySQL Version : 5.5.35-log

I had the same malware attack on my site. Had to rename the old dir. and create a new one. Re-uploaded all the Vb-core files and edited my config. Now trying to get the plugin's reinstalled. Reloaded this one and I get the error above.

Run this from the admincp/Maintenance/Execute SQL Query

CREATE TABLE IF NOT EXISTS `glowhostspamomatic_stats` (
  `denied` int(11) NOT NULL DEFAULT '0',
  `banned` int(11) NOT NULL DEFAULT '0',
  `moderated` int(11) NOT NULL DEFAULT '0',
  `s_sfs` int(11) NOT NULL DEFAULT '0',
  `s_akismet` int(11) NOT NULL DEFAULT '0',
  `removed` int(11) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

Then this after the above query

INSERT INTO `glowhostspamomatic_stats` VALUES ('0', '0', '0', '0', '0', '0');