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
I don't know how to convert the tables also doing if my board gone i will also be in problem.
-
- Registered User
- Posts: 6
- Joined: Thu May 10, 2012 6:10 pm
- Contact:
Re: Can't find FULLTEXT index matching the column list [1191
Please do not PM me for support.
Dictated but not read.
- VSE
- Extensions Development Coordinator
- Posts: 4571
- 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
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.
-
- Registered User
- Posts: 6
- Joined: Thu May 10, 2012 6:10 pm
- Contact:
Re: Can't find FULLTEXT index matching the column list [1191
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
Please do not PM me for support.
Dictated but not read.
- VSE
- Extensions Development Coordinator
- Posts: 4571
- 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
After that uninstall and reinstall worked. Anyway lot of thank for your time and prompt support.
-
- Registered User
- Posts: 6
- Joined: Thu May 10, 2012 6:10 pm
- Contact: