https://www.icyphoenix.com/viewtopic.php?f=35&t=1846&p=13450#p13450
-----------------------------------
lom hill
Sat 05 May, 2007 18:43

Similar Topics, Problem!
-----------------------------------
i hvae a problem with this MOD ... when active this MOD gives me this error:

[color=red]
Could not get main information for similar topics

DEBUG MODE

SQL Error : 1191 Can't find FULLTEXT index matching the column list

SELECT t.*, u.user_id, u.username, u2.username as user2, u2.user_id as id2, f.forum_id, f.forum_name, p.post_time, p.post_username, MATCH(t.topic_title) AGAINST('Test.. N5') as relevance FROM phpbb_topics t, phpbb_users u, phpbb_forums f, phpbb_posts p, phpbb_users u2 WHERE t.topic_id <> 676 AND t.forum_id IN (32, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29) AND MATCH(t.topic_title) AGAINST('Test.. N5') AND t.forum_id = f.forum_id AND p.poster_id = u2.user_id AND p.post_id = t.topic_last_post_id AND t.topic_poster = u.user_id AND t.topic_status <> 2 GROUP BY t.topic_id ORDER BY p.post_time DESC, p.post_time DESC LIMIT 0,5

Line : 865
File : viewtopic.php
[/color]

help em, Please


