[hqlman]

Originally Posted by Syxguns

shadowbreed,
Are you still having the same issue? I was and after a little research I found that if you are running MySQL 5.5 it does not recognize the ?Type=MyIsam:? . It was valid for for older versions. Let me show you how I corrected the problem.

Edit: Looking back I see that your problem is not the same as mine was. This will not help you.



Edit: #2
For anyone that has a Database error that looks like the following example this is how I corrected it.

Error Code..

Database error in vBulletin 4.1.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=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

 $db->query_write('CREATE TABLE IF NOT EXISTS `'.TABLE_PREFIX.'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; ');

 
$db->query_write('CREATE TABLE IF NOT EXISTS `'.TABLE_PREFIX.'glowhostspamomatic_remotecache`(

                           `date` DATETIME NOT NULL,
                           `field` VARCHAR(20) NOT NULL,
                           `is_spambot` INT NOT NULL,
                           `data` VARCHAR(255) NOT NULL
                             ) TYPE=MyISAM; ');

 

$db->query_write('CREATE TABLE IF NOT EXISTS `'.TABLE_PREFIX.'glowhostspamomatic_stats`(

                          `denied` INT NOT NULL DEFAULT "0",
                          `banned` INT NOT NULL DEFAULT "0",
                          `moderated` INT NOT NULL DEFAULT "0",
                          `s_sfs` INT NOT NULL DEFAULT "0",
                          `s_akismet` INT NOT NULL DEFAULT "0",
                          `removed` INT NOT NULL DEFAULT "0"
                           ) TYPE=MyISAM; ');

Each item marked in red needs to be removed from the XML file. Leave the rest of the statement including the semi-colons. It is located 3 times so be sure to remove the test in red. The line should look like this:

 ) ; ');

That may get it working for you. It worked for me when I made the change. Good Luck!

Works perfectly, thanks a lot