Icy Phoenix

Old Support Topics - Similar Topics, Problem!

lom hill [ Sat 05 May, 2007 18:43 ]
Post 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

Mighty Gorgon [ Sun 06 May, 2007 19:11 ]
Post 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: [Hide]

ALTER TABLE `phpbb_topics` ADD FULLTEXT (topic_title);

lom hill [ Thu 10 May, 2007 13:30 ]
Post 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: [Hide]
Code: [Show]
ALTER TABLE `phpbb_topics` ADD FULLTEXT (topic_title);

ok MG thanks...

ThE KuKa [ Thu 10 May, 2007 19:27 ]
Post subject: Re: Similar Topics, Problem!

lom hill, solved?

Greets

lom hill [ Fri 11 May, 2007 01:10 ]
Post subject: Re: Similar Topics, Problem!

yes is solved...

andrea75 [ Fri 11 May, 2007 09:17 ]
Post subject: Re: Similar Topics, Problem!

lom hill wrote: [View Post]
yes is solved...

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

lom hill [ Fri 11 May, 2007 12:31 ]
Post subject: Re: Similar Topics, Problem!

andrea75 wrote: [View Post]
lom hill wrote: [View Post]
yes is solved...

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

ok, sorry...

ThE KuKa [ Fri 11 May, 2007 19:20 ]
Post subject: Re: SOLVED - Similar Topics, Problem!

Edit title to Solved

Thanks!