Joined: 13 Jun 2010
Location: La Paz
|Posted: Sun Jun 13, 2010 9:05 am Post subject: [Bug] Special Characters Trigger MySQL Error.
|First of all, my apologies if this is not the right way to report bugs. I couldn't find any other similar forum so I though I would do it here.
I made a post in the Music forum, which contained some special characters. When I submitted the post, I got a MySQL error. Later I edited the post to fix a smiley, and I got the following MySQL message:
|Could not insert new word matches
SQL Error : 1271 Illegal mix of collations for operation ' IN '
INSERT INTO phpbb_search_wordmatch (post_id, word_id, title_match) SELECT 3021998, word_id, 0 FROM phpbb_search_wordlist WHERE word_text IN ('favorite', 'genre', 'metal', 'colors', 'forms', 'generally', 'eclectic', 'taste', 'meaning', 'everything', 'few', 'exceptions', 'bands', 'nightwish', 'temptation', 'therion', 'haggard', 'poets', 'fall', 'm?go', 'oz', 'eluveitie', 'diablo', 'swing', 'orchestra', 'sound', 'horizon', 'sigur', 'r?s', 'specific', 'order', 'except', 'always', 'goes', 'first', '1300', 'artists', 'library', 'listen', 'killing', 'fingers')
Line : 251
File : functions_search.php
I believe this is related to the fact my post included a double-doted 'a' and an accented 'o'. If I am right, this would be caused because the database doesn't have a UTF-8 character encoding. At any rate, I would expect Simple Machines Forums to automatically create a database like that, guess I was wrong .
My last post here. You may also notice that my name doesn't show as the Last Poster when you check that forum's index.
And huh, my apologies if I killed the database. I really never expected to find a MySQL error in a SMF board.