[WARNING] Enabled Related topics

phpBB SEO Premod for phpBB3 support forum.
This premodded version of phpBB3 includes the three different type of URL rewriting for phpBB3 by phpBB SEO. It comes with several other Search Engine Optimization mods installed.

Moderator: Moderators

[WARNING] Enabled Related topics

Postby Josh » Sat Oct 29, 2011 2:49 pm

I just installed phpbb SEO Premod v3.0.9, and when I set Related topics activation to Enabled, I got this warning:

Code: Select all
Warning

Related topics : SQL error [ mysql4 ] : The used table type doesn't support FULLTEXT indexes [1214]
The db user does not seems to have enough rights to run the required SQL query, please run it manually (phpMyadmin) :
ALTER TABLE phpbb_topics ADD FULLTEXT topic_tft (topic_title)


So I run like this in mySQL:
Code: Select all
ALTER TABLE phpbb_topics ADD FULLTEXT topic_tft (topic_title)


But I got this error:
Code: Select all
#1214 - The used table type doesn't support FULLTEXT indexes


How I run this script on mySQL?

Sorry for my English. :oops:
Thanks a lot for your answer..
:)
Josh
 
Posts: 3
Joined: Sat Oct 29, 2011 2:31 pm

Advertisement

Re: [WARNING] Enabled Related topics

Postby Josh » Sun Oct 30, 2011 8:57 am

Hello.. anyone could help me..??

:cry: :cry: :cry:
Josh
 
Posts: 3
Joined: Sat Oct 29, 2011 2:31 pm

Re: [WARNING] Enabled Related topics

Postby Josh » Sun Oct 30, 2011 9:04 am

Okay... I solved it.

Some help from here:
http://forums.phpbb-fr.com/mods-independants-base-phpbb3/sujet172573.html

Just run in mySQL query:
Code: Select all
ALTER TABLE phpbb_topics ENGINE = MyISAM;


And then:
Code: Select all
ALTER TABLE phpbb_topics ADD FULLTEXT topic_tft (topic_title)


I hope this is right.
:mrgreen:
Josh
 
Posts: 3
Joined: Sat Oct 29, 2011 2:31 pm

Re: [WARNING] Enabled Related topics

Postby Stephen26 » Sat Nov 05, 2011 8:01 pm

You might wanna check your other tables and see if they are MyISAM (and if not, why)?
I install and configure phpBB-SEO (and other mods) for a fair price and very fast. If you are interested simply send me a private message.
Stephen26
phpBB SEO Team
phpBB SEO Team
 
Posts: 434
Joined: Mon May 03, 2010 7:06 am

Re: [WARNING] Enabled Related topics

Postby irek34 » Sun Nov 11, 2012 6:53 pm

Just run in mySQL query:
Code: Select all
ALTER TABLE phpbb_topics ENGINE = MyISAM;


And then:
Code: Select all
ALTER TABLE phpbb_topics ADD FULLTEXT topic_tft (topic_title)


I had the same problem but it helped me, thank You! :-)
irek34
 
Posts: 5
Joined: Thu Nov 08, 2012 10:33 am


Return to phpBB SEO Premod

 


  • Related topics
    Replies
    Views
    Last post

Who is online

Users browsing this forum: No registered users and 1 guest