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),
????: NamePros.com http://www.namepros.com/programming/681883-help-installing-php-script-spyname-domain.html
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

try change to :

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.

__________________