[molieman]

Just tried to update to the latest version of Spam-O-Matic on vB 4.2 and get a Database error when importing the xml.

This is what I get:

Database error in vBulletin 4.2.0:

Invalid SQL:
CREATE TABLE IF NOT EXISTS `vbglowhostspamomatic_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, May 27th 2012 @ 12:14:14 PM
Error Date    : Sunday, May 27th 2012 @ 12:14:14 PM
Script        : http://mycockpit.org/forums/admincp/plugin.php?do=productimport
Referrer      : http://mycockpit.org/forums/admincp/plugin.php?do=productadd
IP Address    : xx.55.21.xxx
Username      : xxxxxx
Classname     : vB_Database
MySQL Version : 5.5.22-cll

Any help appreciated, please. I love this product