is it possible with sphinx to sort a result like this mysql query? order by lang='2' desc , time_popular desc so get the latest documents with lang=2 in fist position. I really need your help :) ...
hi i want to know how to use sphinx in ubuntu... i installed sphinx in ubuntu... then what will i do for use sphinx.... i dont know the next step... thanks and advance ...
I am using InnoDB for a MySQL table, and obviously queries using LIKE and RLIKE/REGEXP can take a lot of time. I've tried Spinx, and it works great, except I have to re-index context at intervals. I can re-index every minute, but I am wondering if there is either 1) a setting in Sphinx to keep records always indexed or 2) other software...
hi i want to know how to get all column value from table using sphinx search... i have configuration file, that file can get only one field from table. but i need all field value. where will i modify for getting all field from table. thanks and advance... ...
hi i want to know how to delete all data from sphinx table. because i would like to store new data to the table. thanks and advance. ...
Hi, I start to using cassandra and I want to index my db with sphinx. I wrote ruby script which is used as xmlpipe, and I configure sphinx to use it. source xmlsrc { type = xmlpipe2 xmlpipe_command = /usr/local/bin/ruby /home/httpd/html/app/script/sphinxpipe.rb } When ...
Error i m getting is:- mohit@mohit-laptop ~/Desktop/code $ rake thinking_sphinx:index (in /home/mohit/Desktop/code) Generating Configuration to /home/mohit/Desktop/code/config/development.sphinx.conf Sphinx 0.9.9-release (r2117) Copyright (c) 2001-2009, Andrew Aksyonoff using config file '/home/mohit/Desktop/code/config/development.sph...
Hi, I have updated my searching fields records with thinking_sphinx gem and I have configured it. It is working fine but the problem, It is only displaying 20 records which is default. How to change those thing to make more records visible on view.. ...
ok I downloaded sphinx-0.9.9.tar.gz to my desktop I extracted to a folder called sphinx on my desktop. I run: cd ~/Desktop/sphinx ./configure --prefix=/usr/local/sphinx --with-mysql alot of stuff happens. Then I run this line make I get this error: make: * No targets specified and no makefile found. Stop. I...
I'm part of a development team working on a job board, and we're considering both Lucene and Sphinx for out search base. Does anyone have experience working with either of these open-source tools for location based search? ...
When running sphinx-build . html/ in my doc/ directory, I get the following output: $ sphinx-build . html/ Running Sphinx v0.6.4 No builder selected, using default: html loading pickled environment... done building [html]: targets for 0 source files that are out of date updating environment: 0 added, 1 changed, 0 removed reading sour...
Hello.. below are tables I need to index in Sphinx News has many projects linked to it via the news_projects table... My question is it advisable to have all the project names in one text field so that it can be searched on? This is my query : //query to get the project names and make all project names appear in one field separated ...
Is it possible to perform document similarity search efficiently using sphinx search? My index consists of 500k documents, each which is tagged by 5-30 different short, all lowercase stemmed words which is the data to search through. For simplicity, all tags in the database has equal weights and I'm not using phrase searching. My first a...
Hello, One would normally have this query in their sphinx.conf file : sql_query = SELECT id,text_field1,text_field2,text_field3 FROM table_name Would there be much difference if I combine all fields into one searchable text field like so? sql_query = SELECT id, CONCAT(text_field1,text_field2,text_field3) as searchable_text FROM tabl...
I've written a script to pull data from MongoDB and output seemingly valid XML for sphinx, modeled on the example files in the sphinx distribution. The issue I'm having is that none of the fields are actually being indexed, despite everything appearing as though they should. This is my config: pastebin.com/p5vMXMZw This is my (truncated...
Hey, I'm developing a job service that has features like radial search, full-text search, the ability to do full-text search + disable certain job listings (such as un-checking a textbox and no longer returning full-time jobs). The developer who is working on Sphinx wants the database information to all be stored as intergers with a ke...
I am using the thinking-sphinx plugin for a ruby on rails app. In testing and development, I have reindexed many, many times, sometimes against different databases, with the result that now all of my searches return an empty array. I don't believe this is related to the codebase, because other developers using the same code can get valid...
I'm in the process of setting up a new WordPress 3.0 multisite instance and would like to use Sphinx on the database server to power search for the primary website. Ideally, this primary site would offer the ability to search against its content (posts, pages, comments, member profiles, activity updates, etc.) as well as all of the other...
Hi! I have model Products with columns: name, number, description Index defined for this model looks like this: define_index do indexes :name, :sortable => true indexes :number indexes :description where "amount > 0" has :price end Since in description can be lots of random words I want to exclude it from searching somet...
I am developing Ruby on Rails application which uses Thinking Sphinx. Unfortunately, from time to time (few times per month) search tends to return bad results (many documents missing). Reindexing helps, but this is not a solution for production. I am experiencing bad results even when I am typing simple queries into rails console (like...