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

SOLVED Similar Topics, Problem!

This topic is locked: you cannot edit posts or make replies.

 

lom hill
Quote
Posts: 62 Location: Venezuela - Miranda - Tacarigua
Sat 05 May, 2007 18:43
Subject: Similar Topics, Problem!
i hvae a problem with this MOD ... when active this MOD gives me this error:


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, u2.username as user2, u2.user_id as id2, f.forum_id, f.forum_name, p.post_time, p.post_username, MATCH(t.topic_title) AGAINST('Test.. N5') as relevance FROM phpbb_topics t, phpbb_users u, phpbb_forums f, phpbb_posts p, phpbb_users u2 WHERE t.topic_id <> 676 AND t.forum_id IN (32, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29) AND MATCH(t.topic_title) AGAINST('Test.. N5') 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 p.post_time DESC, p.post_time DESC LIMIT 0,5

Line : 865
File : viewtopic.php


help em, Please

Profile PM   YIM Skype
Mighty Gorgon
Quote
Posts: 7192 Location: Borgo San Michele
Sun 06 May, 2007 19:11
Subject: Re: Similar Topics, Problem!
You didn't upgrade properly.

Rerun update_to_ip.php...

Or try just this to see if it solves your problem.

Code: [Download] [Hide]
  1. ALTER TABLE `phpbb_topics` ADD FULLTEXT (topic_title); 

Profile PM   Website
lom hill
Quote
Posts: 62 Location: Venezuela - Miranda - Tacarigua
Thu 10 May, 2007 13:30
Subject: Re: Similar Topics, Problem!
Mighty Gorgon wrote: [View Post]
You didn't upgrade properly.

Rerun update_to_ip.php...

Or try just this to see if it solves your problem.

Code: [Download] [Hide]
  1. ALTER TABLE `phpbb_topics` ADD FULLTEXT (topic_title); 


ok MG thanks...

Profile PM   YIM Skype
ThE KuKa
Quote
Posts: 489 Location: Sabadell
Thu 10 May, 2007 19:27
Subject: Re: Similar Topics, Problem!
lom hill, solved?

Greets

Profile PM   Website MSN Skype
lom hill
Quote
Posts: 62 Location: Venezuela - Miranda - Tacarigua
Fri 11 May, 2007 01:10
Subject: Re: Similar Topics, Problem!
yes is solved... :mryellow: :mryellow: :mryellow:

Profile PM   YIM Skype
andrea75
Quote
Posts: 379 Location: Perugia
Fri 11 May, 2007 09:17
Subject: Re: Similar Topics, Problem!
lom hill wrote: [View Post]
yes is solved... :mryellow: :mryellow: :mryellow:


Next time tell us if you solved the problem, ok?

Profile PM   Website YIM MSN Skype ICQ
lom hill
Quote
Posts: 62 Location: Venezuela - Miranda - Tacarigua
Fri 11 May, 2007 12:31
Subject: Re: Similar Topics, Problem!
andrea75 wrote: [View Post]
lom hill wrote: [View Post]
yes is solved... :mryellow: :mryellow: :mryellow:


Next time tell us if you solved the problem, ok?



ok, sorry...

Profile PM   YIM Skype
ThE KuKa
Quote
Posts: 489 Location: Sabadell
Fri 11 May, 2007 19:20
Subject: Re: SOLVED - Similar Topics, Problem!
Edit title to Solved :wink:
Thanks!

Profile PM   Website MSN Skype
This topic is locked: you cannot edit posts or make replies.
 

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.0619s (PHP: 29% SQL: 71%)
SQL queries: 10 - Debug Off - GZIP Enabled