[ForceHSS]

Originally Posted by Toshinobu

I'm getting the following error message when I try to import the product XML file:

Database error in vBulletin 4.1.8:

Invalid SQL:

CREATE TABLE IF NOT EXISTS `vbstopforumspam` (
APIKey VARCHAR( 255 ) NOT NULL ,
PRIMARY KEY ( APIKey )
) 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 4
Error Number : 1064

Any help would be appreciated, thanks. I looked at the SQL script it's complaining about and it looks fine.

**EDIT**
Replace the word TYPE with ENGINE on lines 22, 35, and 45 and product imported successfully

https://vborg.vbsupport.ru/showthread.php?t=248042
use this one