Quote:
Originally Posted by hqlman
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:
REPLACE WITH:
SAVE AND RE IMPORT XML FILE, ENJOY 
|
Hmm... didn't work for me... I have DB error with both above syntax's
Code:
Database error in vBulletin 3.8.7:
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=ENGINE;;
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=ENGINE' at line 10
Error Number : 1064