>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
