The Arcive of Official vBulletin Modifications Site.

opl · #1 10-27-2010, 09:42 PM

Hi, my forum is case sensitive.
If i search for something that was written as : Mama, i have to search for Mama, if i search for mama it is not showing results...

same: users need to login as they was registered, i mean, if i registered as Monk, i cant login as monk, i have to login as Monk and write Monk in login or it will show that no user ;]

how to disable case sensitive in my forum? is it server's problem or what?

help...

Zachery · #2 10-28-2010, 12:50 AM

Check the character encoding on the table, what is it set to?

opl · #3 10-28-2010, 06:36 AM

On which table?
All tables ar Myisam and utf bin... all works fine , but those case sensitive is killing me

Zachery · #4 10-28-2010, 11:30 PM

utf_bin means, BINARY, which means case sensitive. You need to change it to utf8_ci

opl · #5 10-30-2010, 10:03 PM

Thank you very much for fast and pro answer.
My forum www.Pecetowiec.pl is working now as hell good

Yes. It was utf8 bin problem. I changed all tables into utf8_general_ci but it didnt helped.
I had to make backup of database, change coding in database (i opened it and changed strings in base from utf8_bin into utf8_general_ci), saved database and import via phpadmin back... Then i had to merge one user wuth other (his name was Gege and secons user was gege - small letter on begin), and i rebuilded search in maintence. Works fine now.

Thanks .

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.03660 seconds Memory Usage 2,182KB Queries Executed 13 (?)
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)ad_showthread_firstpost (1)ad_showthread_firstpost_sig (1)ad_showthread_firstpost_start (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)navbar (3)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 (5)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
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!