NamePros
Welcome, Guest! Ready to make a name for yourself in the domain business? We welcome both the hobbyist and professional domainer to join the discussion as part of the NamePros community.

Click here to create your profile to start earning reputation for posting, and trader ratings for buying & selling in our free e-marketplace. Build your trader rating with each successful sale. Our system has tracked over 100,000 sales and counting!
FAQ & TOS Register Search Today's Posts Mark Forums Read

Go Back   NamePros.com > Website Development Discussion Forums > Programming
Reload this Page help installing php script SPYNAME DOMAIN FINDER

Programming PHP, Perl, Ruby on Rails, AJAX, HTML, XHTML, CSS, JavaScript, MySQL and any other coding topics.

Advanced Search
5 members in live chat ~  


Reply
 
LinkBack Thread Tools
Old 10-12-2010, 06:05 PM THREAD STARTER               #1 (permalink)
New Member
Join Date: Oct 2010
Posts: 2
world1122 is an unknown quantity at this point
 



Help! help installing php script SPYNAME DOMAIN FINDER


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
world1122 is offline   Reply With Quote
Old 10-12-2010, 10:04 PM   #2 (permalink)
NamePros Member
Join Date: Sep 2010
Posts: 48
abonk will become famous soon enoughabonk will become famous soon enough
 



Originally Posted by world1122 View Post
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
????: NamePros.com http://www.namepros.com/showthread.php?t=681883

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 :

Code:
active BOOLEAN DEFAULT FALSE NOT NULL,
abonk is offline   Reply With Quote
Old 10-13-2010, 01:58 PM   #3 (permalink)
Senior Member
 
nasaboy007's Avatar
Join Date: Jul 2005
Location: NJ
Posts: 1,219
nasaboy007 has much to be proud ofnasaboy007 has much to be proud ofnasaboy007 has much to be proud ofnasaboy007 has much to be proud ofnasaboy007 has much to be proud ofnasaboy007 has much to be proud ofnasaboy007 has much to be proud ofnasaboy007 has much to be proud ofnasaboy007 has much to be proud of
 



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.
nasaboy007 is offline   Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools


Similar Threads
Thread Thread Starter Forum Replies Last Post
Thousands of Scripts, Software, Templates, Flash and more with Reseller Rights! EconomicalDomains Scripts For Sale 0 10-03-2007 12:06 PM
[FORSALE]250+ Professional PHP E-commerce mySQL Scripts steelbeam Scripts For Sale 6 07-23-2007 01:29 PM
Great Scripts for Sale With Resale Rights! Zeeble Scripts For Sale 20 01-04-2006 01:39 AM
Huge Xmas script pack sale $5.00 KPR Scripts For Sale 1 12-08-2005 06:25 PM

 
All times are GMT -7. The time now is 02:38 PM.

Domain name forum recommended by Domaining.com Powered by: vBulletin® Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.6.0 Ad Management plugin by RedTyger