Issue: Incompatible with sphinx search?

Issue Tools
- View Changes

March 10, 2011 10:23 AM

kontrabass kontrabass is offline

New Member

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!

Issue Details

Issue Number 2256

Issue Type Bug

Project VaultWiki 3.x Series

Category Searching

Status Fixed

Priority 5 - Minor Bugs / Small Tweaks

Affected Version 3.0.11

Fixed Version 3.0.12

Milestone (none)

Software DependencyAny

Users able to reproduce bug 0

Users unable to reproduce bug 0

Attachments 0

Assigned Users (none)

Tags (none)

March 10, 2011 4:47 PM

pegasus

VaultWiki Team

This is not related to Sphinx but that vBulletin 3.6 doesn't have Thread Prefix support.

In vault/functions/search.php, find:

Code:

	// build prefix options

Add before:

Code:

if (!VAULT_36X_COMPAT) {

Find:

Code:

	$prefix_selected = array(
		'any' => ((in_array('', $vbulletin->GPC['prefixchoice']) OR empty($vbulletin->GPC['prefixchoice'])) ? ' selected="selected"' : ''),
		'none' => (in_array('-1', $vbulletin->GPC['prefixchoice']) ? ' selected="selected"' : '')
	);

Add after:

Code:

+ Reply

All times are GMT -4. The time now is 4:52 PM.

This site uses cookies to help personalize content, to tailor your experience, and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.

Learn more… Accept Remind me later

Welcome to VaultWiki.org, home of the wiki add-on for vBulletin and XenForo!

Issue: Incompatible with sphinx search?

Issue Tools