BaBa2002
07-29-2003, 08:16 PM
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/board/showthread.php?threadid=4
Referer: http://www.blowreactor.com/board/forumdisplay.php?forumid=2
Repair Report: This type of error cannot be automatically repaired.
who can help me? please
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/board/showthread.php?threadid=4
Referer: http://www.blowreactor.com/board/forumdisplay.php?forumid=2
Repair Report: This type of error cannot be automatically repaired.
who can help me? please