[hqlman]

Originally Posted by Kung!

When I attempt to import this product, I get:

Database error in vBulletin 3.8.4:

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, March 4th 2012 @ 06:27:38 PM
Error Date    : Sunday, March 4th 2012 @ 06:27:38 PM
Script        : http://www.[ourwebsite.com]/admincp/plugin.php?do=productimport
Referrer      : http://www.[ourwebsite.com]/admincp/plugin.php?do=productadd
Classname     : vB_Database
MySQL Version : 5.5.21

Tested working fine with VB3.8.7 patch level 2

Had to make a small change to the XML files sql syntax for it to import, so if you get SQL error whilst importing the XML file, make the changes mentioned below.

In product-glowhostspamomatic.xml

FIND:

) TYPE=MyISAM; ');

REPLACE WITH:

) TYPE=ENGINE; ');

SAVE AND RE IMPORT XML FILE, ENJOY