Questions tagged [Sphinx] (399)

2
answers

Why may not work for wordforms Sphinx RealTime indexes?

Started small, has opened an official article about wordforms and created exactly as shown in the example: https://sphinxsearch.com/blog/2014/12/04/how-to-us... My config was:indexer { mem_limit = 128M } searchd { listen = 9312 listen = 9306:mysql41 log = /var/log/sphinx/searchd.log query_log = /var/log/sphinx/query....
Buck.Weima asked March 24th 20 at 13:51
1
answer

How to customize the index and search to just looking for exact substring like "%test%"?

It is necessary that the Sphinx was just working as like in mysql and looking for the occurrence of exactly the specified string, up to the spaces, dots and so on. For example:where field like "%toaster really cool site!!1,.%" It is necessary that nothing marchelos and is not replaced, but just dutifully looked up all of th...
candida93 asked March 24th 20 at 13:50
1
answer

How to search for multiple matches grouped by some field?

Equivalent to sql:select distinct group_id, text from index_1 as i1 where text like '%search_text_1%' and exists (select 1 from index_1 as i2 where i2.group_id = i1.group_id and i2.text like '%search_text_2%') Attempt on the Sphinx:select group_id, text from index_1 where match('@text %search_text_1%') ...? group by group...
Thelma asked March 24th 20 at 13:07
1
answer

Why MySQL (Sphinx) gives such strange results?

A Sphinx index with a field uint - common_id, which is supposed to do the sorting, trying to make a request:select common_id from item_ru group by common_id;I get very strange results:+-----------+ | common_id | +-----------+ | 1 | | 201 | | 401 | | 801 | | 1601 | | 1201 | | 1401 | | 1001 | | 601 | | 1801 | | 2001 | | 2201 ...
kayli64 asked March 24th 20 at 11:36
2
answers

Why Sphinx not looking for in Russian?

Sphinx searches for Latin and Cyrillic – no. The DB encoding is UTF – 8 Unicode (utf8) comparison – utf8_unicode_ci is a.Search example in Latin:Request: SELECT * FROM `category` WHERE MATCH('mol') LIMIT 10In the log Sphinx: [Mon Mar 24 18:37:43.275 2019] 0.000 sec 0.000 sec [ext2/0/ext 2 (0,10)] [category] molThe result:...
miller_Rosenbaum asked March 24th 20 at 10:51
1
answer

How to make word forms sphinx in Bitrix web environment?

The server is running Bitrix web environment the Bitrix virtual appliance version 7.3.4 Set up sphinx for the manual: https://dev.1c-bitrix.ru/learning/course/index.php... did the reindex, the search earned in the log of the Sphinx falling search queries. now we need to configure the forms, made the file: /etc/sphinx/...
carley3 asked March 24th 20 at 10:03
1
answer

Can Sphinx to search for arbitrary strings in the XML files?

I ran a search on Sphinx. Mordovskie files are converted in text advance. Everything works fine. But there was such task: it is necessary to look quite inhuman data in specific XML files. But words in human languages, they include a lot of cuts and tags. Well, reduction is clear, they also index. But also, customers need to...
Josiane.Vo asked March 23rd 20 at 20:20
1
answer

Why sql_attr_uint Directive and what does it do?

Actually, a subject. In the documentation it is written that she cleans the sign of the integer, such as, but not understand why it is so commonly used in all configs on the Internet and why you need it at all.
lauretta_Tremblay35 asked March 21st 20 at 13:26
1
answer

How to adjust the sphinx?

There is a table on which there is search with sphinx In the first line we have a phrase: Big deal, Russian Second: Russian, Big deal I want to search searched on words and phrases separated by a comma, the Word is Russian and the phrase Big deal should not interact in any way among themselves. When you enter the query: Rus...
Tod.Swaniaws asked March 21st 20 at 12:51
2
answers

How do I output the result with some negatives?

A simple query$sphinx = new SphinxClient; $sphinx->SetServer('localhost', 9312); $sphinx->SetConnectTimeout(1); $sphinx->SetSortMode ( SPH_SORT_ATTR_DESC, "id_film" ); $sphinx->SetLimits ( $start_pos, $perpage ); $result = $sphinx->Query($q, 'p_index'); When $q="something"; then it works, but when I got a...
Brooklyn.Corkery asked March 20th 20 at 11:16