Hello everyone, I'm running Ver 8.39 Distrib 4.0.9-gamma, for intel-linux on i686. I'm trying to create a fulltext index on an existing myisam table and running up against an error. From what I can tell, I'm using the alter table command correctly, but I keep getting errno 140. Can anyone point out my error?
mysql> alter table materials add fulltext title (title,variant_title,ss_title,term_1,term_2,term_3,term_4, term_5,abstract,notes,personal_name_1,personal_name_2,personal_name_3,person al_name_4, personal_name_5,personal_name_6); ERROR 1005: Can't create table './lincs/#sql-6d12_7.frm' (errno: 140) # perror 140 Error code 140: Unknown error 140 140 = Wrong create options mysql> show create table materials; CREATE TABLE `materials` ( `rec_ID` mediumint(9) NOT NULL auto_increment, `file_name` varchar(100) default NULL, `user_name` varchar(250) default NULL, `user_email` varchar(250) default NULL, `date_created` timestamp(14) NOT NULL, `date_modified` timestamp(14) NOT NULL, `inputting_agency` varchar(100) default NULL, `inputting_state` varchar(100) default NULL, `title` text, `variant_title` text, `edition` varchar(100) default NULL, `ss_title` text, `ss_volume` varchar(100) default NULL, `personal_name_1` varchar(250) default NULL, `personal_name_2` varchar(250) default NULL, `personal_name_3` varchar(250) default NULL, `corporate_name_1` varchar(250) default NULL, `corporate_name_2` varchar(250) default NULL, `electronic_availability` varchar(250) default NULL, `publisher` text, `pub_place` varchar(100) default NULL, `pub_date` varchar(100) default NULL, `pub_phone` varchar(100) default NULL, `pub_fax` varchar(100) default NULL, `pub_TDD` varchar(100) default NULL, `pub_email` varchar(100) default NULL, `pub_URL` varchar(250) default NULL, `special_collection` text, `material_type` text, `physical_media` varchar(100) default NULL, `language` text, `tool_for` text, `beneficiary` text, `skill_level` text, `term_1` text, `term_2` text, `term_3` text, `term_4` text, `term_4_source` varchar(100) default NULL, `term_5` text, `term_5_source` varchar(100) default NULL, `notes` text, `abstract` text, `funding_info` text, `desc_extent` text, `desc_dimensions` varchar(100) default NULL, `desc_materials` varchar(100) default NULL, `system_requirements` varchar(100) default NULL, `ISBN` varchar(100) default NULL, `ISSN` varchar(100) default NULL, `EDRS` varchar(100) default NULL, `GPO` varchar(100) default NULL, `local_id` varchar(100) default NULL, `phys_location` varchar(100) default NULL, `phys_address` varchar(250) default NULL, `phys_phone` varchar(100) default NULL, `phys_fax` varchar(100) default NULL, `phys_TDD` varchar(100) default NULL, `phys_email` varchar(100) default NULL, `phys_URL` varchar(250) default NULL, `dist_name` varchar(100) default NULL, `dist_address` varchar(250) default NULL, `dist_phone` varchar(100) default NULL, `dist_fax` varchar(100) default NULL, `dist_TDD` varchar(100) default NULL, `dist_email` varchar(100) default NULL, `dist_URL` varchar(100) default NULL, `dist_availability` text, `dist_details` text, `pub_month` char(3) default NULL, `pub_year` varchar(6) default NULL, `state_locality` varchar(100) default NULL, `uniq_id` varchar(100) default NULL, `region` varchar(100) default NULL, `personal_name_4` varchar(250) default NULL, `personal_name_5` varchar(250) default NULL, `personal_name_6` text, PRIMARY KEY (`rec_ID`) ) TYPE=MyISAM Duncan ----------------------------------------------- Duncan Salada Titan Systems Corporation 301-925-3222 x375 --------------------------------------------------------------------- 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