MySQL Bugs: #6713: The used table type doesn't support FULLTEXT indexes

Bug #6713	The used table type doesn't support FULLTEXT indexes
Submitted:	19 Nov 2004 2:18	Modified:	13 Nov 2010 22:13
Reporter:	Jesus Christ	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Server: Command-line Clients	Severity:	S2 (Serious)
Version:	Newest	OS:	Windows (XP)
Assigned to:		CPU Architecture:	Any

Description:
Error 
SQL-query: 

ALTER TABLE ibf_posts ADD FULLTEXT (

post
) 
MySQL said:  

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

How to repeat:
Try installing IPB boards ^.^

Suggested fix:
Don't have one.
Wish to god I did.

Hi,

Full-text search is supported only on MyISAM table type. What is the type of  ibf_posts table?

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".

ALTER TABLE my_table ENGINE = MYISAM;

Do this before the FullText add, even if the engine database default is already MyISAM

Goto /your_ipb_directory/install/sql/mysql_fulltext.php

and instead of:
<?php
$INDEX[] = "alter table ibf_posts ADD FULLTEXT(post)";
$INDEX[] = "alter table ibf_topics ADD FULLTEXT(title)";
?>

change it to:
<?php
$INDEX[] = "ALTER TABLE ibf_posts ENGINE = MYISAM";
$INDEX[] = "ALTER TABLE ibf_topics ENGINE = MYISAM";
$INDEX[] = "alter table ibf_posts ADD FULLTEXT(post)";
$INDEX[] = "alter table ibf_topics ADD FULLTEXT(title)";

?>
and it will install perfectly fine :)
IPB v2.0.0 btw

This is NOT a bug in MySQL! Just lack of knowledge of the guy that reported it.

To install IP.Board, you HAVE to use MyISAM, not InnoDB!