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!
-
acidbeast
- Posts: 1
- Joined: Wed Jan 11, 2012 10:23 pm
-
Contact:
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.
-
Khuri
- AOU Programmer/Coder
- Posts: 1759
- Joined: Thu Sep 29, 2005 7:57 pm
- Location: Germany
-
Contact:
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.
-
Khuri
- AOU Programmer/Coder
- Posts: 1759
- Joined: Thu Sep 29, 2005 7:57 pm
- Location: Germany
-
Contact:
Post
by Khuri » Thu Jan 12, 2012 11:03 am
That problem should be gone now