Precise Similar Topics

SQL ERROR on Wamp - Precise Similar Topics

SQL ERROR on Wamp

by Binano » Thu Nov 09, 2017 9:54 am

Hello !

I use wamp in localhost. But i have this error :
SQL ERROR [ mysql4 ]

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

SQL

SELECT f.forum_id, f.forum_name, t.*, MATCH (t.topic_title) AGAINST ('parlons pneus') AS score, tt.mark_time, ft.mark_time as f_mark_time FROM (phpbb_topics t) LEFT JOIN phpbb_forums f ON (f.forum_id = t.forum_id) LEFT JOIN phpbb_topics_track tt ON (tt.topic_id = t.topic_id AND tt.user_id = 2) LEFT JOIN phpbb_forums_track ft ON (ft.forum_id = f.forum_id AND ft.user_id = 2) WHERE MATCH (t.topic_title) AGAINST ('parlons pneus') >= 0.5 AND t.topic_status <> 2 AND t.topic_visibility = 1 AND t.topic_time > (UNIX_TIMESTAMP() - 31536000) AND t.topic_id <> 408 AND f.forum_id IN (8, 37) LIMIT 5

BACKTRACE
My tables are MyIsam. Not error when the forum is online. :|
User avatar
Binano
Registered User
Posts: 68
Joined: Thu Jun 25, 2015 9:24 am
Contact:

Re: SQL ERROR on Wamp

by MattF » Thu Nov 09, 2017 11:44 pm

Fully uninstall and reinstall. Also look at the topics table and see if there is indeed a fulltext index on the topic title column.
Formerly known as VSEMy ExtensionsPlease do not PM me for support.
User avatar
MattF
Extensions Development Coordinator
Extensions Development Coordinator
Posts: 5859
Joined: Sat Jan 17, 2009 9:37 am
Location: Los Angeles, CA
Name: Matt Friedman
Contact:

Re: SQL ERROR on Wamp

by Binano » Fri Nov 10, 2017 9:19 pm

I have uninstall and reinstall.
How do I see if there is a full-text index on the title of the column ?
Image

Image
User avatar
Binano
Registered User
Posts: 68
Joined: Thu Jun 25, 2015 9:24 am
Contact:

Re: SQL ERROR on Wamp

by Binano » Sun Nov 19, 2017 8:11 am

Please :oops:
User avatar
Binano
Registered User
Posts: 68
Joined: Thu Jun 25, 2015 9:24 am
Contact:

Re: SQL ERROR on Wamp

by MattF » Sun Nov 19, 2017 8:16 am

Look at the table structure's indexes somewhere in there.
Formerly known as VSEMy ExtensionsPlease do not PM me for support.
User avatar
MattF
Extensions Development Coordinator
Extensions Development Coordinator
Posts: 5859
Joined: Sat Jan 17, 2009 9:37 am
Location: Los Angeles, CA
Name: Matt Friedman
Contact:

Re: SQL ERROR on Wamp

by Binano » Sun Nov 19, 2017 8:20 am

Hello,

MyISAM
Image
User avatar
Binano
Registered User
Posts: 68
Joined: Thu Jun 25, 2015 9:24 am
Contact:

Re: SQL ERROR on Wamp

by MattF » Sun Nov 19, 2017 4:10 pm

Formerly known as VSEMy ExtensionsPlease do not PM me for support.
User avatar
MattF
Extensions Development Coordinator
Extensions Development Coordinator
Posts: 5859
Joined: Sat Jan 17, 2009 9:37 am
Location: Los Angeles, CA
Name: Matt Friedman
Contact:

Re: SQL ERROR on Wamp

by Binano » Sun Nov 19, 2017 5:21 pm

full text

Image
User avatar
Binano
Registered User
Posts: 68
Joined: Thu Jun 25, 2015 9:24 am
Contact:

Re: SQL ERROR on Wamp

by RMcGirr83 » Sun Nov 19, 2017 5:59 pm

superuser wrote:Below the columns definitions is the list of indexes for the table.
Former Modifications/Extensions Team Member | My extensions | github | All requests for support via PM will be ignored
Appreciate the extensions/mods/support then buy me a beer Image
User avatar
RMcGirr83
Former Team Member
Posts: 22016
Joined: Wed Jun 22, 2005 4:33 pm
Location: Your display
Name: Rich McGirr
Contact:

Re: SQL ERROR on Wamp

by Binano » Sun Nov 19, 2017 6:15 pm

RMcGirr83 wrote:
superuser wrote:Below the columns definitions is the list of indexes for the table.
Hello, i'm french... "google translation" is as much as me in english. I don't understand where to find that. I need pictures. :oops:

Image
User avatar
Binano
Registered User
Posts: 68
Joined: Thu Jun 25, 2015 9:24 am
Contact:

Re: SQL ERROR on Wamp

by Binano » Sun Nov 19, 2017 9:19 pm

I have saved the phpbb_topic table, deleted and recreated. It's good ! :shock:

Thanks ! ;)
User avatar
Binano
Registered User
Posts: 68
Joined: Thu Jun 25, 2015 9:24 am
Contact: