Spam-o-matic database error

[dj83]

Hello,

I am trying to install spam-o-matic but I keep getting the following error...
How can I fix this?

Database error in vBulletin 3.8.2:

Invalid SQL:
CREATE TABLE IF NOT EXISTS `vb_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 : Tuesday, December 2nd 2014 @ 09:01:31 AM
Error Date : Tuesday, December 2nd 2014 @ 09:01:31 AM
Script : http://myurl.com/admincp/plugin.php?do=productimport
Referrer : http://myurl.com/admincp/plugin.php?do=productadd
IP Address :
Username :
Classname : vB_Database
MySQL Version : 5.5.40-36.1

[Dave]

Should work if you remove

TYPE=MyISAM;

from the installation code.

[ForceHSS]

You should be posting this in the plugin for support but try Dave's post first

[HM666]

And if that does not work you can try to change:

TYPE=MyISAM;

To

TYPE=ENGINE;

instead.

[ozzy47]

No, no, no, not TYPE=ENGINE; it's ENGINE=MyISAM;

[HM666]

No, no, no, not TYPE=ENGINE; it's ENGINE=MyISAM;

Ok I know there were some mods that you had to change that bit or at least I've had to change it because it disliked my server for whatever reason.

[ozzy47]

Right but it is not TYPE=Engine, that is just wrong. :)

The older TYPE= option was synonymous with ENGINE=. TYPE was deprecated in MySQL 4.0 and removed in MySQL 5.5. When upgrading to MySQL 5.5 or later, you must convert existing applications that rely on TYPE to use ENGINE instead.

[HM666]

Right but it is not TYPE=Engine, that is just wrong. :)

The older TYPE= option was synonymous with ENGINE=. TYPE was deprecated in MySQL 4.0 and removed in MySQL 5.5. When upgrading to MySQL 5.5 or later, you must convert existing applications that rely on TYPE to use ENGINE instead.

Ok :) Well hopefully the other suggestions have helped him/her out.

[ozzy47]

Sure, either removing TYPE=MyISAM; or changing it to ENGINE=MyISAM; will allow the OP to import the mod.

But any issues after that, the OP will have to ask for support in the modifications thread. :)

[HM666]

Sure, either removing TYPE=MyISAM; or changing it to ENGINE=MyISAM; will allow the OP to import the mod.

But any issues after that, the OP will have to ask for support in the modifications thread. :)

OH GEEZ, I'm having such a brain fart! Ok yeah that is what I've done before. Sorry for my dyslexia before lol.

[ozzy47]

It happens to all of us brother. :)

[dj83]

Thanks!