Incompatible with sphinx search?
Searching the wiki results in mysql error
Hello,
I have a big board and thus have to use Sphinx for our forum search. I notice that a new search function ("search wiki") is now added to my "search" navbar dropdown, and it's currently throwing errors after my fresh install:
Code:
Database error in vBulletin 3.6.12:
Invalid SQL:
SELECT prefix.prefixsetid, prefix.prefixid, forumprefixset.forumid
FROM prefix AS prefix
INNER JOIN prefixset AS prefixset ON (prefixset.prefixsetid = prefix.prefixsetid)
INNER JOIN forumprefixset AS forumprefixset ON
(forumprefixset.prefixsetid = prefixset.prefixsetid)
INNER JOIN forum AS forum ON (forum.forumid = forumprefixset.forumid AND forum.vault_type > 0)
ORDER BY prefixset.displayorder, prefix.displayorder;
MySQL Error : Table 'forum.prefix' doesn't exist
Error Number : 1146
Date : Thursday, March 10th 2011 @ 09:18:32 AM
Script : http://www.talkbass.com/forum/search.php?type=wiki
Referrer : http://www.talkbass.com/forum/
IP Address : 33.33.33.33
Username : paul
Classname : vB_Database_MySQLi
Any ideas on a fix? Thanks!