List:General Discussion« Previous MessageNext Message »
From:Duncan Salada Date:January 28 2003 7:40pm
Subject:problems creating fulltext index
View as plain text  
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
Thread
problems creating fulltext indexDuncan Salada28 Jan
  • Re: problems creating fulltext indexDan Nelson29 Jan
RE: problems creating fulltext indexErlend Hopsø Strømsvik29 Jan
RE: problems creating fulltext indexDuncan Salada29 Jan
  • Re: problems creating fulltext indexSergei Golubchik29 Jan
RE: problems creating fulltext indexDuncan Salada31 Jan