Hi there,
I've previously used your 1.2.x version but stopped it for a while, and now I found out that you've released a 2.x version.
I made sure to remove that /forum/includes/xml/bitfield_glowhostspamomatic.xml file, and then tried to install it by importing product-glowhostspamomatic.xml into "Products".
I immediately see a database error message:
Quote:
Database error in vBulletin 4.0.7:
Invalid SQL:
CREATE TABLE IF NOT EXISTS `vbulletin_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
|
I noticed there's an extra semi-colon at TYPE=MyISAM, but when I checked the product-glowhostspamomatic.xml out, there's only one semi-colon, not two as this error shows.
Any ideas what could be the problem? =/