Thread:Extension talk:SphinxSearch/Unknown field error in indexer

Background: I have Sphinx completely setup and working. In the process of using Sphinx I realize I have a column holding text that I would like to filter against. Potential text values in this field are stored in a second table called counties. The counties table does not have a int ID column, so I added it and set it as the primary key. Using a left join I attached it to the primary table and added the field to the field list using 'as CountyID' statement. To verify the syntax, I ran the query in MYSQL workbench,everything worked.

Problem: I moved the query over to Sphinx Config file and the indexer will not recognize the new column. If I replace that field with any other field in the counties table I do not receive an error. It is specific to the added column. I even went so far as renaming the column. That did not work.

Any suggestions?