#85: Colons and special characters in Ultrasphinx queries

Solved!
When I use UltraSphinx, the Ruby API to the Sphinx full-text search engine, queries with certain special characters such as colons (:), at signs (@), and other reserved characters throw an Ultrasphinx::UsageError exception in my query interface. For example...

#34: Indexing the results of an nested set ancestry query

I would like to use Sphinx and ThinkingSphinx to index the results of a nested set ancestry query, but I'm not entire sure how. The kind of query I need to do would be something like SELECT id FROM taxa WHERE taxa.lft <= $target_taxon_lft AND taxa.rgt...

#28: crontab settings for deploying Ultrasphinx

Solved!
the SelfSolved instance deployed uses Ultrasphinx for its full-text indexer and search provider. The sphinx indexer needs to be run regularly to index new text that appears on the site. I need crontab incantations to set the indexer to create delta indexes...