Creating table probmel

[vB3Dev.Com]

Can someone please tell me where the syntax error is in this query?

CREATE TABLE `calendar_events` (
`eventid` int(10) unsigned NOT NULL auto_increment,
`userid` int(10) unsigned NOT NULL default '0',
`event` mediumtext NOT NULL,
`eventdate` date NOT NULL default '0000-00-00',
`public` smallint(5) unsigned NOT NULL default '0',
`subject` varchar(254) NOT NULL default '',
`allowsmilies` smallint(6) NOT NULL default '1',
`photo_name` varchar(250) NOT NULL default '',
`catid` smallint(5) unsigned NOT NULL default '0',
`keywords1` varchar(20) NOT NULL default '',
`keywords2` varchar(20) NOT NULL default '',
`keywords3` varchar(20) NOT NULL default '',
`location` varchar(250) NOT NULL default '',
`postalcode` varchar(20) NOT NULL default '',
`phone` varchar(20) NOT NULL default '',
`time` varchar(8) NOT NULL default '12:00:PM',
`summary` text NOT NULL,
`website_title` varchar(200) NOT NULL default '',
`website_url` varchar(250) NOT NULL default '',
`views` int(11) NOT NULL default '0',
PRIMARY KEY (`eventid`),
KEY `userid` (`userid`)
) TYPE=MyISAM;

[Icheb]

What is the exact error message you are receiving?

[Steve Machol]

Any furthermore what are you doing when you get this error?

[eva2000]

try this


CREATE TABLE calendar_events (
eventid int(10) unsigned NOT NULL auto_increment,
userid int(10) unsigned NOT NULL default '0',
event mediumtext NOT NULL,
eventdate date NOT NULL default '0000-00-00',
public smallint(5) unsigned NOT NULL default '0',
subject varchar(254) NOT NULL default,
allowsmilies smallint(6) NOT NULL default '1',
photo_name varchar(250) NOT NULL default,
catid smallint(5) unsigned NOT NULL default '0',
keywords1 varchar(20) NOT NULL default,
keywords2 varchar(20) NOT NULL default,
keywords3 varchar(20) NOT NULL default,
location varchar(250) NOT NULL default,
postalcode varchar(20) NOT NULL default,
phone varchar(20) NOT NULL default,
time varchar(8) NOT NULL default '12:00:PM',
summary text NOT NULL,
website_title varchar(200) NOT NULL default,
website_url varchar(250) NOT NULL default,
views int(11) NOT NULL default '0',
PRIMARY KEY (eventid),
KEY userid (userid)
) TYPE=MyISAM;

[vB3Dev.Com]

eva2000, thank you. I am going to try it.

The reason I posted the above is because I get this error:

Invalid SQL: SELECT eventid, eventdate, subject, summary FROM calendar_events ORDER BY eventdate ASC
mysql error: Unknown column 'summary' in 'field list'

mysql error number: 1054

[Icheb]

The column summary doesn't exist then.

[vB3Dev.Com]

How do I add it to the above code then?

I am very new at this... :(

Thanks