Simple Machines Community Forum

SMF Support => SMF 2.0.x Support => Topic started by: fapencio on April 24, 2015, 02:14:17 PM

Title: search box is sensitive to "accents", please help
Post by: fapencio on April 24, 2015, 02:14:17 PM
Hello, I seek help, my forum has enabled the Spanish language, if you ask me why I'm asking for help in this forum English language, it is because in the help forum in Spanish moderators (I think they are Argentine) ignore my messages just because I am from Mexico,
in the Spanish language there are words that carry a sign called "accent" in the syllable that takes more strength to speak it, that sign is this: '
the search box of the forum is sensitive to accents, so it is not the same type the word "Mexico" that "México" and for obvious reasons all answers are not shown in each search, please I need this search box is like google, as many of the forum users when looking for something in the search box, write it without the accent mark, and therefore do not find what they want,

I hope I've given to understand and appreciate all help in advance and thanks again
Title: Re: search box is sensitive to "accents", please help
Post by: margarett on April 24, 2015, 02:41:01 PM
Actually MySQL should naturally replace the accented/non-accented in SELECT queries... I just performed a test in my local forum and it worked. México and Mexico behave the same.

But if I do the same test here in this forum, it works as you say. I guess it has to do with the type of search index you have?. So what kind of search index you have? :P
index.php?action=admin;area=managesearch;sa=method

edit: this was uncalled for, please don't go down this path...
Quotet is because in the help forum in Spanish moderators (I think they are Argentine) ignore my messages just because I am from Mexico,
Title: Re: search box is sensitive to "accents", please help
Post by: fapencio on April 24, 2015, 03:04:55 PM
Quote from: margarett on April 24, 2015, 02:41:01 PM
Actually MySQL should naturally replace the accented/non-accented in SELECT queries... I just performed a test in my local forum and it worked. México and Mexico behave the same.
But if I do the same test here in this forum, it works as you say. I guess it has to do with the type of search index you have?. So what kind of search index you have? :P
index.php?action=admin;area=managesearch;sa=method

