phpBB • Free and Open Source Forum Software

RSS Facebook Twitter
Menu
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

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

by 7emper5i » Fri Apr 01, 2011 9:03 pm

Hi everyone,

I had no error while the installation process.

But when I try to access one of my topics I get the following error:

Code: Select all

SQL ERROR [ mysql4 ]

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

SQL

SELECT f.forum_id, f.forum_name, t.topic_id, t.topic_title, t.topic_time, t.topic_views, t.topic_replies, t.topic_poster, t.topic_first_poster_name, t.topic_first_poster_colour, MATCH (t.topic_title) AGAINST ('urlaubs bescheid mods/add') as score FROM (phpbb_topics t) LEFT JOIN phpbb_forums f ON (f.forum_id = t.forum_id) WHERE MATCH (t.topic_title) AGAINST ('urlaubs bescheid mods/add') >= 0.5 AND t.topic_status <> 2 AND t.topic_time > (UNIX_TIMESTAMP() - 2592000) AND t.topic_id <> 28105 LIMIT 5

BACKTRACE

FILE: includes/db/mysql.php
LINE: 175
CALL: dbal->sql_error()

FILE: includes/db/mysql.php
LINE: 222
CALL: dbal_mysql->sql_query()

FILE: includes/db/dbal.php
LINE: 170
CALL: dbal_mysql->_sql_query_limit()

FILE: includes/functions_similar_topics.php
LINE: 90
CALL: dbal->sql_query_limit()

FILE: viewtopic.php
LINE: 1782
CALL: similar_topics()
User avatar
7emper5i
Registered User
Posts: 118
Joined: Mon May 04, 2009 5:31 pm
Location: Germany Cologne
Name: Philipp R.
Top

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

by MattF » Fri Apr 01, 2011 9:53 pm

Is your MySQL database table in the MyISAM format? They must be MyISAM for this mod to work. You can find out by looking at your database tables in phpMyAdmin.

INNODB, Archive will not work.
Formerly known as VSE • My Extensions • Please do not PM me for support.
User avatar
MattF
Extensions Development Coordinator
Extensions Development Coordinator
Posts: 6109
Joined: Sat Jan 17, 2009 9:37 am
Location: Los Angeles, CA
Name: Matt Friedman
Top

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

by 7emper5i » Fri Apr 01, 2011 10:08 pm

Image

As you can see, they are. I don't have a clue, what might went wrong.

Do you want to get screenshots from the successful UMIL-Installationprocess via the:

install_similar_topics.php?

regards,
P!
User avatar
7emper5i
Registered User
Posts: 118
Joined: Mon May 04, 2009 5:31 pm
Location: Germany Cologne
Name: Philipp R.
Top

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

by MattF » Fri Apr 01, 2011 11:10 pm

Go to the phpbb_topics table and view the structure, check the box next to topic_title and then click the fulltext icon at the bottom of phpMyAdmin (it looks like a T)
Formerly known as VSE • My Extensions • Please do not PM me for support.
User avatar
MattF
Extensions Development Coordinator
Extensions Development Coordinator
Posts: 6109
Joined: Sat Jan 17, 2009 9:37 am
Location: Los Angeles, CA
Name: Matt Friedman
Top

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

by 7emper5i » Fri Apr 01, 2011 11:38 pm

I checked the topics table and as you can see, it is "fulltext".

Image
User avatar
7emper5i
Registered User
Posts: 118
Joined: Mon May 04, 2009 5:31 pm
Location: Germany Cologne
Name: Philipp R.
Top

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

by MattF » Fri Apr 01, 2011 11:44 pm

