Good day experts!

I configure sphinx on bitrix. He did everything according to the instructions, but he is not looking for products on the site. I checked everything - the sphinx itself works on the site. But when I got into the Sphinx query logs, I found out that there were scribbles instead of Russian words. Tried on everyone to change the coding - does not help. Here is the sphinx config file:

source lsParentSource { type = mysql sql_host = 127.0.0.1 sql_user = user sql_pass = sql_db = bookcity sql_port = 3306 sql_query_pre = SET NAMES utf8 sql_query_pre = SET SESSION query_cache_type=OFF } source books : lsParentSource { sql_query = \ SELECT * \ FROM b_search_content } index bitrix { #main settings type = rt path = C:/OpenServer/domains/www2/sphinx/data docinfo = inline #choose appropriate type of morphology to use #morphology = lemmatize_ru_all, lemmatize_en_all, lemmatize_de_all, stem_enru morphology = stem_enru, soundex #these settings are used by bitrix:search.title component dict = keywords prefix_fields = title infix_fields= min_prefix_len = 2 enable_star = 1 #all fields must be defined exactly as followed rt_field = title rt_field = body rt_attr_uint = module_id rt_attr_string = module rt_attr_uint = item_id rt_attr_string = item rt_attr_uint = param1_id rt_attr_string = param1 rt_attr_uint = param2_id rt_attr_string = param2 rt_attr_timestamp = date_change rt_attr_timestamp = date_to rt_attr_timestamp = date_from rt_attr_uint = custom_rank rt_attr_multi = tags rt_attr_multi = right rt_attr_multi = site rt_attr_multi = param #depends on settings of your site # uncomment for single byte character set charset_type = sbcs # uncomment for UTF character set #charset_type = utf-8 } indexer { mem_limit = 32M } searchd { log = C:/Sphinx/data/log/searchd.log query_log = C:/Sphinx/data/log/query.log read_timeout = 5 max_children = 30 pid_file = C:/Sphinx/data/log/searchd.pid seamless_rotate = 1 preopen_indexes = 0 unlink_old = 1 }

The base encoding is utf8_general_ci. Can someone help deal with this?

    1 answer 1

    Found a solution! I had to suffer a great deal over this. At one time, the PHPExcel library was installed on this project. The library had a requirement to set mbstring.func_overload = 2 . I did it and forgot completely. And so I decided to make a test of the system through the Bitrix API. He said that there is an error and that the same value should be returned to 0. I did it, but still the search did not work. And finally, when I accidentally visited the product page in the admin panel and saved it without making any changes, the search began to find it. All the product was flooded at mbstring.func_overload = 2 , and when I perezalil it again - it all worked!