(https://www.simplemachines.org/community/proxy.php?request=http%3A%2F%2Fi19.servimg.com%2Fu%2Ff19%2F18%2F92%2F31%2F95%2Fsearch10.jpg&hash=60bc184b7695c10abe37f5d723240f231930774c)

help, thanks in advance
Title: Re: search box is sensitive to "accents", please help
Post by: margarett on April 24, 2015, 03:12:40 PM
Nop, same result in my test forum :(

Are you using UTF8 or latin?
Title: Re: search box is sensitive to "accents", please help
Post by: fapencio on April 24, 2015, 03:26:42 PM
Quote from: margarett on April 24, 2015, 03:12:40 PM
Nop, same result in my test forum :(

Are you using UTF8 or latin?

yes, UTF8, and the language is Spanish ES and Spanish Latiin

thanks Margarett, help me please :D
Title: Re: search box is sensitive to "accents", please help
Post by: margarett on April 24, 2015, 04:10:43 PM
I wish I could :(

I honestly don't know what can be the problem...
Title: Re: search box is sensitive to "accents", please help
Post by: fapencio on April 24, 2015, 04:28:03 PM
Quote from: margarett on April 24, 2015, 04:10:43 PM
I honestly don't know what can be the problem...

:(

anybody help me
Title: Re: search box is sensitive to "accents", please help
Post by: Kindred on April 24, 2015, 06:03:23 PM
Please do not bump your post like that.

margarett has posted -- but it may take some time for anyone else to see/read/respond.

Are you **SURE** that your forum *AND* database are actually UTF8?
Title: Re: search box is sensitive to "accents", please help
Post by: fapencio on April 24, 2015, 06:49:20 PM
Quote from: Kindred on April 24, 2015, 06:03:23 PM
Are you **SURE** that your forum *AND* database are actually UTF8?

yes, my forum yes, but my database i dont know, how i can check this?

(https://www.simplemachines.org/community/proxy.php?request=http%3A%2F%2Fi19.servimg.com%2Fu%2Ff19%2F18%2F92%2F31%2F95%2Fcaptur10.jpg&hash=1c81d2c6db8f229ce341e1f9173cb955bc74fd62)
Title: Re: search box is sensitive to "accents", please help
Post by: margarett on April 24, 2015, 06:54:13 PM
In phpmyadmin. Each table and each text field inside each table has its own collation ;)
Title: Re: search box is sensitive to "accents", please help
Post by: fapencio on April 24, 2015, 07:13:10 PM
Quote from: margarett on April 24, 2015, 06:54:13 PM
In phpmyadmin. Each table and each text field inside each table has its own collation ;)

this?:

(https://www.simplemachines.org/community/proxy.php?request=http%3A%2F%2Fi19.servimg.com%2Fu%2Ff19%2F18%2F92%2F31%2F95%2Fcaptur11.jpg&hash=ca5799a8b5057400b50813ee99cb7dba755c041b)

is ok?
Title: Re: search box is sensitive to "accents", please help
Post by: Kindred on April 24, 2015, 07:25:39 PM
what is the URL?
Title: Re: search box is sensitive to "accents", please help
Post by: fapencio on April 24, 2015, 07:38:42 PM
Quote from: Kindred on April 24, 2015, 07:25:39 PM
what is the URL?

in my profile, i change the url, now this is the actual url
Title: Re: search box is sensitive to "accents", please help
Post by: Kindred on April 24, 2015, 08:07:13 PM
ummmm... what? I see no links in your profile
Title: Re: search box is sensitive to "accents", please help
Post by: fapencio on April 24, 2015, 08:30:39 PM
Quote from: Kindred on April 24, 2015, 08:07:13 PM
ummmm... what? I see no links in your profile

(https://www.simplemachines.org/community/proxy.php?request=http%3A%2F%2Fi19.servimg.com%2Fu%2Ff19%2F18%2F92%2F31%2F95%2Fcaptuw10.jpg&hash=f7130f0127f94dce734713414435e36dbbc8f4f1)
Title: Re: search box is sensitive to "accents", please help
Post by: Kindred on April 24, 2015, 08:49:42 PM
OMG!   I am surprised that anything works on that forum, given all of the conflicting and overlapping javascripts...
Title: Re: search box is sensitive to "accents", please help
Post by: fapencio on April 24, 2015, 08:52:06 PM
Quote from: Kindred on April 24, 2015, 08:49:42 PM
OMG!   I am surprised that anything works on that forum, given all of the conflicting and overlapping javascripts...
I turned off the errors log
Title: Re: search box is sensitive to "accents", please help
Post by: fapencio on April 27, 2015, 02:01:52 AM
up
Title: Re: search box is sensitive to "accents", please help
Post by: fapencio on April 28, 2015, 06:11:03 PM
up :D
Title: Re: search box is sensitive to "accents", please help
Post by: fapencio on May 06, 2015, 11:09:04 AM
help please :D
Title: Re: search box is sensitive to "accents", please help
Post by: Kindred on May 06, 2015, 11:12:03 AM
Do the accented characters work here on SimpleMachines.org?
do they work on another Spanish language system?

If so, then I fear your issues are related to the numerous errors that I noticed and that your best solution would be to make a clean installation of SMF and apply your hacks and modifications one ata time until you find out which one is causing the failure
Title: Re: search box is sensitive to "accents", please help
Post by: Night09 on May 06, 2015, 12:02:49 PM
Actually as it is the SMF copyright is illegible and appears to be caught in a script. If the page is zoomed and moused over it runs the cursor continuously. Zooming has no effect on size of the copyright so effectively it appears unreadable.

It is a requirement of this forum to have it present and readable if you seek support from the team.
Title: Re: search box is sensitive to "accents", please help
Post by: Kindred on May 06, 2015, 12:10:29 PM
well, it is the general consensus...

but anyway... as I saidm the site has so many overlapping and conflicting javascripts loaded that I am surprised that ANYTHING works on the site at all...   it looks like code was thrown at it with a paintball gun...
Title: Re: search box is sensitive to "accents", please help
Post by: Night09 on May 06, 2015, 12:13:41 PM
I didnt think it was going to load so left it for a few mins. Its really bad and your right over starting from scratch and rework it with more caution so the issues can be corrected. I hope fapencio can see it from this point of view.
Title: Re: search box is sensitive to "accents", please help
Post by: Illori on May 06, 2015, 12:21:16 PM
Quote from: Kindred on May 06, 2015, 11:12:03 AM
Do the accented characters work here on SimpleMachines.org?

considering that this forum does not use the default search feature testing here would not be a valid test.