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
