PDA

View Full Version : New Installation



Gunruh
11-26-2003, 12:44 PM
I need some help on installing Open-Realty. I've gone through the documentation and followed the instructions, but having difficulty connecting to MySQL. I'm no programmer, just know enough to be dangerous. I could use some advice here: I get the following when launching the configurator.php file: 0 -- CREATE TABLE default_UserDB (ID int(11) NOT NULL auto_increment,user_name varchar(80) NOT NULL default '',emailAddress varchar(80) NOT NULL default '',Comments text NOT NULL,user_password varchar(50) NOT NULL default '',isAdmin char(3) NOT NULL default 'No',canEditForms char(3) NOT NULL default 'No',creation_date date NOT NULL default '0000-00-00',canFeatureListings char(3) NOT NULL default 'No',canViewLogs char(3) NOT NULL default 'No',last_modified timestamp(14) NOT NULL,hitcount int(11) NOT NULL default '0',canModerate char(3) NOT NULL default 'no',PRIMARY KEY (ID),UNIQUE KEY ID (ID,user_name),KEY ID_2 (ID));
ERROR - CREATE TABLE default_UserDB (ID int(11) NOT NULL auto_increment,user_name varchar(80) NOT NULL default '',emailAddress varchar(80) NOT NULL default '',Comments text NOT NULL,user_password varchar(50) NOT NULL default '',isAdmin char(3) NOT NULL default 'No',canEditForms char(3) NOT NULL default 'No',creation_date date NOT NULL default '0000-00-00',canFeatureListings char(3) NOT NULL default 'No',canViewLogs char(3) NOT NULL default 'No',last_modified timestamp(14) NOT NULL,hitcount int(11) NOT NULL default '0',canModerate char(3) NOT NULL default 'no',PRIMARY KEY (ID),UNIQUE KEY ID (ID,user_name),KEY ID_2 (ID));

THanks!
Greg Unruh

CoeWeLe
11-26-2003, 01:15 PM
Can you post your site and database info that's in common.php please?

Gunruh
11-26-2003, 01:38 PM
I'm a "rookie" here, so I wasn't sure if it was proper to post my common.php file on the public board. I sent it to you in a private message.

Thanks!
Greg