Sphinx Search

[orban]

You realize that there is a difference between sorting in 0.9.6 and 0.9.7-RC1? They are NOT compatible.

[mute]

Originally Posted by DaiTengu

Yeah, they're supposed to be sorted by date. Apparently I'm not the only person having the problem.

You aren't alone. We too seem to get out of order results when searching, and not sorting by relevance.

[mute]

Is there any hope of Sphinx handling "Find all posts by user" searches?

[adalren]

I found a bug. When searching in title only, it doesn't honor datecut.

To fix, change:

PHP Code:

                // get posts from before $datecut
                case 'before':
                        $cl->SetFilterRange('dateline', 0, $datecut);
                        break;

                // get posts from after $datecut
                default:
                        $cl->SetFilterRange('dateline', $datecut, 0xFFFFFFFF); 


to:

PHP Code:

                // get posts from before $datecut
                case 'before':
                        $cl->SetFilterRange($sphinx_sort_by_date, 0, $datecut);
                        break;

                // get posts from after $datecut
                default:
                        $cl->SetFilterRange($sphinx_sort_by_date, $datecut, 0xFFFFFFFF); 


Another thing I found is that vb caches the search results and it tries to find the closest or exact match. There's no problem with exact matches, but when it saves the results sorted in ascending date order the subsequent searches in reverse order shows only old threads. To fix this, just comment out the $highScore = 1 & highScore = 2 lines in search.php. This disables using the stale cache for non-exact matches.

Thanks for the great hack orban!

[orban]

<a href="http://www.sphinxsearch.com/index.html" target="_blank">http://www.sphinxsearch.com/index.html</a>

RC2 released, I'll upgrade tomorrow and see if there are any changes for us.

-----------

Recreated index, copied over new sphinxapi.php seems to work okay. There's a new "extended" search mode but don't think I'll use that (too complicated for users anyway).

[mute]

Hm. So all was going well, but out of the blue our subforum searches stopped working. If i don't specify a subforum, the searches work. If I do, I get an assertion failure in sphinxapi.php @ line 290 (with 0.9.7-rc2).

I ran into the problem on -rc1, and decided to upgrade to see if it had been fixed, but it has not. I'm a tad stumped.

Edit: I seem to have fixed it by adding a "$value = intval($value);" before the assert() in sphinxapi.php. Guess this is related to the assertion failures earlier, so much for not having to cast variables

[orban]

Tried to do an intval() on the forumid?

[amcd]

@mute, good that you solved the problem, but i would not edit sphinxapi.php

since more people are facing the same problem, let me post an easy to follow solution. this is what i did to solve the problem on my forums, after reading the conversation between alanjay and orban

in includes/sphinx.php, around line 44, change

from:

	if ( count ( $sphinx_forumids ) > 0 ) $cl->SetFilter ( 'forumid', $sphinx_forumids );
	if ( count ( $sphinx_userids ) > 0 )  $cl->SetFilter ( 'postuserid', $sphinx_userids );

to

	if ( count ( $sphinx_forumids ) > 0 ) $cl->SetFilter ( 'forumid', intvalarray($sphinx_forumids) );
	if ( count ( $sphinx_userids ) > 0 )  $cl->SetFilter ( 'postuserid', intvalarray($sphinx_userids) );

around line 69, change

from

	if ( count ( $sphinx_forumids ) > 0 )    $cl->SetFilter ( 'forumid', $sphinx_forumids );
	if ( count ( $sphinx_threadids ) > 0 )   $cl->SetFilter ( 'threadid', $sphinx_threadids );
	if ( count ( $sphinx_userids ) > 0 )     $cl->SetFilter ( 'userid', $sphinx_userids );
	if ( count ( $sphinx_postuserids ) > 0 ) $cl->SetFilter ( 'postuserid', $sphinx_postuserids );

to

	if ( count ( $sphinx_forumids ) > 0 )    $cl->SetFilter ( 'forumid', intvalarray($sphinx_forumids) );
	if ( count ( $sphinx_threadids ) > 0 )   $cl->SetFilter ( 'threadid', intvalarray($sphinx_threadids) );
	if ( count ( $sphinx_userids ) > 0 )     $cl->SetFilter ( 'userid', intvalarray($sphinx_userids) );
	if ( count ( $sphinx_postuserids ) > 0 ) $cl->SetFilter ( 'postuserid', intvalarray($sphinx_postuserids) );

and lastly, around line 157, right at the end of the file, change

from

unset($cl, $res, $doc, $docinfo);
?>

to

unset($cl, $res, $doc, $docinfo);

// these functions added by me on 16 nov 06 to avoid assert failed errors from sphinxapi.php
function intvalarray($thearray)
{
	array_walk($thearray, "intvalitem");
	return $thearray;
}

function intvalitem(&$item, $key)
{
	$item = intval($item);
}

?>

[mute]

Thanks amcd, that is indeed a better solution. I've made the changes and all appears to be working well

[ubuntu-geek]

Just out of curiosity.. Are people using the standard vb search or full text in conjunction with their sphinx implementations?