[Syxguns]

Originally Posted by bradleyj

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

I wish there was a way to add this information in the primary post!! I won't explain in detail, but you are running MySQL 5.5 and TYPE=MyISAM is not recognized. Open the XML file with notepad++ and change the 3 occurrences of that to ENGINE=MyISAM and that will correct the problem. Don't block Username with the mod, and if you read the thread, you will see that these statements have been mentioned multiple times.