[charlesr]

Has anyone tried installing this fresh on 4.1.7?

I've just set up a test instance for 4.1.7 and all my other products work so far, but this one gives the following when I try and import the xml file (after having uploaded the relevant folders):

EDIT: I get the same error for the limited guest viewing product. I can't see anything wrong though - I have MyISAM as my default storage engine (I actually don't have InnoDB at all). I'm off to check the manual (mysql version 5.5.16), but if anyone has any ideas in the mean time, please post away.

EDIT2: The 5.0 manual suggests TYPE is deprecated and it should say ENGINE, but that TYPE is supported. There is no mention of TYPE in the 5.5 manual.

Database error in vBulletin 4.1.7:

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, November 3rd 2011 @ 06:22:03 PM
Error Date    : Thursday, November 3rd 2011 @ 06:22:03 PM
Script        : http://127.0.0.1/site/admincp/plugin.php?do=productimport
Referrer      : http://127.0.0.1/site/admincp/plugin.php?do=productadd
IP Address    : 127.0.0.1
Username      : charlesr
Classname     : vB_Database
MySQL Version : 5.5.16