WampServer

Error
SQL query:

CREATE TABLE `announce` (

`id` INT UNSIGNED NOT NULL AUTO_INCREMENT ,
`announce_url` VARCHAR( 255 ) NOT NULL ,
`status` VARCHAR( 255 ) NOT NULL ,
`force` VARCHAR( 255 ) DEFAULT 'NO' NOT NULL ,
PRIMARY KEY ( `id` ) ,
UNIQUE (
`announce_url`
),
FULLTEXT (
`announce_url`
)
);



MySQL said:

#1214 - The used table type doesn't support FULLTEXT indexes

-----------------------------------------------------------------------------------------------------------------------

what with this ???

Hi,

Try adding the following to the end of the query:

ENGINE = MyISAM;

The default table type InnoDB does not support FULLTEXT but MyISAM does.
For more details, see
[dev.mysql.com]

Regards,



toivo
Sydney, Australia