Stack Overflow
Stack Overflow

Questions tagged [sphinxsearch]

10 questions
0
votes
0 answers

How can I prioritize search results containing a specific term in Sphinxsearch?

I am encountering an issue with the sorting of the search results in the following Sphinxsearch query (SphinxSE). Specifically, I would like to prioritize the results containing the term "asda" and display them at the top of the list, before showing…
Mahshid H
  • 13
  • 3
0
votes
0 answers

Sphinxsearch xmlpipe2 configuration issue

Here is my sphinxsarch configuration: source mysource { type = xmlpipe2 xmlpipe_command = cat /mnt/e/sphinx/data/documents.xml xmlpipe_attr_uint = id xmlpipe_field = title xmlpipe_field = content xmlpipe_fixup_utf8 =…
maxmanus
  • 1
  • 1
0
votes
0 answers

Combination of MySQL and Sphinxsearch query

I have used SphinxSE to make a query for MySQL. In my case, I have to use two different Sphinx queries together with an OR condition. My question is how can I accurately calculate the total result based on all the individual query results. For…
Mahshid H
  • 13
  • 3
0
votes
0 answers

Query Builder for SphinxQL - access and compare columns against each other from the Match method

Am trying to search my sphinx index instance but can't seem to get it working with my current logic. Basically, am using Query Builder for SphinxQL instead of the offical API but works pretty well until I tried comparing columns against each without…
Dennisrec
  • 333
  • 2
  • 22
0
votes
1 answer

Cannot connect to Sphinx with PHP and PDO

I seem to be having issues I do not understand... I have installed MySQL 8.0.27 I have installed Sphinx, created an index, filled it and all is OK through the terminal. Am able to query the Spinx index, without issues. So searchd and the indexer are…
MrG
  • 372
  • 2
  • 13
0
votes
1 answer

Convert SphinxSearch query syntax to boolean search string in Ruby

I've been pondering over what is the easiest way to convert the following Sphinx Search query into what is commonly used in typical web searches or portals, e.g. a boolean search string, and vice versa (A | B) "C D" (E | "F G" | "H I J") ("K L" ("M…
user1320651
  • 808
  • 2
  • 15
  • 42
0
votes
1 answer

MariaDB SphinxSE not accepting weights parameter

If I try this query: select * FROM sphinx.products where `query` = "test"; it works. But if I try to give it weights it returns an error: select * FROM sphinx.products where `query` = "test;sort=extended:@weight DESC;weights=3,1,1,1"; Fails with…
Sebastián Grignoli
  • 32,444
  • 17
  • 71
  • 86
0
votes
1 answer

Sphinx Search returns less result as compared to MySql LIKE

When I try simple MySql Query select id from `contacts` where name LIKE '%abdul%' OR email LIKE '%abdul%' OR phone LIKE '%abdul%' it returns 278 records from my database where as when I search through Sphinx search like this $sphinx = new…
Abdul Rehman Aziz
  • 29
  • 7
0
votes
1 answer

sphinx search: how to understand min_prefix_len

Sorry I post my question here as I permanently get an error on the sphinxsearch forum where it belongs to. I have set min_prefix_len = 3. According to http://sphinxsearch.com/docs/current/conf-min-prefix-len.html I expect a match for val* but I do…
kklepper
  • 763
  • 8
  • 13
0
votes
1 answer

sphinix rt table schema is not updated

Using sphinxsearch 2.2, I have this schema defined in sphinx.conf: index topic { type = rt path = /var/lib/sphinxsearch/data/topic rt_field = title rt_field …
Karlom
  • 13,323
  • 27
  • 72
  • 116