Vermillion
Joined: 13 Jun 2010
Posts: 6
Location: La Paz
|
 Posted: Sun Jun 13, 2010 9:10 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:
| Quote: | Could not insert new word matches
DEBUG MODE
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(double-dotted a)go', 'oz', 'eluveitie', 'diablo', 'swing', 'orchestra', 'sound', 'horizon', 'sigur', 'r(accented o)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.
NOTE: I have removed the special characters, because the first time I tried to make this thread, the post didn't go through because it triggered yet another MySQL message...
EDIT: Well, the Last Post in that thread in the Music Forum shows my name as the last poster, so I guess it fixed itself. |
|
