Go Back   vb.org Archive > vBulletin Modifications > Premium Modifications > vBulletin Open Source Products > Sphinx
Sphinx: does not index words consisting from national symbols Details »»
Sphinx: does not index words consisting from national symbols
Version: , by FractalizeR FractalizeR is offline
Developer Last Online: Nov 2014 Show Printable Version Email this Page

Version: Unknown Rating:
Released: 05-04-2010 Last Update: Never Installs: 0
 
No support by the author.

On my forum after installation Sphinx seem not to index words, that consist from non-latin symbols. My forum is in russian and uses Windows-1251 encoding. Do I need to tune sphinx to do that correctly?

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #2  
Old 05-04-2010, 03:44 PM
sung sung is offline
 
Join Date: Feb 2002
Posts: 36
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Yes, you need to edit stuff a bit to handle different character encodings. I couldn't say what the exact steps are since I don't use it, but maybe this link would be of some help to you?

http://sphinxsearch.com/faq.html#encoding
Reply With Quote
  #3  
Old 05-04-2010, 08:18 PM
FractalizeR's Avatar
FractalizeR FractalizeR is offline
 
Join Date: Oct 2005
Location: Russia, Moscow
Posts: 368
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

It seems, that I was trying to specify global sql_query_pre, while I needed to put in into each "source" section of configuration file. Will try now.

--------------- Added [DATE]1273009150[/DATE] at [TIME]1273009150[/TIME] ---------------

Yea, now it works.
Reply With Quote
  #4  
Old 07-05-2010, 12:49 PM
Yellow Slider Yellow Slider is offline
 
Join Date: Aug 2006
Posts: 249
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

where is the configuration file? can you please explain what did you change in order to fix that?
Reply With Quote
  #5  
Old 07-06-2010, 06:39 AM
FractalizeR's Avatar
FractalizeR FractalizeR is offline
 
Join Date: Oct 2005
Location: Russia, Moscow
Posts: 368
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Each source section should contain SET NAMES query like this:

Code:
source DBSource
{
        type                                    = mysql

        #####################################################################
        ## SQL settings (for 'mysql' and 'pgsql' types)
        #####################################################################

        sql_host                                = " . $vBSphinxSearchConfig->dbservername . "
        sql_user                                = " . $vBSphinxSearchConfig->dbusername . "
        sql_pass                                = " . $vBSphinxSearchConfig->dbpassword . "
        sql_db                                  = " . $vBSphinxSearchConfig->dbname . "
        sql_port                                = " . $vBSphinxSearchConfig->dbport . " # optional, default is 3306
        sql_query_pre = SET NAMES cp1251
        sql_query_pre = SET SESSION query_cache_type=OFF

}
Reply With Quote
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 02:06 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.14360 seconds
  • Memory Usage 2,233KB
  • Queries Executed 20 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)bbcode_code
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (5)navbar_link
  • (120)option
  • (5)post_thanks_box
  • (5)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (5)post_thanks_postbit_info
  • (4)postbit
  • (5)postbit_onlinestatus
  • (5)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete