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.
[19 Nov 2004 7:19] Victoria Reznichenko
Hi,
Full-text search is supported only on MyISAM table type. What is the type of ibf_posts
table?
[14 Feb 2005 23:54] Bugs System
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".
[16 Nov 2007 22:16] Galicia Badillo
ALTER TABLE my_table ENGINE = MYISAM;
Do this before the FullText add, even if the engine database default is already MyISAM
[31 Aug 2008 15:39] Nadeem Akram
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