Warning: The author of this contribution does not provide support for it anymore.

Precise Similar Topics II

Can't find FULLTEXT index matching the column list [1191] - Precise Similar Topics II

Re: Can't find FULLTEXT index matching the column list [1191

by SOMU » Fri May 11, 2012 4:17 am

Then there is no way for me to enjoy this beautiful mod. I install it with no problem in my test phpbb3 .10 borad but in my main board this the problem. If possible try to create a fix. or next version release i have to wait.

I don't know how to convert the tables also doing if my board gone i will also be in problem.
SOMU
Registered User
Posts: 6
Joined: Thu May 10, 2012 6:10 pm
Contact:

Re: Can't find FULLTEXT index matching the column list [1191

by VSE » Fri May 11, 2012 5:08 am

Official phpBB Extensions My Extensions & MODs
Please do not PM me for support.
Dictated but not read.
User avatar
VSE
Extensions Development Coordinator
Extensions Development Coordinator
Posts: 4458
Joined: Sat Jan 17, 2009 9:37 am
Location: Los Angeles, CA
Name: Matt Friedman
Contact:

Re: Can't find FULLTEXT index matching the column list [1191

by SOMU » Fri May 11, 2012 7:33 pm

VSE wrote:Your problem is your tables are not MyISAM as is required by this MOD.


My tables are already MyISAM and when i try to add full text i got the error as shown by surendra204 in above picture. topic_title in BLOB and it don't allow to to change it to full text.

# 1283- topic_title' cannot be part of FULLTEXT index


topic title shown as BLOB . Can you tell me how i can change it to VARCHAR ( 255 ) . I think that may work for it.
SOMU
Registered User
Posts: 6
Joined: Thu May 10, 2012 6:10 pm
Contact:

Re: Can't find FULLTEXT index matching the column list [1191

by VSE » Fri May 11, 2012 8:06 pm

SOMU wrote:
VSE wrote:Your problem is your tables are not MyISAM as is required by this MOD.


My tables are already MyISAM and when i try to add full text i got the error as shown by surendra204 in above picture. topic_title in BLOB and it don't allow to to change it to full text.

# 1283- topic_title' cannot be part of FULLTEXT index


topic title shown as BLOB . Can you tell me how i can change it to VARCHAR ( 255 ) . I think that may work for it.


Click the Edit Action icon for the topic_title row in the phpbb_topics table, and change it to VARCHAR with a length of 255
Official phpBB Extensions My Extensions & MODs
Please do not PM me for support.
Dictated but not read.
User avatar
VSE
Extensions Development Coordinator
Extensions Development Coordinator
Posts: 4458
Joined: Sat Jan 17, 2009 9:37 am
Location: Los Angeles, CA
Name: Matt Friedman
Contact:

Re: Can't find FULLTEXT index matching the column list [1191

by SOMU » Sat May 12, 2012 10:12 am

A lot thank for your super mod. That worked . BLOB >>> VARCHAR , LENGTH 255 , COLLECTION >>>utf8_bin , Null >>>no , DEFAULT >>>>none. Its teh setting i made while converting from BLOB to VACHAR.

After that uninstall and reinstall worked. Anyway lot of thank for your time and prompt support.
SOMU
Registered User
Posts: 6
Joined: Thu May 10, 2012 6:10 pm
Contact:


cron