2008-11-14, 10:31 AM
Hello,
While trying to post a new thread and then simply visit it i encounter this issue:
Can't find FULLTEXT index matching the column list
Query: SELECT t.*, t.username AS threadusername, u.username, MATCH (t.subject) AGAINST ('Depozit Materiale +++ Materials Storage') AS relevance FROM v2forumthreads t LEFT JOIN v2forumusers u ON (u.uid = t.uid) WHERE t.fid='11' AND t.tid!='4' AND t.visible='1' AND t.closed NOT LIKE 'moved|%' AND MATCH (t.subject) AGAINST ('Depozit Materiale +++ Materials Storage') >= '1' ORDER BY t.lastpost DESC LIMIT 0, 15
Any ideas what could be wrong or is it server sql problem?
Thanks.
While trying to post a new thread and then simply visit it i encounter this issue:
Can't find FULLTEXT index matching the column list
Query: SELECT t.*, t.username AS threadusername, u.username, MATCH (t.subject) AGAINST ('Depozit Materiale +++ Materials Storage') AS relevance FROM v2forumthreads t LEFT JOIN v2forumusers u ON (u.uid = t.uid) WHERE t.fid='11' AND t.tid!='4' AND t.visible='1' AND t.closed NOT LIKE 'moved|%' AND MATCH (t.subject) AGAINST ('Depozit Materiale +++ Materials Storage') >= '1' ORDER BY t.lastpost DESC LIMIT 0, 15
Any ideas what could be wrong or is it server sql problem?
Thanks.