Originally Posted by bradleyj (Post 2365969)

I got this error message...

I tried adding the tables but not sure what im doing. can someone give me a guide on what to put in here as the Mysql updated.

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 : Sunday, September 16th 2012 @ 01:17:57 PM
Error Date : Sunday, September 16th 2012 @ 01:17:57 PM
Script : http://www.topic+++++.com/admincp/pl...=productimport
Referrer : http://www.topic+++++.com/admincp/pl...?do=productadd
IP Address : 108.203.176.222
Username : bradleyj
Classname : vB_Database
MySQL Version : 5.5.23-55

Originally Posted by dougdirac

Feature request, or maybe someone can figure out how to do this. But I'd like better presentation of the data in the log.

I'd like to see a histogram graph of how many spammers were blocked per week, per day, per hour, etc. What caused them to be rejected. Country of origin. How many legit users made it through, etc.

That way I could get a sense of what antispam efforts are helping, etc.

Anyway to download the data as a CSV file, then I could just use Excell or Matlab or something.

Originally Posted by Slugger00001 (Post 2366584)

Why is there a link under "whats going on?" that links to this vbulletin.org thread?
Can that be disabled? I already have the affiliate disabled and give thanks.

Originally Posted by ForceHSS (Post 2366588)

Can you show a link to this on your site and a screenshot to show what you see as I also have this installed and this is not the case with me or anyone else

Originally Posted by Alibass (Post 2366602)

Turn it off in your SOM settings...

Originally Posted by Slugger00001 (Post 2366584)

Why is there a link under "whats going on?" that links to this vbulletin.org thread?
Can that be disabled? I already have the affiliate disabled and give thanks.