#85: Colons and special characters in Ultrasphinx queries

Solved!
on February 19, 2010, 09:59 PM UTC   —   from   92049143cabb7ba896d7c06e19906303_small yliu    ( 2,372 views )
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...
Tags: full-text search, programming, ruby, ultrasphinx, sphinx
1 solution | 2 references     Add Solution | Add Reference    

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

on April 15, 2009, 08:59 PM UTC   —   from   148c663fd665c53518538e093ce3c2ab_small kueda    ( 602 views )
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...
Tags: sphinx, indexes, search, ThinkingSphinx, SQL, Rails
0 solutions | 0 references     Add Solution | Add Reference    

#28: crontab settings for deploying Ultrasphinx

Solved!
on March 28, 2009, 07:36 AM UTC   —   from   92049143cabb7ba896d7c06e19906303_small yliu    ( 1,062 views )
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...
Tags: Ruby on Rails, Rails, ultrasphinx, sphinx, full-text search, cron, crontab
1 solution | 1 reference     Add Solution | Add Reference