sphinx field block operator error

Question

I am creating a very complex Sphinx .cnf file on a very large MySql Table and in order to efficiently test it I have a test config I use on a smaller table. Once I get the behavior I expect/want I copy the new config content over to the working config. However the last time I did this and rotated the on site query gave me query: “query error: invalid character '|' in field block operator” even though the rotation was successful. I get this is somewhat of a vague question but are there any suggestions as to what to look for? My config is very large and complex and a line by line isn't practical. All I know is that:

• When I revert back to the older working config the site query works
• When I run the query on the test site with the test sphinx config it works
• When I replace the working config with the working test config I (all of a sudden) get that error.

Answer 1

You query may like this:

@(column1|column2|column3) some search keyword

Just replace | to ,:

@(column1,column2,column3) some search keyword

And equivalent to:

@(column1,column2,column3) some | search | keyword