Sphinx Search

[orban]

I didn't add anything, make sure you have the mysql-dev stuff installed. What error you getting?

[TECK]

Not getting any errors, just wanted to make sure before I compile it.
I'll let you know if anything comes up.

[ubuntu-geek]

I also added a "$vbulletin->GPC['nocache'] = true;" to the search_process_start hook, I had some queries that stuck and I think that's because vB cached some queries and did some very bad re-sorting on those....try it out.

Could you give me a hint on this one

[orban]

Meh I think it was because I deleted the full text indices and ran a MATCH (...) AGAINST query....and mysql kinda crashed...

Should be safe to enable it again.

[ubuntu-geek]

gotcha ok

[mute]

Originally Posted by orban

I think I'll do it every 3 days but I don't know yet, we're not very busy right now so the delta indices are quite small.

--------------------------------------------------------------------------------------------------------

I fail to see why this works and I still think there's missing data in these results....

Updated sphinx.conf

Added "IF(firstpostid=0,99999999,firstpostid) as firstpostid" to fields list and "sql_group3_column = firstpostid"

you only need to rebuilt the thread indices.

http://dragy.de/public/sphinx.conf

Updated includes/sphinx.php

http://dragy.de/public/sphinx.php.txt

Update search_forums template

Readded the show as threads, show as posts options...

Rolled back navbar and FORUMDISPLAY templates....back to "show as thread" "show as posts"....

http://dragy.de/public/sphinx_search...s.template.txt

Updated search.php

Remove

else
		{
			// bug fix because we don't have "show as posts/threads" anymore
			if ($vbulletin->GPC['starteronly'])
			{
				$vbulletin->GPC['showposts'] = 0;
			}
			else
			{
				$vbulletin->GPC['showposts'] = 1;
			}
			// end bug fix
		}

I also added a "$vbulletin->GPC['nocache'] = true;" to the search_process_start hook, I had some queries that stuck and I think that's because vB cached some queries and did some very bad re-sorting on those....try it out.

Can someone summarize what's going on here? I got sorta lost. Are you guys trying to figure out how to do the "view as posts, view as threads" options using sphinx, or making it so those options fall back on the vb search?

[orban]

"Are you guys trying to figure out how to do the "view as posts, view as threads" options using sphinx"

Yes and it seems to work, too.

[mute]

hm, I suppose I will give it a shot then!

Mine seems to be working as intended! Do you guys think the "$vbulletin->GPC['nocache'] = true;" bit in the search hook is needed? I love how this hack seems to be getting simpler as time goes on

[TECK]

I just made a script, that will compile easier Sphinx.
It's for people who are not really comfortable with Unix.

1. Open you SSH utility and type vim installscript > Press Enter.

2. Press i (Insert).

3. Paste the following script:

#!/bin/bash
# -----------------------------------------------------------
# Sphinx Compiler
# -----------------------------------------------------------
# This script will compile the Sphinx search engine.
# Make sure you verify all file locations and versions
# before you run this script!
#
# ---------------------------
# Directory Extensions
# ---------------------------
DST_DIR=${HOME}/dist
SPH_DIR=${HOME}/sphinx
SRC_DIR=${HOME}/source
SQL_DIR=/usr
#
# ---------------------------
# File Versions
# ---------------------------
SPHINX="sphinx-0.9.6"
#
# ---------------------------
# File Locations
# ---------------------------
SPHINX_URL="http://sphinxsearch.com/downloads"
#
# ---------------------------
# Install Functions
# ---------------------------
function print_step()
{
	tput cud1 ; tput bold
	echo $1
	tput sgr0
}
function install_ok()
{
	if [ $? -ne 0 ] ; then
		tput bel
		print_step "An error occured during the install. Exiting now..."
		exit 1
	else
		tput bold
		echo "OK."
		tput sgr0
	fi
}
#
# ---------------------------
# SOURCE Directories
# ---------------------------
print_step "Creating the source directories..."
mkdir -p ${DST_DIR}
mkdir -p ${SRC_DIR}
install_ok
#
# ---------------------------
# Download SPHINX archive
# ---------------------------
cd ${DST_DIR}
print_step "Downloading the ${SPHINX} archive..."
wget -nc ${SPHINX_URL}/${SPHINX}.tar.gz
install_ok
cd ${SRC_DIR}
print_step "Extracting the ${SPHINX} archive..."
tar -xzf ${DST_DIR}/${SPHINX}.tar.gz
install_ok
#
# ---------------------------
# SPHINX Install
# ---------------------------
print_step "Creating the install directories..."
mkdir -p ${SPH_DIR}
install_ok
cd ${SRC_DIR}/${SPHINX}
print_step "Starting the ${SPHINX} install..."
sh ./configure --prefix=${SPH_DIR} --with-mysql=${SQL_DIR}
make
install_ok
make install
install_ok
#
# ---------------------------
# Install Cleanup
# ---------------------------
print_step "Deleting all not needed files and folders..."
cd ~
rm -fr ${DST_DIR}
rm -fr ${SRC_DIR}
install_ok
print_step "Install completed successfully."
#
# -------------------------------------------------------
# END
# -------------------------------------------------------

4. Press ESC.

5. Type :wq (Write Quit) > Press Enter.

6. Type chmod +x installscript > Press Enter.

7. Type ./installscript > Press Enter.

Wait for install completion and read the messages.
Post any wierd errors here. You are done.

[mute]

I also made a diff against the hacked search.php for vBulletin 3.6.2. To apply, just "patch -p0 < sphinx_search_362.diff" in your src dir.

http://junglist.org/sphinx_search_362.diff