Filter Threads By Thread Prefix - MyBB 1.6 Only

[leefish]

ok, I tried it - and no result - I think its because it is looking to do a match as the final piece of the query

PHP Code:

1 2 3 4 5 6 7 8 9

$query = $db->query(" SELECT t.*, t.username AS threadusername, p.displaystyle AS threadprefix, u.username, MATCH (t.subject) AGAINST ('".$db->escape_string($thread['subject'])."') AS relevance FROM ".TABLE_PREFIX."threads t LEFT JOIN ".TABLE_PREFIX."threadprefixes p ON (p.pid = t.prefix) LEFT JOIN ".TABLE_PREFIX."users u ON (u.uid = t.uid) WHERE t.fid='{$thread['fid']}' AND t.tid!='{$thread['tid']}' AND t.visible='1' AND t.prefix='{$thread['prefix']}' AND t.closed NOT LIKE 'moved|%' AND MATCH (t.subject) AGAINST ('".$db->escape_string($thread['subject'])."') >= '{$mybb->settings['similarityrating']}' ORDER BY t.lastpost DESC LIMIT 0, {$mybb->settings['similarlimit']} ");

---

I tried adding this

PHP Code:

1 2 3 4 5 6 7 8 9

$query = $db->query(" SELECT t.*, t.username AS threadusername, p.displaystyle AS threadprefix, u.username, MATCH (t.subject) AGAINST ('".$db->escape_string($thread['subject'])."') AS relevance FROM ".TABLE_PREFIX."threads t LEFT JOIN ".TABLE_PREFIX."threadprefixes p ON (p.pid = t.prefix) LEFT JOIN ".TABLE_PREFIX."users u ON (u.uid = t.uid) WHERE t.fid='{$thread['fid']}' AND t.tid!='{$thread['tid']}' AND t.visible='1' AND t.prefix='{$thread['prefix']}' AND t.closed NOT LIKE 'moved|%' AND MATCH (t.prefix) AGAINST ('".$db->escape_string($thread['prefix'])."') OR MATCH (t.subject) AGAINST ('".$db->escape_string($thread['subject'])."') >= '{$mybb->settings['similarityrating']}' ORDER BY t.lastpost DESC LIMIT 0, {$mybb->settings['similarlimit']} ");

---

and got this error message

Code:

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, p.displaystyle AS threadprefix, u.username, MATCH (t.subject) AGAINST ('SHOESballetenpointe meshes & uvmaps') AS relevance FROM mybb_threads t LEFT JOIN mybb_threadprefixes p ON (p.pid = t.prefix) LEFT JOIN mybb_users u ON (u.uid = t.uid) WHERE t.fid='46' AND t.tid!='1084' AND t.visible='1' AND t.prefix='2' AND t.closed NOT LIKE 'moved|%' AND MATCH (t.prefix) AGAINST ('2') OR MATCH (t.subject) AGAINST ('SHOESballetenpointe meshes & uvmaps') >= '4' ORDER BY t.lastpost DESC LIMIT 0, 10

---