Icy Phoenix :: View topic - Could Not Get Main Informatiion For Similar Topics

Old Support Topics - Could Not Get Main Informatiion For Similar Topics

sunwest [ Thu 05 Aug, 2010 17:49 ]
Post subject: Could Not Get Main Informatiion For Similar Topics

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

spydie [ Thu 05 Aug, 2010 20:02 ]
Post subject: Re: Could Not Get Main Informatiion For Similar Topics

I have the same problem in one of my sites.

only thing is, disable the similar topics option main switch in acp

TheSteffen [ Thu 05 Aug, 2010 23:21 ]
Post subject: Re: Could Not Get Main Informatiion For Similar Topics

Take a look here:
http://www.icyphoenix.com/viewtopic.php?f=35&t=1846

FULLTEXT is needed in DB

Code: [Hide]

ALTER TABLE `phpbb_topics` ADD FULLTEXT (topic_title);

spydie [ Thu 05 Aug, 2010 23:43 ]
Post subject: Re: Could Not Get Main Informatiion For Similar Topics

seems to have been a problem in .53 and patch 53.a .

cause in 53.a fullpack this worked directly.

thanks steffen

TheSteffen [ Thu 05 Aug, 2010 23:55 ]
Post subject: Re: Could Not Get Main Informatiion For Similar Topics

You are welcome

sunwest [ Fri 06 Aug, 2010 14:44 ]
Post subject: Re: Could Not Get Main Informatiion For Similar Topics

That took care of the problem. Thanks for the tip Steffen. Topic closed.

TheSteffen [ Mon 09 Aug, 2010 00:41 ]
Post subject: Re: [SOLVED] Could Not Get Main Informatiion For Similar Topics

You are welcome sunwest,

Topic SOLVED not closed