Well then I don't know why it isn't working for you. Sorry :(
Formerly known as VSE • My Extensions • Please do not PM me for support.
User avatar
MattF
Extensions Development Coordinator
Extensions Development Coordinator
Posts: 6109
Joined: Sat Jan 17, 2009 9:37 am
Location: Los Angeles, CA
Name: Matt Friedman
Top

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

by MattF » Fri Apr 01, 2011 11:56 pm

Try this:

Go back to the phpbb_topics structure page. At the bottom of the page should be a list of indexes. DROP the one for topic_title.

Then try the SQL statement to recreate it again.:
ALTER TABLE phpbb_topics ADD FULLTEXT (topic_title)

Of course, don't do any of this unless your db is backed up first.
Formerly known as VSE • My Extensions • Please do not PM me for support.
User avatar
MattF
Extensions Development Coordinator
Extensions Development Coordinator
Posts: 6109
Joined: Sat Jan 17, 2009 9:37 am
Location: Los Angeles, CA
Name: Matt Friedman
Top

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

by 7emper5i » Sat Apr 02, 2011 12:06 am

I'll give it a try, thx!
User avatar
7emper5i
Registered User
Posts: 118
Joined: Mon May 04, 2009 5:31 pm
Location: Germany Cologne
Name: Philipp R.
Top

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

by surendra204 » Fri Oct 28, 2011 2:07 am

hello i too getting the same problem.

in my Myphpadmin i went to the locations as you said and i got this screen but i cant find full text

similar.png


i upload the screen shot as a attachment download it and pelase give me any suggession
surendra204
Registered User
Posts: 14
Joined: Tue Dec 08, 2009 2:56 pm
Top

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

by surendra204 » Fri Oct 28, 2011 2:13 am

while trying to see a post i am getting error

Code: Select all

SQL ERROR [ mysql4 ]

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

SQL

SELECT f.forum_id, f.forum_name, t.topic_id, t.topic_title, t.topic_time, t.topic_views, t.topic_replies, t.topic_poster, t.topic_first_poster_name, t.topic_first_poster_colour, MATCH (t.topic_title) AGAINST ('Bharat Electronics Limited Across India Graduate Apprent') as score FROM (studentsadda_topics t) LEFT JOIN studentsadda_forums f ON (f.forum_id = t.forum_id) WHERE MATCH (t.topic_title) AGAINST ('Bharat Electronics Limited Across India Graduate Apprent') >= 0.5 AND t.topic_status <> 2 AND t.topic_time > (UNIX_TIMESTAMP() - 31536000) AND t.topic_id <> 3780 LIMIT 5

BACKTRACE

FILE: includes/db/mysql.php
LINE: 175
CALL: dbal->sql_error()

FILE: includes/db/mysql.php
LINE: 222
CALL: dbal_mysql->sql_query()

FILE: includes/db/dbal.php
LINE: 170
CALL: dbal_mysql->_sql_query_limit()

FILE: includes/functions_similar_topics.php
LINE: 90
CALL: dbal->sql_query_limit()

FILE: viewtopic.php
LINE: 1807
CALL: similar_topics()
Attachments
similar error.png
surendra204
Registered User
Posts: 14
Joined: Tue Dec 08, 2009 2:56 pm
Top

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

by MattF » Fri Oct 28, 2011 4:53 am

There is something wrong with your topic_titles. It is listed as a Binary BLOB. That is not correct. It should be VARCHAR(255).

I don't know why your topic_titles are a BLOB, but that is the reason they can't be enabled as a FULLTEXT index.
Formerly known as VSE • My Extensions • Please do not PM me for support.
User avatar
MattF
Extensions Development Coordinator
Extensions Development Coordinator
Posts: 6109
Joined: Sat Jan 17, 2009 9:37 am
Location: Los Angeles, CA
Name: Matt Friedman
Top

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

by surendra204 » Fri Oct 28, 2011 7:35 am

hmmm then what is the solution for this ?
surendra204
Registered User
Posts: 14
Joined: Tue Dec 08, 2009 2:56 pm
Top

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

by MattF » Fri Oct 28, 2011 9:12 am

You could try changing it back to VARCHAR in phpMyAdmin. But I don't know if that might screw up all your topics titles. Best to try on a copy of your DB on an offline/local server.

And you should also figure out how it got changed to BLOB in the first place.... Some other MOD perhaps?
Formerly known as VSE • My Extensions • Please do not PM me for support.
User avatar
MattF
Extensions Development Coordinator
Extensions Development Coordinator
Posts: 6109
Joined: Sat Jan 17, 2009 9:37 am
Location: Los Angeles, CA
Name: Matt Friedman
Top

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

by SOMU » Thu May 10, 2012 7:58 pm

I am having same problem

Precise Similar Topics II
PHP Version: 5.2.17
DBMS: MySQL(i) 5.5.21-55
phpBB3 Version: 3.0.10

Adding FULLTEXT index: topic_title
SQL ERROR Column 'topic_title' cannot be part of FULLTEXT index

Got this error when i install this mod. I am running phpbb3 .10 , my also topic_titles It is listed as a Binary BLOB. I have almost same error waitting for some help. If i enable the mod topic page give same mysql error as in above picture
SOMU
Registered User
Posts: 6
Joined: Thu May 10, 2012 6:10 pm
Top

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

by MattF » Thu May 10, 2012 10:54 pm

Your problem is your tables are not MyISAM as is required by this MOD.
Formerly known as VSE • My Extensions • Please do not PM me for support.
User avatar
MattF
Extensions Development Coordinator
Extensions Development Coordinator
Posts: 6109
Joined: Sat Jan 17, 2009 9:37 am
Location: Los Angeles, CA
Name: Matt Friedman
Top