>Description: When I create a fulltext index I get: ERROR 1005: Can't create table './inventory/#sql-4024_116c.frm' (errno: 140) >How-To-Repeat: alter table inventory.item add fulltext(storeId, catId, itemNo, title, type, publisher, condition, color, subCategory, description, location, edition);
describe inventory.item; +-----------------+------------------+------+-----+---------------------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------------+------------------+------+-----+---------------------+----------------+ | storeId | varchar(64) | | MUL | | | | catId | varchar(64) | | | | | | subCategory | varchar(128) | YES | | NULL | | | status | varchar(64) | | MUL | forsale | | | type | varchar(64) | YES | | NULL | | | description | text | | | | | | itemNo | varchar(64) | | | | | | size | varchar(128) | YES | | NULL | | | qty | int(11) | YES | | 1 | | | imageFile | varchar(255) | YES | | NULL | | | title | varchar(128) | YES | | NULL | | | subTitle | text | YES | | NULL | | | author | varchar(128) | YES | | NULL | | | pages | varchar(32) | YES | | NULL | | | isbn | varchar(128) | YES | | NULL | | | publisher | varchar(128) | YES | | NULL | | | year | varchar(32) | YES | | NULL | | | edition | int(5) | YES | | NULL | | | enteredStamp | datetime | | MUL | 0000-00-00 00:00:00 | | | updatedStamp | datetime | | MUL | 0000-00-00 00:00:00 | | | condition | varchar(32) | YES | | NULL | | | isNew | tinyint(4) | YES | | NULL | | | weight | varchar(32) | YES | | NULL | | | color | varchar(64) | YES | | NULL | | | seqNo | int(4) | YES | | NULL | | | price | decimal(7,2) | YES | | NULL | | | unitMeasure | varchar(50) | YES | | NULL | | | deletedStamp | datetime | | MUL | 0000-00-00 00:00:00 | | | location | varchar(128) | YES | | NULL | | | auctionMin | decimal(7,2) | YES | | NULL | | | auctionReserve | decimal(7,2) | YES | | NULL | | | purchaseCost | decimal(7,2) | YES | | NULL | | | purchaseDate | date | YES | | NULL | | | itemKey | int(8) unsigned | | PRI | NULL | auto_increment | | categoryKey | int(8) unsigned | YES | MUL | NULL | | | dealerPrice | decimal(7,2) | YES | | NULL | | | retailPrice | decimal(7,2) | YES | | NULL | | | minQty | int(11) unsigned | | | 1 | | | qtyPerUnit | int(7) | YES | | NULL | | | audited | tinyint(1) | YES | | 0 | | | upcCode | varchar(12) | YES | | NULL | | | accountKey | int(8) unsigned | YES | | NULL | | | countryOfOrigin | char(2) | YES | | NULL | | | serialized | tinyint(4) | YES | | NULL | | | reorderPoint | int(8) | YES | | NULL | | | makeVBuy | tinyint(1) | YES | | NULL | | +-----------------+------------------+------+-----+---------------------+----------------+ mysql> show keys from inventory.item; +-------+------------+----------------+--------------+--------------+-----------+-------------+----------+--------+------+------------+---------+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | +-------+------------+----------------+--------------+--------------+-----------+-------------+----------+--------+------+------------+---------+ | item | 0 | PRIMARY | 1 | itemKey | A | 1715210 | NULL | NULL | | BTREE | | | item | 0 | oldItemKey | 1 | storeId | A | 5794 | NULL | NULL | | BTREE | | | item | 0 | oldItemKey | 2 | catId | A | 95289 | NULL | NULL | | BTREE | | | item | 0 | oldItemKey | 3 | itemNo | A | 1715210 | NULL | NULL | | BTREE | | | item | 1 | enteredStamp | 1 | enteredStamp | A | 571736 | NULL | NULL | | BTREE | | | item | 1 | updatedStamp | 1 | updatedStamp | A | 571736 | NULL | NULL | | BTREE | | | item | 1 | systemCategory | 1 | storeId | A | 5794 | NULL | NULL | | BTREE | | | item | 1 | deletedStamp | 1 | deletedStamp | A | 171521 | NULL | NULL | | BTREE | | | item | 1 | storeId | 1 | storeId | A | 5794 | NULL | NULL | | BTREE | | | item | 1 | storeId | 2 | itemNo | A | 1715210 | NULL | NULL | | BTREE | | | item | 1 | categoryKey | 1 | categoryKey | A | 77964 | NULL | NULL | YES | BTREE | | | item | 1 | storeId_2 | 1 | storeId | A | 5794 | NULL | NULL | | BTREE | | | item | 1 | storeId_2 | 2 | upcCode | A | 7589 | NULL | NULL | YES | BTREE | | | item | 1 | status | 1 | status | A | 536 | NULL | NULL | | BTREE | | | item | 1 | status | 2 | price | A | 20917 | NULL | NULL | YES | BTREE | | +-------+------------+----------------+--------------+--------------+-----------+-------------+----------+--------+------+------------+---------+ >Fix: >Submitter-Id: randy6839 >Originator: Mike Wexler >Organization: tias.com >MySQL support: login support >Synopsis: can't add a full text index >Severity: serious >Priority: medium >Category: mysql >Class: sw-bug >Release: mysql-4.0.4 (RPM distribution) >Environment: System: Linux walker.tias.com 2.2.19-7.0.16SYN #4 SMP Tue May 21 19:13:11 PDT 2002 i686 unknown Architecture: i686 Some paths: /usr/bin/mh/perl /usr/bin/mh/make /usr/bin/mh/gmake /usr/local/bin/gcc /usr/bin/mh/cc GCC: Reading specs from /usr/local/lib/gcc-lib/i686-pc-linux-gnu/2.95.3/specs gcc version 2.95.3 20010315 (release) Compilation info: CC='/usr/local/bin/gcc' CFLAGS='-O6 -g -fno-omit-frame-pointer' CXX='/usr/local/bin/gcc' CXXFLAGS='-O6 -g -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti' LDFLAGS='' LIBC: lrwxrwxrwx 1 root root 13 Oct 7 13:12 /lib/libc.so.6 -> libc-2.2.4.so -rwxr-xr-x 1 root root 5808127 Sep 9 07:33 /lib/libc-2.2.4.so -rw-r--r-- 1 root root 27263316 Sep 9 07:39 /usr/lib/libc.a -rw-r--r-- 1 root root 178 Sep 9 07:39 /usr/lib/libc.so lrwxrwxrwx 1 root root 10 May 24 15:03 /usr/lib/libc-client.a -> c-client.a Configure command: ./configure --enable-assembler --with-prefix=/usr/local/mysql --with-extra-charsets=complex CC=/usr/local/bin/gcc 'CFLAGS=-O6 -g -fno-omit-frame-pointer' 'CXXFLAGS=-O6 -g -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti' CXX=/usr/local/bin/gcc --------------------------------------------------------------------- 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