Sphinx Search

[snakes1100]

Confirmed as working on vBulletin 3.7.2 Patch Level 1

cron:
postdelta - 5min
threaddelta - 5min
reindexed nightly

Seem to ran into one issue tho of only returning 500 results when searching for posts by a user with 15k, found a hard limit set to 500 in sphinx_search, raised that limit to 20000 to match everything else.

Odd enough it now returned only 1000 results, which still isn't right, as there is no other limit set to 1000, will have to chk it out some more.

Full index & restart didn't help.

Note, found the 1000 hard limit set in sphinxapi.php

New search now returned 7100 posts by that user, missing about 8k in posts, back to the drawing board.

Showing results 1 to 25 of 7074
Search took 0.52 seconds.

6 million post board w/about 2500 online.

Add-on:
Seems i may have found a bug someplace, ill post part of the error, if orban or anyone wants the full error msg i have it saved, but doing a search for a keyword that has only about 3500 results produced a duplicate key entry and a db error page, after, the browser reported a script still running error and wouldnt let me refresh the page, FF stopped the script and then a refresh cured the db error page, doing the search again for the same keyword resulted in a good search & no error.

Invalid SQL:

				INSERT INTO search
					(userid, titleonly, ipaddress, personal, query, searchuser, forumchoice, 

/*prefixchoice,*/ sortby, sortorder, searchtime, showposts, orderedids, dateline, searchterms, displayterms, searchhash, 

completed)
				VALUES
					(641509,
					0,
					'',
					1,
					'bollywood',
					'',
					'',
					'lastpost',
					'DESC',
					0.10879, 0,

### SAVE ORDERED IDS TO SEARCH CACHE ###;

MySQL Error   : Duplicate entry '0089875ee33efd9d611cfff6ca28d9e4-lastpost-DESC' for key 2
Error Number  : 1062