Author |
Message |
|
Joined: August 30, 2008 Posts: 3119 Submissions: 20 Location: Burlington, ON, Canada
|
Weird Symbols (UTF8 Encoding) |
|
Posted on Fri Jun 10, 2016 4:48 am |
Link to Post:  |
|
Hey Folks,
Database got upgraded by the host... Mucked some character encoding up due to the age of our database structure.
I've put a fix in place, so any weird symbols you may have noticed over the last ~24 Hours should have disappeared...
Let me know if anyone sees any side effects.
|
|
|
Joined: June 20, 2012 Posts: 329 Submissions: 22 Location: France
|
|
|
Posted on Fri Jun 10, 2016 12:07 pm |
Link to Post:  |
|
Testing for the sake of testing:
éèêë?
ÉÈÊË?
????? |
|
|
Joined: June 20, 2012 Posts: 329 Submissions: 22 Location: France
|
|
|
Posted on Fri Jun 10, 2016 12:07 pm |
Link to Post:  |
|
While posting the above post, I got this error message:
Quote: |
Could not insert new word matches
DEBUG MODE
SQL Error : 1271 Illegal mix of collations for operation ' IN '
INSERT INTO search_wordmatch (post_id, word_id, title_match) SELECT 240526, word_id, 0 FROM search_wordlist WHERE word_text IN ('testing', 'sake', 'xxxxx', 'xxxxx', 'xxxxx')
Line : 251
File : functions_search.php
|
xxxxx are the three test lines, displayed correctly in the message.
1st: 'e' lower case with acute, grave, circumflex, ulmaut, macron accents.
2nd: 'E' upper case with acute, grave, circumflex, ulmaut, macron accents.
3rd: a i u e o in japanese |
|
|
Joined: August 30, 2008 Posts: 3119 Submissions: 20 Location: Burlington, ON, Canada
|
|
|
Posted on Fri Jun 10, 2016 7:37 pm |
Link to Post:  |
|
Shirluban wrote: | While posting the above post, I got this error message:
Quote: |
Could not insert new word matches
DEBUG MODE
SQL Error : 1271 Illegal mix of collations for operation ' IN '
INSERT INTO search_wordmatch (post_id, word_id, title_match) SELECT 240526, word_id, 0 FROM search_wordlist WHERE word_text IN ('testing', 'sake', 'xxxxx', 'xxxxx', 'xxxxx')
Line : 251
File : functions_search.php
|
xxxxx are the three test lines, displayed correctly in the message.
1st: 'e' lower case with acute, grave, circumflex, ulmaut, macron accents.
2nd: 'E' upper case with acute, grave, circumflex, ulmaut, macron accents.
3rd: a i u e o in japanese |
Fix one, another breaks...
I'll dig into it, and see if it left a trace in the error log.
The version of phpBB that this site uses is become more "problem patch" than "phpBB code"... -_-
|
|
|