View Single Post
  #1912  
Old 08 Aug 2012, 16:19
ForceHSS ForceHSS is offline
 
Join Date: Apr 2008
Originally Posted by salar007 View Post
I get this error when I try to install :

Database error in vBulletin 4.2.0:

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

Using VB 4.2 MySQL Version : 5.5.24-cll

Any suggestions ?
Change all occurence of


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

to


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

in the XML and that will solve the DB Errors.
Reply With Quote