sphinx

Thinking Sphinx not indexing newly added records

I am using sphinx to search on 2 models along with their associations. I am using delta indexing. Things work fine on my dev box in dev mode (Ubuntu). However, on staging box production env, when I create new records, I need to build the index again in order to make the newly created records searchable. Even weird is that when I create r...

Problem to run Sphinx on Ruby on Rails 2.3.2

Hi, Yesterday I was trying to install Sphinx for full-text search on Windows 7. So, I followed their website's installation steps. Once I installed its windows service, I ran the indexer and then the test search against my app database and it worked great. Then, I wanted to make it work on Ruby on Rails 2.3.2, so I downloaded and insta...

Spanish accents in Sphinx searches

Hi, I've just included thinking-sphinx on Ruby-on-rails and I wanted to know how and where I must config the chartset_table so if I search some word with an accent, it returns results as if the word didn't have the accent. EDIT: This is my Sphinx.yml config file. Please let me know if there's something wrong with it: development: ...

How to add conditions to thinking-sphinx search?

Hi, I've recently installed thinking-sphinx on my ruby on rails app. As first sight, everything works great, I can search words and it will find them. Now, when I try to add some filters(such as, for example, provinces, categories, etc) using: MyModel.search 'hello' :conditions => 'category_id=1' for example, it will throw me the foll...

Sphinx: some good customization examples?

I've created a Sphinx document using sphinx-quickstart. Are there any good examples/tutorials about customizing the look? Specifically to modify the header and add a logo. Are there some projects with downloadable Sphinx docs? I would like to see how they've customized their look. update: Adding a logo is supported in the default s...

Sphinx - When to use 'has' and 'indexes' for fields

Hi, I installed Sphinx and Thinking-Sphinx some days ago on my ruby on rails 2.3.2, and basic searching works great. This means, without any conditions. Now, I want to filter the search with some conditions. I have the Announcement model, and the index looks as follows: define_index do indexes title, :as => :title, :sortable => ...

Sphinx on Webfaction for Rails

I'm looking to install Sphinx and thinking_sphinx on my basic shared hosting plan at webfaction so I can properly deploy my rails app. I'm positive webfaction supports this under my plan. I'm not anything near a linux guru in terms of skill level, but I know the basics. How can I install Sphinx on my shared host without having sudo priv...

Thinking Sphinx and acts_as_taggable_on plugin

Hi, I installed Sphinx and Thinking Sphinx for ruby on rails 2.3.2. When I search without conditions search works ok. Now, what I'd like to do is filter by tags, so, as I'm using the acts_as_taggable_on plugin, my Announcement model looks like this: class Announcement < ActiveRecord::Base acts_as_taggable_on :tags,:category defi...

Thinking Sphinx - Search filter not working

Hi, I installed Sphinx and Thinking Sphinx on ruby-on-rails 2.3.2 and on Windows 7 pc. First of all, if I run rake ts:start, it won't start at all. It keep saying "Starting..." and it never starts. Even though, the simple search(with no filtering nor conditions) works fine. When I try to add a filter, it won't return any record. My mo...

Sphinx - generate automatic references to Trac tickets and changesets

Is Sphinx, is there way to automatically link text like #112 or r1023 to the corresponding tickets/changesets in Trac? For eg: #112 -> http://mytracsite/tickets/112 r1023 -> http://mytracsite/changeset/1023 See TracLinks for more examples. ...

Sphinx: Filtering MVA on multiple fields

I would like to be able to filter my orders on an amount range AND a specific user_id The expected result would be to get only the orders where the specified user did a bid on in a certain amount range. For example there is an order with id 1. User 5 bid on it for an amount of 200. Now if I want to filter I set the user_id filter to 5 ...

Ignoring apostrophes in sphinx indexes

In my sphinx config file, I have the following: ignore_chars: "U+0027" charset_table: "0..9, a..z, _, A..Z->a..z, U+00C0->a, U+00C1->a, U+00C2->a, U+00C3->a, U+00C4->a, U+00C5->a, U+00C7->c, U+00C8->e, U+00C9->e, U+00CA->e, U+00CB->e, U+00CC->i, U+00CD->i, U+00CE->i [SNIP]" (The charset_table entry is from here: http://speeple.com...

How can I make Sphinx's inheritance_diagram readable?

Similar to this chap's post, I'm seeing Sphinx generate unreadable graphviz output: How can I generate readable output? Nothing happens if I add -Gfontsize=140 If I tell it to use neato instead of dot it produces readable output, but the graphs aren't tree-like. ...

fsockopen issue when opening port to sphinx only in php

I have an issue when connecting php and only php to the sphinx daemon. I have tested the sample sphinx php example test.php and narrowed it down to being a connection problem. I have the follow piece of code which shows the problem, <?php $fp = @fsockopen ( '127.0.0.1', '9312', $errno, $errstr,300 ); if(!$fp) { echo "$errstr ($errno)...

Hosted full text search solutions?

Does anyone know of companies offering SaaS full text search? I'm looking for something that uses Lucene, solr, or sphinx on the backend, and provides a REST API for submitting documents to index, and running searches. I could build my own EC2 AMI, but I'd have to configure EBS and other stuff, monitor it, etc. Curious if someone has ...

sphinxsearch returns "failed to send client protocol version"

On some of my servers, doing a sphinx php query returns that error. Searching google I can't find anything except this is part of why the error came out: // send my version // this is a subtle part. we must do it before (!) reading back from searchd. // because otherwise under some conditions (reported on FreeBSD for instance) ...

Migrating from Javadoc to Python Documentation

So I've gotten somewhat used to Javadoc style documentation. Looking through various examples of Python code, I'm finding that, at first blush, the documentation seems to be missing a lot of information. The good: vary rarely do you see self-evident bits of documentation. Docstrings are usually a paragraph or less of English markup that...

How to implement mysql compress() function in php

I want to compress TEXT for storing in MySQL. So I would just do gzcompress() in php and then send to mysql, but I am also setting up Sphinx full text search, and it would be nice if it can populate its index with a simple query i.e. select uncompress(thing) from table However I would still like to do compression and decompression for...

sphinx GROUP BY

Going to illustrate this so please bear with me. This is my MYSQL Table structure indexed by sphinx ------- ------- -------------- tag_id | tag | foreign_id | ------- ------- -------------- 1 love 111 2 blue 222 3 lover 333 4 yellow 444 5 love 555 6 lov 666 What I'm trying ...

In Sphinx, is there a way to document parameters along with declaring them?

I prefer to document each parameter (as needed) on the same line where I declare the parameter in order to apply D.R.Y. If I have code like this: def foo( flab_nickers, # a series of under garments to process has_polka_dots=False, needs_pressing=False # Whether the list of garments should all be pressed ): ...