help real urgent!!!!!!!!!!!!

[BaBa2002]

hello
after that i changed from server and i restored mij database again
i have serieus problems when i want to view a tread
check this

Database error in vBulletin 2.3.0:

Invalid SQL: SELECT

thread.threadid,thread.lastposter,thread.title,thr ead.postusername,thread.replycount,thread.

lastpost,thread.postuserid,
thread.dateline,forum.title AS

ftitle,forum.forumid,forum.parentlist
FROM thread
LEFT JOIN forum ON (thread.forumid=forum.forumid)
WHERE thread.threadid<>4 AND thread.forumid IN( 1,3,11,12,13,14,2,5,7,32,6,33,4,8,9,10,15,16,17,18 ,19,20,21,22,24,26,28,30,25,27,29,31 )
AND MATCH(thread.title) AGAINST ('Welkom')
AND thread.open<>10
AND thread.visible=1
ORDER BY dateline DESC
LIMIT 4
mysql error: Can't find FULLTEXT index matching the column list

mysql error number: 1191

Date: Tuesday 29th of July 2003 02:11:20 PM
Script: http://www.blowreactor.com/board/boa...php?threadid=4
Referer: http://www.blowreactor.com/board/for....php?forumid=2
Repair Report: This type of error cannot be automatically repaired.


who can help me? please

[Velocd]

Is this for my similar threads hack? You need to add a fulltext on `title`.

Go in PhpMyAdmin, and run this query:

ALTER TABLE thread ADD FULLTEXT(title);

[BaBa2002]

yes that's help
wow real thanks bro.

[jdennis]

thanks, that just helped me after restoring from backup as well!