[Anzar]

i am a complete newbie and want to install a chat on my site...

when i go to put this table in:

CREATE TABLE forum_areas (
id tinyint(4) NOT NULL auto_increment,
name varchar(255) NOT NULL default '',
description varchar(255) NOT NULL default '',
last_update int(11) default NULL,
PRIMARY KEY (id)
) TYPE=MyISAM COMMENT='Forum Catagories';


CREATE TABLE forum_posts (
id int(11) NOT NULL auto_increment,
topic_id int(11) NOT NULL default '0',
board_id int(11) NOT NULL default '0',
post text NOT NULL,
username varchar(255) NOT NULL default '',
date int(11) NOT NULL default '0',
edit_date int(11) NOT NULL default '0',
last_update int(11) NOT NULL default '0',
PRIMARY KEY (id)
) TYPE=MyISAM COMMENT='Forum Replies';


CREATE TABLE forum_topics (
id int(11) NOT NULL auto_increment,
board_id int(11) NOT NULL default '0',
subject varchar(255) NOT NULL default '',
post text NOT NULL,
username varchar(255) NOT NULL default '',
date varchar(255) NOT NULL default '0',
edit_date int(11) NOT NULL default '0',
last_update varchar(255) NOT NULL default '0',
veiws varchar(255) NOT NULL default '0',
post_icon varchar(255) NOT NULL default '',
PRIMARY KEY (id)
) TYPE=MyISAM COMMENT='Forum Topics';


CREATE TABLE im (
id bigint(20) NOT NULL auto_increment,
sentto varchar(255) NOT NULL default '0',
sender varchar(255) NOT NULL default '0',
message longtext NOT NULL,
subject varchar(255) NOT NULL default '(No Subject)',
status text NOT NULL,
date bigint(20) NOT NULL default '0',
PRIMARY KEY (id)
) TYPE=MyISAM;


CREATE TABLE news (
id int(11) NOT NULL auto_increment,
subject varchar(255) NOT NULL default '',
poster varchar(22) NOT NULL default '',
date date NOT NULL default '0000-00-00',
message text NOT NULL,
PRIMARY KEY (id)
) TYPE=MyISAM;

CREATE TABLE users (
id int(11) NOT NULL auto_increment,
username varchar(22) NOT NULL default '',
password varchar(32) NOT NULL default '',
email_address varchar(155) NOT NULL default '',
nickname varchar(255) NOT NULL default '',
user_level enum('0','1','2','3','4',5') NOT NULL default '0',
forum_posts int(11) NOT NULL default '0',
profile text NOT NULL,
siggy varchar(255) NOT NULL default '',
last_post varchar(155) NOT NULL default '0',
last_login varchar(12) NOT NULL default '0',
style varchar(55) NOT NULL default '0',
PRIMARY KEY (id)
) TYPE=MyISAM;

it gives me a error at the end saying quote not closed or somthing for the last table "Users"
can some one please help?

[Nico]

There's a quote missing. Try this

Code:

CREATE TABLE users (
id int(11) NOT NULL auto_increment,
username varchar(22) NOT NULL default '',
password varchar(32) NOT NULL default '',
email_address varchar(155) NOT NULL default '',
nickname varchar(255) NOT NULL default '',
user_level enum('0','1','2','3','4','5') NOT NULL default '0',
forum_posts int(11) NOT NULL default '0',
profile text NOT NULL,
siggy varchar(255) NOT NULL default '',
last_post varchar(155) NOT NULL default '0',
last_login varchar(12) NOT NULL default '0',
style varchar(55) NOT NULL default '0',
PRIMARY KEY (id)
) TYPE=MyISAM;

[ben.periton]

it gives me a error at the end saying quote not closed or somthing for the last table "Users" can some one please help?

Im not trying to be funny, but if you read the errors that MySQL sends back, they are usually pretty informative, it says that there is a quote not closed in the end table "Users", so a quick glance at Users and we see a missing ' around the 5.

It just seems a lot of effort to go to a forum, post a message, wait for a reply and then fix, when it could be done easily by just reading the error!

[Anzar]

Thanks for that man,
really appreiciate your help

xtech, iv jus really been stressed and did read throught it 2 times, but as i said
i am a newbie i have no knowledge of it lol so never knew
next time i will be more concentrated when going throught the