I suddenly began getting the following error. I have cleared the cache and optimized the database with no success.
I'm using ICP version 1.3.0.53a; PHP version 5.2.14; and MySQL version 5.1.47
Quote:
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, u.user_active, u.user_color, u2.username as user2, u2.user_id as id2, u2.user_active as user_active2, u2.user_color as user_color2, f.forum_id, f.forum_name, p.post_time, p.post_username, MATCH(t.topic_title) AGAINST('Now You Can Read World Latest News (ID 20022)') as relevance FROM ip_topics t, ip_users u, ip_forums f, ip_posts p, ip_users u2 WHERE t.topic_id <> 58 AND t.forum_id IN (1, 5, 2, 4, 3, 8, 9, 10, 11, 7, 12, 13, 14) AND MATCH(t.topic_title) AGAINST('Now You Can Read World Latest News (ID 20022)') 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 relevance DESC LIMIT 0,5
Line : 915
File : viewtopic.php