I get this error
-------------------------------------
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 224033, word_id, 0 FROM phpbb_search_wordlist WHERE word_text IN ('first', 'attempt', 'using', 'sony', 'a7r', 'iii', '?lens', 'amscope', 'objective', 'lens', 'flash', 'kuangren', 'twins', '?na', '25', 'number', 'pictures', 'step', 'size', 'um', 'stacked', 'wemacro', 'affinity', 'photo')
Line : 251
File : functions_search.php
-----------------------
Any idea why?
Can not add a new post
Moderators: rjlittlefield, ChrisR, Chris S., Pau
- rjlittlefield
- Site Admin
- Posts: 23626
- Joined: Tue Aug 01, 2006 8:34 am
- Location: Richland, Washington State, USA
- Contact:
The place to look for problems is where that "?" appears in the list of words. In this case it's at '?lens' and '?na'.
The underlying issue is that for historical reasons the forum database uses a character set named "latin1" (description: https://en.wikipedia.org/wiki/ISO/IEC_8859-1). latin1 is only a subset of Unicode. If a post uses any Unicode characters that are not contained in latin1, then the post will preview OK but produce the message about "Illegal mix of collations" when it gets Submit'ed and stored in the database.
It's a very annoying problem that was caused by a change in the PHP specification several years ago. If you're curious, see the 3-page discussion at http://www.photomacrography.net/forum/v ... hp?t=25154 .
--Rik
The underlying issue is that for historical reasons the forum database uses a character set named "latin1" (description: https://en.wikipedia.org/wiki/ISO/IEC_8859-1). latin1 is only a subset of Unicode. If a post uses any Unicode characters that are not contained in latin1, then the post will preview OK but produce the message about "Illegal mix of collations" when it gets Submit'ed and stored in the database.
It's a very annoying problem that was caused by a change in the PHP specification several years ago. If you're curious, see the 3-page discussion at http://www.photomacrography.net/forum/v ... hp?t=25154 .
--Rik