Sphinx Search

[NickCat]

Thanks for the great work orban to keep this going!!!

I just installed .1 and everything seems to be working great.

I am getting an error on the redirect page before the results pop though, nothing bad, just informational.

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

I am running vb 368p2.

I was trying to hold out upgrading to 3.6.10 until I'm sure they aren't going to .11 in a week! I'm had vb long enough to know better!

--------------- Added 06 May 2008 at 01:48 ---------------

I guess I spoke too soon.

I upgraded to 3.6.10, to try to alleviate any other issues.

Having a few other problems... and I'm not sure what's going on.

1) For some reason my updates on the deltas aren't working. It runs, but never finds anything to index. And there are definitly new posts and threads to index.

The result looks like this:

Sphinx 0.9.8-rc2 (r1234)
Copyright (c) 2001-2008, Andrew Aksyonoff

using config file '/etc/sphinx.conf'...
indexing index 'postdelta'...
collected 0 docs, 0.0 MB
total 0 docs, 0 bytes
total 0.011 sec, 0.00 bytes/sec, 0.00 docs/sec
indexing index 'threaddelta'...
collected 0 docs, 0.0 MB
total 0 docs, 0 bytes
total 0.010 sec, 0.00 bytes/sec, 0.00 docs/sec
rotating indices: succesfully sent SIGHUP to searchd (pid=22708).

The command I'm running is:

indexer --config /etc/sphinx.conf --rotate postdelta threaddelta

Am I wrong in thinking the deltas are still called postdelta and threaddelta?

2) I'm getting an occasional error when people are searching:

Database error in vBulletin 3.6.10:

Invalid SQL:

                INSERT INTO search
                    (userid, titleonly, ipaddress, personal, query, searchuser, forumchoice, /*prefixchoice,*/ sortby, sortorder, searchtime, showposts, orderedids, dateline, searchterms, displayterms, searchhash, completed)
                VALUES
                    (78408,
                    1,
                    '71.119.247.53',
                    1,
                    'events',
                    '',
                    '20,102,133',
                    'lastpost',
                    'DESC',
                    0.01146, 0,
                    '1507990,1202618,1497231,1424353,1425729,1370173,1327330,1327625,1275317,1280585,1053389,1247121,1220128,1173630,1187708,1191528,1161131,1114547,1078119,1024452,947834,887728,855358,853807,816227,783190,718582,649979,649714,644579,593661,565031,556141,539177,532216,501639,476210,459248,426142,424279,369567,339477,300242,269273,252339,204641,179446,128824,109786,19493,19998',
                    1210052178,
                    'a:24:{s:5:\"query\";s:6:\"events\";s:10:\"searchuser\";s:0:\"\";s:9:\"exactname\";i:1;s:11:\"starteronly\";i:0;s:11:\"forumchoice\";a:1:{i:0;s:2:\"20\";}s:11:\"childforums\";i:1;s:9:\"titleonly\";i:1;s:9:\"showposts\";i:0;s:10:\"searchdate\";s:1:\"0\";s:11:\"beforeafter\";s:5:\"after\";s:6:\"sortby\";s:8:\"lastpost\";s:9:\"sortorder\";s:10:\"descending\";s:9:\"replyless\";i:0;s:10:\"replylimit\";i:0;s:14:\"searchthreadid\";i:0;s:9:\"saveprefs\";i:1;s:11:\"quicksearch\";i:0;s:10:\"searchtype\";i:0;s:7:\"exclude\";s:0:\"\";s:7:\"nocache\";i:0;s:4:\"ajax\";i:0;s:9:\"imagehash\";s:0:\"\";s:10:\"imagestamp\";s:0:\"\";s:6:\"userid\";i:0;}',
                    'a:8:{s:5:\"words\";a:1:{i:0;s:6:\"events\";}s:9:\"highlight\";a:1:{i:0;s:6:\"events\";}s:6:\"common\";a:0:{}s:5:\"users\";a:0:{}s:6:\"forums\";a:1:{i:20;i:20;}s:8:\"prefixes\";a:0:{}s:3:\"tag\";s:0:\"\";s:7:\"options\";a:3:{s:11:\"starteronly\";i:0;s:11:\"childforums\";i:1;s:6:\"action\";s:7:\"process\";}}',
                    '0b537c34de784ac889ce7bca2e26adeb',
                    1)
                ### SAVE ORDERED IDS TO SEARCH CACHE ###;

MySQL Error  : Duplicate entry '0b537c34de784ac889ce7bca2e26adeb-lastpost-DESC' for key 2 Error Number : 1062
Date         : Tuesday, May 6th 2008 @ 01:36:18 AM
Script       : http://forums.nasioc.com/forums/search.php?do=process
Referrer     : http://forums.nasioc.com/forums/search.php?do=process
IP Address   : 71.119.247.53
Username     : psychoskip
Classname    : vB_Database

Any ideas... cause I'm lost here...

The database error was happening on both 3.6.8 and 3.6.10. The search is still working most of the time, but this seems to be having an issue thinking it's inserting a duplicate key into the table.

UPDATE: I reverted back to the original sphinx setup I was using for now. A couple of things I will have to say I noticed immediatly between the two version. The older version took significantly longer to index and took up more drive space, but the results seem to return much faster.