2010-11-04, 11:35 AM
Quote:MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
1191 - Can't find FULLTEXT index matching the column list
Query:
SELECT t.*, t.username AS threadusername, u.username, MATCH (t.subject) AGAINST ('Hanya di malaysia[pic]') AS relevance FROM asyikcakap_threads t LEFT JOIN asyikcakap_users u ON (u.uid = t.uid) WHERE t.fid='9' AND t.tid!='4' AND t.visible='1' AND t.closed NOT LIKE 'moved|%' AND MATCH (t.subject) AGAINST ('Hanya di malaysia[pic]') >= '1' ORDER BY t.lastpost DESC LIMIT 0, 10
can some1 help me...what problem with this error???