[Rabbit9149]

Originally Posted by autostick

My apologies if this was covered, but I searched and found nothing. I am installing SpamOMatic for the first time, and when I click on Import Product, I get this error message. Any suggestions are most welcome. Thanks.

Database error in vBulletin 4.1.3:

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 : Saturday, May 28th 2011 @ 09:01:53 PM
Error Date : Saturday, May 28th 2011 @ 09:01:53 PM
Script : http://164.107.52.52/vb3/admincp/plu...=productimport
Referrer : http://164.107.52.52/vb3/admincp/plu...?do=productadd
IP Address : 164.107.52.52
Username : xx xx
Classname : vB_Database
MySQL Version : 5.5.8

I had this same error. It has to do with the newer versions of mysql you use. You can fix it by right clicking on product-glowhostspamomatic.xml and click edit and open your find window and search for TYPE=MyISAM I think there were 3 of them you need to change to ENGINE=MyISAM and that should fix you all up.