Hi,

My problem occurs on the page 176 where I was just trying to add a FULLTEXT index to the Cds table. MyISAM is the default table type for the MySQL Server 4.1.13 (which I have installed on my windows based machine) and it's the only table type which supports FULLTEXT index type.
For some reason I'm receiving an error when executing the following statement:

mysql> CREATE TABLE cds(
    -> intCdID SMALLINT UNSIGNED NOT NULL PRIMARY KEY,
    -> txtCdName VARCHAR(40) NOT NULL
    -> );
Query OK, 0 rows affected (0.06 sec)

mysql> ALTER TABLE cds
    -> ADD FULLTEXT (txtCdName);
ERROR 1214 (HY000): The used table type doesn't support FULLTEXT indexes

Any idea what might cause this error?

Thanks,

What I've done is I simply defined the table type adding the ENGINE=MYISAM; at the end of the CREATE TABLE statement.
This time it worked ok when I've used ALTER statement.

Still however I don't know why it caused the problem without defining the table ENGINE=MYISAM - which suppose to be the default one.

If you know why - please post the answer.

Thanks,

Sorry for this mess.

I think I've found the answer.
I've just opened 'my.ini' file and found out that the line which determines the default type of database is set up to INNODB:

# The default storage engine that will be used when create new tables when
default-storage-engine=INNODB

- which considering that this is the only table type which support foreign key functionality and in addition is transaction-safe is even better choice. Adding ENGINE=MYISAM in case if I really need it is not a big problem - I'm not using this type of tables very frequently because it doesn't support foreign key functionality.

Take care,