Sphinx Search

[mute]

Has anyone else had any luck with making Sphinx search for threads started and all posts by username?

I found this thread yesterday, but it seems really broken, at least I can't get it to return the same results.

https://vborg.vbsupport.ru/showthread.php?t=138668

[eoc_Jason]

IIRC, all posts by user should use userid / threadid / postid and those should be indexed? Or do you mean searching for a phrase by a particular user? If you elaborate I can look into it more. I need to do some tweaking on my sphinx, definitly when I do my vB upgrade and I want to make it more transparent (or even better) than the default vB search.

[mute]

I mean tossing the searches done via the advanced search page "Find all posts by user" or "Find all threads started by user" to Sphinx. Under the current incarnation those still hit MySQL.

[weeno]

Thanks for everyone involved. I appreciate the info. Especially, eoc_Jason. Those scripts saved me a lot of time.

I had to recreate much of the final sphinx.php file from the original file and the followup posts. So I thought I'd post my final edit so people can build on it.

I took the sphinx.php file from orban
https://vborg.vbsupport.ru/showpost....&postcount=387

Applied these changes:

sort_search_items changes from the bottom of the post by eoc_Jason

Fixed a Problem with asserts in sphinxapi.php

Added only the 64-bit Unpack fix detailed here. If you aren't on the 64-bit system, you prob can remove this function. I didn't add/change the rest of ALanJay's changes as I wasn't sure what they were for.

One problem for was the Coventry variable that seems to be causing causing errors:

Warning: in_array() [function.in-array]: Wrong datatype for second argument in /includes/sphinx.php on line 125

that didn't seem to affect the search results. NOTE: I added error_reporting(0) as did mute at the beginning to simply surpress these errors as I didn't find another solution. If anyone has a solution for this, let me know. If you are testing this script out, you should remove that line to make sure it works before you surpress errors.

I didn't use

this code by mlx because I wasn't sure exactly what was added.

sphinxapi.php ignoring max matches limit set in sphinx.conf fix - again, wasn't sure if I needed to use it at the time.

config

my config is PHP 5.2.4 for php servers. Centos 5 64-bit for mysql. vbulletin 3.6.7.

arn

[Jon]

Originally Posted by weeno

Thanks for everyone involved. I appreciate the info. Especially, eoc_Jason. Those scripts saved me a lot of time.

I had to recreate much of the final sphinx.php file from the original file and the followup posts. So I thought I'd post my final edit so people can build on it.
[...]

Thanks! This helped us get rid of our problems with missing posts.

[Spinball]

I am in the UK and I need to get Sphinx running ASAP.
I've had a read of this thread but I'm finding it pretty baffling. I have reasonable MySQL and PHP skills but leave the server and PHP/MySQL setup well alone.
it's 14:10 here right now and my host will be around later to help with the install.
There's $100 / ?50 in it for someone who can hand-hold me through the installation today onto www.avforums.com.
Any takers?

[eoc_Jason]

Is there any details on the unpack function? I looked on several pages but I can't find it. I've got a site running spinx that is 64bit, but IIRC they aren't using the unpack and aren't running into issues. What problems were people having?

Oh, about the other post on searching by user... As long as there isn't any search words (just a username) it should use the numeric indexes. It's been a while since I've peeled through the search code though, I'll try to look over it one of these days and see what can be done. I'm not sure if the code works if you put in a search term AND username.

[mute]

Originally Posted by eoc_Jason

Is there any details on the unpack function? I looked on several pages but I can't find it. I've got a site running spinx that is 64bit, but IIRC they aren't using the unpack and aren't running into issues. What problems were people having?

Oh, about the other post on searching by user... As long as there isn't any search words (just a username) it should use the numeric indexes. It's been a while since I've peeled through the search code though, I'll try to look over it one of these days and see what can be done. I'm not sure if the code works if you put in a search term AND username.

If you check out the link I pasted someone attempted to get this working. Granted I am running 3.6.2 with a 3.6.8 search.php+/includes/functions_search.php, but I believe something weird is going on with it, but I can't figure out exactly what is going on.

There's a definite bug with usernames with a "=" in them regardless of if I'm broken for other reasons

[BrandiDup]

Does anyone have a forum where I can see this type of search in action? I have tried reading through this thread and on the sphinx site but can't seem to grasp how exactly it's different than vbulletin search, aside from it being a better solution for big boards. We have 1.5 mil posts on our site and search doesn't seem to lag too much right now, but this may be something we should look into soon before any problems arise. How is the interface of the search different? Does it look similar to google's search?

[weeno]

Originally Posted by BrandiDup

Does anyone have a forum where I can see this type of search in action? I have tried reading through this thread and on the sphinx site but can't seem to grasp how exactly it's different than vbulletin search, aside from it being a better solution for big boards. We have 1.5 mil posts on our site and search doesn't seem to lag too much right now, but this may be something we should look into soon before any problems arise. How is the interface of the search different? Does it look similar to google's search?

http://forums.macrumors.com/search.php

Sphinx search with two different search options (match documentation)

Normal = Match All (SPH_MATCH_ALL mode)
Extended = Extended (SPH_MATCH_EXTENDED mode - not all options work)

both use sphinx.

arn