Home •  Forum •  FAQ •  Search •  Recent Topics •  Memberlist •  Register •  Log in 
Forum » Icy Phoenix Support » Older Versions Archive » Old Support Topics

SOLVED Could Not Get Main Informatiion For Similar Topics

Reply to topic

 

sunwest
Quote
Posts: 38 Location: Phoenix, AZ USA
Thu 05 Aug, 2010 17:49
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

Profile PM   Website
spydie
Quote
Posts: 1796 Location: In the Boxes
Thu 05 Aug, 2010 20:02
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

Profile PM   Website MSN
TheSteffen
Quote
Posts: 1625 Location: Magdeburg
Thu 05 Aug, 2010 23:21
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  
spydie
Quote
Posts: 1796 Location: In the Boxes
Thu 05 Aug, 2010 23:43
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

Profile PM   Website MSN
TheSteffen
Quote
Posts: 1625 Location: Magdeburg
Thu 05 Aug, 2010 23:55
Subject: Re: Could Not Get Main Informatiion For Similar Topics
You are welcome :mricy:

Profile PM  
sunwest
Quote
Posts: 38 Location: Phoenix, AZ USA
Fri 06 Aug, 2010 14:44
Subject: Re: Could Not Get Main Informatiion For Similar Topics
That took care of the problem. Thanks for the tip Steffen. Topic closed.

Profile PM   Website
TheSteffen
Quote
Posts: 1625 Location: Magdeburg
Mon 09 Aug, 2010 00:41
Subject: Re: [SOLVED] Could Not Get Main Informatiion For Similar Topics
You are welcome sunwest,

Topic SOLVED not closed :mricy:

Profile PM  
Reply to topic
 

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