an indexed column cannot have null values, so it must be defined as 'not null'
To fix alter the table so the two fields are not null ALTER TABLE `message1` CHANGE `Title` `Title` varchar(64) NOT NULL etc then run your alter table hth Peter ----------------------------------------------- Excellence in internet and open source software ----------------------------------------------- Sunmaia www.sunmaia.net tel. 0121-242-1473 ----------------------------------------------- -----Original Message----- From: Clemson Chan [mailto:[EMAIL PROTECTED]] Sent: 06 September 2002 21:13 To: Mysql Cc: Clemson Chan Subject: RE: FULLTEXT search questions What is the following error? how do I fix it? Thanks, --Clemson mysql> alter table message1 add FULLTEXT (Title,Body); ERROR 1121: Column 'Title' is used with UNIQUE or INDEX but is not defined as NOT NULL mysql> desc message1; +---------+-------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +---------+-------------+------+-----+---------+----------------+ | ID | int(11) | | PRI | NULL | auto_increment | | Title | varchar(64) | YES | | NULL | | | Email | varchar(64) | YES | | NULL | | | Created | datetime | YES | | NULL | | | Body | text | YES | | NULL | | +---------+-------------+------+-----+---------+----------------+ -----Original Message----- From: Clemson Chan [mailto:[EMAIL PROTECTED]] Sent: Friday, September 06, 2002 12:06 PM To: Mysql Subject: FULLTEXT search questions Hi there, I am pretty new on MySQL. I am running a website, it needs a fulltext search on the message board. The message board table is setup without the fulltext column now. So when I ALTER TABLE to add a new column FULLTEXT(title, body)? The index will be created? In my table, the 'body' column was define as BLOB, should I change it TEXT before add the new FULLTEXT column? And what is the best to ALTER the column from BLOB to TEXT without messing up the data. Thanks a lot, --Clemson --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php