Search error

Got an idea for a site feature, a suggestion for an article, or spotted an error we made, feel free to post it here.
Guests can post here!
User avatar
acidbeast
Posts: 1
Joined: Wed Jan 11, 2012 10:23 pm
Contact:

Search error

Post by acidbeast » Wed Jan 11, 2012 10:31 pm

I submit russian letters into search form at knowledge pages and get error:

SELECT id,parent FROM module_knowledge WHERE ((subject LIKE '%ывыв%' OR short_desc LIKE '%ывыв%' OR message_search LIKE '%ывыв%')) AND status=1 ORDER BY parent ASC
1267: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'like' (module_knowledge.php #120)
Backtrace:
index.php #118 -> module_knowledge.php #120


p.s: I don't try search something in russian here, just was wrong keyboard language.

User avatar
Khuri
AOU Programmer/Coder
Posts: 1759
Joined: Thu Sep 29, 2005 7:57 pm
Location: Germany
Contact:

Re: Search error

Post by Khuri » Wed Jan 11, 2012 11:16 pm

The database doesn't like those symbols as search-words in the configuration.
But thanks for the info, i'll add a filter tomorrow so the search doesn't accept these chars at all anymore.

User avatar
Khuri
AOU Programmer/Coder
Posts: 1759
Joined: Thu Sep 29, 2005 7:57 pm
Location: Germany
Contact:

Re: Search error

Post by Khuri » Thu Jan 12, 2012 11:03 am

That problem should be gone now :)

Locked