Why am I getting err: 140 on table with no BLOBs?

[blakekr]

I ported this working table directly over from another server, but I get an error 140 trying to create this on my dathorn account. What do I need to change? What it seems to object to is the FULLTEXT part.
---------------------------------
CREATE TABLE sh_products(

id INT NOT NULL AUTO_INCREMENT ,
prod_id int( 10 ) ,
prod_name varchar( 125 ) ,
prod_vendor varchar( 30 ) ,
prod_url varchar( 180 ) ,
prod_thumb varchar( 180 ) ,
prod_image varchar( 180 ) ,
prod_price NUMERIC( 4, 2 ) ,
prod_descrip TEXT,
PRIMARY KEY ( `id` ) ,
FULLTEXT KEY `forsearch` ( `prod_name` , `prod_thumb` , `prod_id` , `prod_descrip` )
) TYPE = MYISAM

MySQL said:

#1005 - Can't create table './db_main/sh_products.frm' (errno: 140)

[sdjl]

When i tried running that SQL on my local installation of MySQL it returned this error:

#1283 - Column 'prod_id' cannot be part of FULLTEXT index

I'm guessing you need to remove the prod_id part from the fulltext key.
An integer isn't fulltext as far as i'm aware so that may be what's messing things up.

David