SOLVED Could Not Get Main Informatiion For Similar Topics


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

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

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: [Download] [Hide]
  1. ALTER TABLE `phpbb_topics` ADD FULLTEXT (topic_title); 

Profile PM  
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

Subject: Re: Could Not Get Main Informatiion For Similar Topics
You are welcome :mricy:

Profile PM  
Subject: Re: Could Not Get Main Informatiion For Similar Topics
That took care of the problem. Thanks for the tip Steffen. Topic closed.

Subject: Re: [SOLVED] Could Not Get Main Informatiion For Similar Topics
You are welcome sunwest,

Topic SOLVED not closed :mricy:

Profile PM  

Page 1 of 1


  
You cannot post new topics
You cannot reply to topics
You cannot edit your posts
You cannot delete your posts
You cannot vote in polls
You cannot attach files
You can download files
You cannot post calendar events

   

This is a "Lo-Fi" version of our main content. To view the full version with more information, formatting and images, please click here.

Powered by Icy Phoenix based on phpBB
Generation Time: 0.0853s (PHP: 19% SQL: 81%)
SQL queries: 10 - Debug Off - GZIP Enabled