Weird Symbols (UTF8 Encoding)
View previous topic | View next topic >
Post new topic Reply to topic
M.A.I.L. Forum Index -> M.A.I.L. Help
   
Author Message

Joined: August 30, 2008
Posts: 3119
Submissions: 20
Location: Burlington, ON, Canada

Weird Symbols (UTF8 Encoding)
Reply with quote
Posted on Fri Jun 10, 2016 4:48 am
Link to Post: 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

Reply with quote
Posted on Fri Jun 10, 2016 12:07 pm
Link to Post: Link to Post

Testing for the sake of testing:
éèêë?
ÉÈÊË?
?????

Joined: June 20, 2012
Posts: 329
Submissions: 22
Location: France

Reply with quote
Posted on Fri Jun 10, 2016 12:07 pm
Link to Post: 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

Reply with quote
Posted on Fri Jun 10, 2016 7:37 pm
Link to Post: 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"... -_-



Post new topic Reply to topic
Jump to:  
Page 1 of 1
All times are GMT. The time now is Tue Dec 10, 2019 9:33 pm
M.A.I.L. Forum Index -> M.A.I.L. Help
Display posts from previous: