[bzcomputers]

Originally Posted by Jpolola

Hello....
Anybody could please tell me why I received this error VIA email after uploading Spamomatic Files.

Database error in 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 @ 07:15:11 PM
Error Date : Sunday, September 16th 2012 @ 07:15:11 PM
Script : http://www.pinoylifers.com/admincp/p...=productimport
Referrer : http://www.pinoylifers.com/admincp/p...?do=productadd
IP Address : **********
Username : **********
Classname : vB_Database
MySQL Version : 5.5.23-55

Open The XML file (product-glowhostspamomatic.xml) and edit "TYPE=MyISAM" to say "ENGINE=MyISAM" in 3 places: on line 30, 38 and 47. Resave, then reimport and allow overwrite.

This is a change required for the MySQL version you have (highlighted in red above).