[Syxguns]

molieman, a couple of things I noticed:

) TYPE=MyISAM;;

MySQL Version : 5.5.22-cll

As I have mentioned before for those that don't like to read!! A couple of corrections have been made throughout this thread. and I'm going to repeat them here.

1) Make sure that you DISABLE check username, let me reapeat, do not engage check username!! There are many reasons to do this but for example if a spammer decides to use my username, then I would be blocked from registering on your site.

2) Make sure to get your API keys and use them.

3) increase the amount of words on your Bad Words list. I could give you a link to GlowHost that has a list, but I will just present it to you here to copy and paste:

Originally Posted by GlowHost

acne
adipex
alprazolam
ambien
antidotes
ariset
baccarrat
blackjack
botox
buspar
butalbital
carisoprodol
casino
casinos
celexa
cell
cialis
cialis
ciallis
citibank
cyberturf
didrex
dosage
drugs
dvd
ejactulation
ejaculation
fioricet
foreclosure
forex
gambling
gold
holdem
homeloan
horny
insurance
ipod
keno
meds
mobile
mortgage
motorola
nasonex
nfsautoloan
nike
nokia
penis
pharmaceutical
pharmacy
phentermine
phone
poker
porn
prozac
refinance
ringtone
ringtones
rip
ripper
rolex
sex
slots
softtabs
sperm
strapon
tramadol
ultram
vaigra
viaagra
viagra
viccodin
xanax
xannax

4) If you are running a newer version of MySQL it has a much more strict usage and this mod as well as a few others are not allowed to make tables in the database. This is primarily because the newer versions of MySQL is enabled with strict_mode ON.

There are two ways to make this work, however, option one you may have to contact your provider to do unless you have direct access to the "my.ini" inside the MySQL installation directory. Turn Off MySQL Strict Mode

Another way to do it is withing the XML file of GlowHost S-O-M. I placed this post back a number of pages and a number of members found it useful. I will repost it again here.

{Quote from post #1639 in this thread}

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.

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

[COLOR]
 $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:

 ) ; ');

There may be a couple of other changes that I can not think of off the top of my head, but this should get it working for you. Yes it works in vB 4.2.0!