Precise Similar Topics

*SOLUTION* Can't find FULLTEXT index .... - Precise Similar Topics

*SOLUTION* Can't find FULLTEXT index ....

by motte » Wed Jun 13, 2018 8:17 pm

I get this error after activating in the forum, even after deleting the extension and reinstalling

Code: Select all

SQL ERROR [ mysqli ]

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

SQL

SELECT f.forum_id, f.forum_name, t.*, MATCH (t.topic_title) AGAINST ('benziner automatikgetriebe') AS score, tt.mark_time, ft.mark_time as f_mark_time FROM (phpbb3_topics t) LEFT JOIN phpbb3_forums f ON (f.forum_id = t.forum_id) LEFT JOIN phpbb3_topics_track tt ON (tt.topic_id = t.topic_id AND tt.user_id = 919) LEFT JOIN phpbb3_forums_track ft ON (ft.forum_id = f.forum_id AND ft.user_id = 919) WHERE MATCH (t.topic_title) AGAINST ('benziner automatikgetriebe') >= 0.5 AND t.topic_status <> 2 AND t.topic_visibility = 1 AND t.topic_time > (UNIX_TIMESTAMP() - 31536000) AND t.topic_id <> 19176 AND f.similar_topics_ignore = 0 LIMIT 5

BACKTRACE

FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()

FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 996
CALL: trigger_error()

FILE: [ROOT]/phpbb/db/driver/mysqli.php
LINE: 193
CALL: phpbb\db\driver\driver->sql_error()

FILE: [ROOT]/phpbb/db/driver/mysql_base.php
LINE: 45
CALL: phpbb\db\driver\mysqli->sql_query()

FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 270
CALL: phpbb\db\driver\mysql_base->_sql_query_limit()

FILE: [ROOT]/phpbb/db/driver/factory.php
LINE: 321
CALL: phpbb\db\driver\driver->sql_query_limit()

FILE: [ROOT]/ext/vse/similartopics/core/similar_topics.php
LINE: 210
CALL: phpbb\db\driver\factory->sql_query_limit()

FILE: [ROOT]/ext/vse/similartopics/event/listener.php
LINE: 63
CALL: vse\similartopics\core\similar_topics->display_similar_topics()

FILE: (not given by php)
LINE: (not given by php)
CALL: vse\similartopics\event\listener->display_similar_topics()

FILE: [ROOT]/vendor/symfony/event-dispatcher/EventDispatcher.php
LINE: 184
CALL: call_user_func()

FILE: [ROOT]/vendor/symfony/event-dispatcher/EventDispatcher.php
LINE: 46
CALL: Symfony\Component\EventDispatcher\EventDispatcher->doDispatch()

FILE: [ROOT]/phpbb/event/dispatcher.php
LINE: 62
CALL: Symfony\Component\EventDispatcher\EventDispatcher->dispatch()

FILE: [ROOT]/phpbb/event/dispatcher.php
LINE: 46
CALL: phpbb\event\dispatcher->dispatch()

FILE: [ROOT]/viewtopic.php
LINE: 2296
CALL: phpbb\event\dispatcher->trigger_event()
Edit: I find my Problem here, https://www.phpbb.com/customise/db/mod/ ... opic/91156 But even when I do the changes, it don't fixed the Problem.
Last edited by motte on Mon Aug 13, 2018 12:06 pm
Renault Scenic Forum 🚘 since 2003 ...

... lover of Modeltrains 🚂🚃🚃
User avatar
motte
Registered User
Posts: 73
Joined: Wed Jan 30, 2013 10:15 pm
Name: Ralph

Re: SQL Error

by motte » Sat Aug 04, 2018 4:12 pm

well i droped the topic_title Table an recreate ist but nothing worked

i checked the Settings for the topic_title Table

-> topic_titleIndex varchar(255) | utf8_bin | fulltext

i dont know what's wrong ....
Renault Scenic Forum 🚘 since 2003 ...

... lover of Modeltrains 🚂🚃🚃
User avatar
motte
Registered User
Posts: 73
Joined: Wed Jan 30, 2013 10:15 pm
Name: Ralph

Re: SQL Error

by motte » Mon Aug 13, 2018 12:11 pm

Also, Change the Format from phpbb_topics from MyISAM to InnoDB, after back to MyISAM. After all the Ext Worked
Renault Scenic Forum 🚘 since 2003 ...

... lover of Modeltrains 🚂🚃🚃
User avatar
motte
Registered User
Posts: 73
Joined: Wed Jan 30, 2013 10:15 pm
Name: Ralph

Re: *SOLUTION* Can't find FULLTEXT index ....

by Binano » Sat Mar 21, 2020 7:18 am

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