Icy Phoenix

     
 


Post new topic  This topic is locked: you cannot edit posts or make replies. 
Page 1 of 1
 
 
Reply with quote Download Post 
Post 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
 




____________
? Lom Hill - Ex-Webmaster
Sorry for my bad English.
Promise's Sons - New Life
 
lom hillSend private message  
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: 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); 

 




____________
Luca
SEARCH is the quickest way to get support.
Icy Phoenix ColorizeIt - CustomIcy - HON
 
Mighty GorgonSend private messageSend e-mail to userVisit poster's website  
Back to topPage bottom
Reply with quote Download Post 
Post 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...
 




____________
? Lom Hill - Ex-Webmaster
Sorry for my bad English.
Promise's Sons - New Life
 
lom hillSend private message  
Back to topPage bottom
Reply with quote Download Post 
Post Re: Similar Topics, Problem! 
 
lom hill, solved?

Greets
 




____________
ThE KuKa - www.phpBB-Es.COM - Custom Installations phpBB
 
ThE KuKaSend private messageVisit poster's website  
Back to topPage bottom
Reply with quote Download Post 
Post Re: Similar Topics, Problem! 
 
yes is solved...      
 




____________
? Lom Hill - Ex-Webmaster
Sorry for my bad English.
Promise's Sons - New Life
 
lom hillSend private message  
Back to topPage bottom
Reply with quote Download Post 
Post Re: Similar Topics, Problem! 
 
lom hill wrote: [View Post]
yes is solved...      


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




____________
My Icy forum: www.lineameteo.it
Staff Member @ IcyPhoenix.com & IcyPhoenix.it
 
andrea75Send private messageVisit poster's website  
Back to topPage bottom
Reply with quote Download Post 
Post 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...
 




____________
? Lom Hill - Ex-Webmaster
Sorry for my bad English.
Promise's Sons - New Life
 
lom hillSend private message  
Back to topPage bottom
Reply with quote Download Post 
Post Re: SOLVED - Similar Topics, Problem! 
 
Edit title to Solved
Thanks!
 




____________
ThE KuKa - www.phpBB-Es.COM - Custom Installations phpBB
 
ThE KuKaSend private messageVisit poster's website  
Back to topPage bottom
Post new topic  This topic is locked: you cannot edit posts or make replies.  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