sphinx

How to remove deleted entries from the main sphinx index?

I have a site that utilizes the main/delta indexing scheme for sphinx. main gets rebuilt daily, delta is rebuilt every 5 minutes. This works well for indexing newly submitted items. The problem is, items needed to be dropped from the index just as frequently as they are added, and typically the dropped items are older, so they already ...

How to get the search words location from Sphinx search engine?

I use Sphinx to index HTML pages, giving different weights to title, description, etc. I'm looking for a way to get the search words location in the page from the results that I get from Sphinx. Meaning, if the wordset is "stack overflow program" and I have 5 documents that match, each of them was a match because it contained at l...

Rake db:seed - can I index Sphinx from there?

Is it a good idea to run rake thinking_sphinx:index from db/seeds.rb file? So that it will look like: #create some items #run rake thinking_sphinx:index Main intention behind that is to get fully functional environment after populating it with seed data. It is applied only to development env. ...

Thinking Sphinx not indexing associated data to model searched by.

In my Product.rb define_index do indexes :name, :sortable => true indexes brand has :id, kosher_id, gluten_free_id, lactose_free_id has stores(:id), :as => 'store_ids' has locations(:id), :as => 'location_ids' has categories(:id), :as => 'category_ids' has kosher(:passover), :as => 'kosher_passover' end ...

Sphinx Mysql query problem

Hello. My sphinx config: source logs { type = mysql sql_host = localhost sql_user = root sql_pass = sql_db = bot sql_port = 3306 sql_query_pre = SET NAMES utf8 sql_query = SELECT * FROM logs sql_attr_uint = host sql_query_info = SE...

sphinx.ext.pngmath raise an error when I try a simple expression

I'm using Sphinx to create the documentation of my project. I want to use the extension sphinx.ext.pngmath and with this little test: Returns the indefinite integral of the polynomial *poly*: .. math:: \int p(x)dx I got the error: WARNING: inline latex u'\\int p(x)dx\n\n': latex exited with error: [stderr...

How can I make Python/Sphinx document object attributes only declared in __init__?

I have Python classes with object attributes which are only declared as part of running the constructor, like so: class Foo(object): def __init__(self, base): self.basepath = base temp = [] for run in os.listdir(self.basepath): if self.foo(run): temp.append(run) self.avail...

Sphinx. Set of queries. PHP API

Hello. With little sign of the Sphinx. I have 5 pages. At one should look at the entire base. This is done next. config: source logs { type = mysql sql_host = localhost sql_user = root sql_pass = sql_db = bot sql_port = 3306 sql_query_pre = SET NAMES utf8 sql_query = SELECT * FROM logs sql_attr_uint = host s...

Handling dates prior to 1970 in a repeatable way in MySQL and Python

In my MySQL database I have dates going back to the mid 1700s which I need to convert somehow to ints in a format similar to Unix time. The value of the int isn't important, so long as I can take a date from either my database or from user input and generate the same int. I need to use MySQL to generate the int on the database side, and ...

Best way to connect node.js and sphinx

I'm trying to search in sphinx from node.js code. The only way to do it I know is to connect to searchd as to mysqld server. I'd absolutely all known mysql libraries, but no of them even connected to sphinx. ...

could some plz tel me tip's to understand sphinx from scratch

I need to understand sphinx from scratch. m new to using sphinx and I work on asp.net. If any of u have any document's or ebook's about sphinx plz mail me at ...

Search app in Django

I am building search app using django & sphinx. I got the setup working but when I search I get irrelevant results. Here is what I do - # this is in my trial_data Model search = SphinxSearch( index = 'trial_data trial_datastemmed', weights = {'name': 100,}, mode = 'SPH_MATCH_A...

Thinking Sphinx Rake aborted, searchd is running whilr rebuilding or start/stop ts. Index works fine.

When I invoke rake ts:rebuild RAILS_ENV=production, I get the following: (in /var/www/abc.com/public/abc/releases/20101008073517) ** Erubis 2.6.6 Stopped search daemon (pid 22531). Generating Configuration to /var/www/abc.com/public/abc/releases/20101008073517/config/production.sphinx.conf Sphinx 1.10-beta (r2420) Copyright (c) 2001-20...

Is this a better way to index with Thinking Sphinx?

There has been a post about setting cron job to index: Use a Cron Job to Automate Sphinx Index Refresh from Rails Rake Task The author shares the same technique to invoke the indexer through Thinking Sphinx. But in the comment, there is a second method shared, which claimed to be better in easing the server load by calling the indexer d...

How do I install Sphinx on a CentOs 5.5?

Newbie here.. Hello there I want to install sphinx search to my CentOS 5.5. I just need to know the commands, for the full installation. If you could write a simple numbered manual that would be appreciated. ...

Is it possible to install Sphinx after php, mysql etc.. have already been installed?

I'm confused Does order matter when installing Sphinx Search. If mysql was already installed on my server, can I still install sphinx after or do I have to do them together or Sphinx before? ...

Searching Techniques Recommendations

Hi everyone. This is more of a theory question rather than practice. I'm working on a project which is quite a simple catalog of links. The whole model is similar to the Dmoz or Yahoo catalog, except that each entry has certain additional attributes. I have hierarchical taxonomy working on all entries with many-to-many relationship, all...

Control panel for Sphinx?

n00b here Is there some kind of control panel for Sphinx (to make things easier)? Or is there a way I can use Plesk to handle it? I already installed (sphinx-0.9.9) on my CentOS, I just don't know what to do next to index and search on MySql (with php) Also, can someone explain about using the daemon, api, etc... ...