Icy Phoenix

     
 


Post new topic  Reply to topic 
Page 1 of 1
 
 
Reply with quote Download Post 
Post 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

 



 
sunwestSend private messageVisit poster's website  
Back to topPage bottom
Icy Phoenix is an open source project, you can show your appreciation and support future development by donating to the project.

Support us
 
Reply with quote Download Post 
Post 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
 




____________
Out of Order
 
spydieSend private messageVisit poster's website  
Back to topPage bottom
Reply with quote Download Post 
Post 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); 

 




____________
TheSteffen
Often SEARCH is the quickest way to get support.
IcyPhoenix German Support
 
TheSteffenSend private message  
Back to topPage bottom
Reply with quote Download Post 
Post 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
 




____________
Out of Order
 
spydieSend private messageVisit poster's website  
Back to topPage bottom
Reply with quote Download Post 
Post Re: Could Not Get Main Informatiion For Similar Topics 
 
You are welcome  
 




____________
TheSteffen
Often SEARCH is the quickest way to get support.
IcyPhoenix German Support
 
TheSteffenSend private message  
Back to topPage bottom
Reply with quote Download Post 
Post Re: Could Not Get Main Informatiion For Similar Topics 
 
That took care of the problem. Thanks for the tip Steffen. Topic closed.
 



 
sunwestSend private messageVisit poster's website  
Back to topPage bottom
Reply with quote Download Post 
Post Re: [SOLVED] Could Not Get Main Informatiion For Similar Topics 
 
You are welcome sunwest,

Topic SOLVED not closed  
 




____________
TheSteffen
Often SEARCH is the quickest way to get support.
IcyPhoenix German Support
 
TheSteffenSend private message  
Back to topPage bottom
Post new topic  Reply to topic  Page 1 of 1
 


Display posts from previous:    

HideWas this topic useful?

Link this topic
URL
BBCode
HTML




 
Permissions List
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