Help installing Php script SPYNAME DOMAIN FINDER

[world1122]

I HAVE USED THE SPYNAME SETUP PAGE TO SET UP THE SCRIPT ON MY SERVER BUT WHEN I TRY TO INSTALL THE SCRIPT IT GIVES ME THIS ERROR

CREATE TABLE IF NOT EXISTS member
(
id INTEGER AUTO_INCREMENT PRIMARY KEY,
active BOOL DEFAULT 'FALSE' NOT NULL,
login VARCHAR(50) UNIQUE,
first VARCHAR(50),
last VARCHAR(50),
email VARCHAR(50),
acctype INTEGER NOT NULL REFERENCES plan(id),
sstat INTEGER DEFAULT 0 NOT NULL,
news BOOL,
passwd VARCHAR(50),
subscr_id VARCHAR(100)
) TYPE=InnoDB
Invalid default value for 'active'

AN I HAVE NO IDEA WHAT MAY BE THE PROBLEM EVERYTHING ELSE IS SET UP PROPERLY MYSQL AN DATABASE IS GOOD I JUST NEED TO GET PAST THIS PROBLEM IF ANYONE COULD PLEASE HELP IN ANYWAY I TRIED TO CONTACT WGS EXPIRE FOR SUPPORT BUT ALL I GET IS DEAD LINKS

THEY HAVE BAD SUPPORT

 

[abonk]

I HAVE USED THE SPYNAME SETUP PAGE TO SET UP THE SCRIPT ON MY SERVER BUT WHEN I TRY TO INSTALL THE SCRIPT IT GIVES ME THIS ERROR

CREATE TABLE IF NOT EXISTS member
(
id INTEGER AUTO_INCREMENT PRIMARY KEY,
active BOOL DEFAULT 'FALSE' NOT NULL,
login VARCHAR(50) UNIQUE,
first VARCHAR(50),
last VARCHAR(50),
email VARCHAR(50),
acctype INTEGER NOT NULL REFERENCES plan(id),
sstat INTEGER DEFAULT 0 NOT NULL,
news BOOL,
passwd VARCHAR(50),
subscr_id VARCHAR(100)
) TYPE=InnoDB
Invalid default value for 'active'

AN I HAVE NO IDEA WHAT MAY BE THE PROBLEM EVERYTHING ELSE IS SET UP PROPERLY MYSQL AN DATABASE IS GOOD I JUST NEED TO GET PAST THIS PROBLEM IF ANYONE COULD PLEASE HELP IN ANYWAY I TRIED TO CONTACT WGS EXPIRE FOR SUPPORT BUT ALL I GET IS DEAD LINKS

THEY HAVE BAD SUPPORT

try change to :

active BOOLEAN DEFAULT FALSE NOT NULL,

 

[nasaboy007]

That fix should hopefully work - since booleans are a different type, they shouldn't need quotes (otherwise they get interpreted as strings).

Also, try pressing the caps lock key one more time.