I am facing a problem when i install the mod...gives me database error.....
Database error in vBulletin 4.2.0:
Quote:
Invalid SQL:
CREATE TABLE IF NOT EXISTS `abc_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, September 11th 2012 @ 12:10:14 AM
Error Date : Tuesday, September 11th 2012 @ 12:10:14 AM
Script : http://www.mydomain.com/admincp/plug...=productimport
Referrer : http://www.mydomain.com/admincp/plug...?do=productadd
IP Address : 18.222.140.59
Username : Admin
Classname : vB_Database
MySQL Version : 5.5.23-55
|
Can somebody update me what could be the issue