Sphinx Search

[orban]

Are you guys using vB 3.6?

[DaiTengu]

Originally Posted by orban

Are you guys using vB 3.6?

It's a very clean 3.6.1 install on a very busy forum. There's no hacks or anything else installed.

[amcd]

i dropped 3 fulltext indexes

title and title_2 on post
title on thread

hope i did the correct thing

what are the postindex and posthash tables for? i also have 3 tables called postindex_temp31480 and similar. what are those?

[Neil Lock]

Would love a little bit of help, if available?

I have tried getting this to work on one of our test forums which currently has about 1.5mil posts and is running vbul 3.5.4 first of all im not sure whether my conf is correct when i run the indexer is it supposed to say

skipping index 'vbfulltext' (distributed indexes can not be directly indexed)...
skipping index 'vbfulltextthread' (distributed indexes can not be directly indexed)...
those are the last 2 results - the dirstributed indexes is that error suppose to be there?

secondly when i run a search --config path qry it appears to work and give back results however upon turning on the searchd i dont seem to get any results the echos on my search.php
Query '' retrieved 0 of 0 matches in 0.000 sec.
Query stats:
'test' found 0 times in 0 documents

and there are no queries on my searchd.log

any starting point suggestions- i guess the searchd isnt being queried however when i switch it off the echo alerts me that searchd is not running? is one of the issues that im using 3.5?

Thanks
Nelly

[orban]

Originally Posted by Neil Lock

skipping index 'vbfulltext' (distributed indexes can not be directly indexed)...
skipping index 'vbfulltextthread' (distributed indexes can not be directly indexed)...
those are the last 2 results - the dirstributed indexes is that error suppose to be there?

Yes

Originally Posted by Neil Lock

secondly when i run a search --config path qry it appears to work and give back results however upon turning on the searchd i dont seem to get any results the echos on my search.php
Query '' retrieved 0 of 0 matches in 0.000 sec.
Query stats:
'test' found 0 times in 0 documents

and there are no queries on my searchd.log

any starting point suggestions- i guess the searchd isnt being queried however when i switch it off the echo alerts me that searchd is not running? is one of the issues that im using 3.5?

Are you starting the searchd with --config path too?

[Neil Lock]

Wow, thanks for the really quick reply, yup am starting with the conf file

and the only lines in the log read:
[Sun Nov 12 14:29:38 2006] [24295] creating server socket on 0.0.0.0:3312
[Sun Nov 12 14:29:38 2006] [24295] accepting connections

Nelly

[orban]

There's two log files.

searchd.log and query.log

What does query.log say?

[Neil Lock]

ahh didnt notice that there was a query log

ok so it must be hitting it
[Sun Nov 12 14:34:13 2006] 0.009 sec [all/1/attr- 0 (0,500)] [vbpostindex] test qry

hmmmm will go back to the search.php - is it likely to be something to do with using 3.5.4 and not 3.6?

Nelly

[orban]

I don't really know...

you can try to work with the files in the /api/ folder of the archive you downloaded, and try to get that one work.

mute: !!

[mute]

Originally Posted by Neil Lock

Would love a little bit of help, if available?

skipping index 'vbfulltext' (distributed indexes can not be directly indexed)...
skipping index 'vbfulltextthread' (distributed indexes can not be directly indexed)...
those are the last 2 results - the dirstributed indexes is that error suppose to be there?

This is the correct behavior.

Originally Posted by Neil Lock

secondly when i run a search --config path qry it appears to work and give back results however upon turning on the searchd i dont seem to get any results the echos on my search.php
Query '' retrieved 0 of 0 matches in 0.000 sec.
Query stats:
'test' found 0 times in 0 documents

Check your settings in sphinx.php, make sure your searchd command line has the proper --config, and.. upgrade to 3.6, as I don't believe you'll have much luck with Orbans search files w/ 3.5, as they were designed for 3.6.

Jeez, there were like 4 replies while I was replying