SQL Error : 1271 Illegal mix of collations for operation ' I - Printable Version
+- SourceOP (http://forums.sourceop.com)
+-- Forum: SourceOP Plugin (http://forums.sourceop.com/SourceOP-Plugin-forum)
+--- Forum: General Chat (http://forums.sourceop.com/General-Chat-forum)
+---- Forum: Bugs/Problems (http://forums.sourceop.com/Bugs-Problems-forum)
+---- Thread: SQL Error : 1271 Illegal mix of collations for operation ' I (/SQL-Error-1271-Illegal-mix-of-collations-for-operation-I-thread)
+- SourceOP (http://forums.sourceop.com)
+-- Forum: SourceOP Plugin (http://forums.sourceop.com/SourceOP-Plugin-forum)
+--- Forum: General Chat (http://forums.sourceop.com/General-Chat-forum)
+---- Forum: Bugs/Problems (http://forums.sourceop.com/Bugs-Problems-forum)
+---- Thread: SQL Error : 1271 Illegal mix of collations for operation ' I (/SQL-Error-1271-Illegal-mix-of-collations-for-operation-I-thread)
SQL Error : 1271 Illegal mix of collations for operation ' I - phonebooth42 - Feb 19, 2011
wont post topic due to SQL Error : 1271 Illegal mix of collations for operation ' IN '
even though i can assure you wat im typin is english as it is the only language i speak. and i am usin the correct grammer as i have spellchecked it several times. Why wont it post!
ps ive had to use slang in this as it wont post here unless i do
SQL Error : 1271 Illegal mix of collations for operation ' I - Drunken F00l - Feb 19, 2011
It's the character you are trying to use for the apostrophe in don't.
Pro tip: You'll get this message, but the post is posted anyways.
I'll fix this when I can.
SQL Error : 1271 Illegal mix of collations for operation ' I - Drunken F00l - Feb 19, 2011
It also appears like the currency symbol is part of the issue.
I deleted all the threads you created except for this one:
http://www.sourceop.com/modules.php?name=Forums&file=viewtopic&p=247454&highlight=#247454
SQL Error : 1271 Illegal mix of collations for operation ' I - phonebooth42 - Feb 19, 2011
cheers dude
SQL Error : 1271 Illegal mix of collations for operation ' I - Drunken F00l - Feb 19, 2011
h’i “test”
? ?_?
SQL Error : 1271 Illegal mix of collations for operation ' I - Drunken F00l - Feb 19, 2011
It looks like I fixed the error message, though the characters might not show correctly. Stupid old forum software.
SQL Error : 1271 Illegal mix of collations for operation ' I - Drunken F00l - Feb 19, 2011
h’i “test”
? ?_?
Hmm looks like the display issue is fixed now too. Thanks for bringing this up (I know others have and thanks to them too).
Edit:
To anyone coming across this thread by searching, the problem came up after switching web servers. I believe this changed the default character set mysql was using. I converted all of the relevant phpbb/nuke tables (posts, search, private messages) to the new default collation (see the mysql collation_ variable) which was utf8_general_ci and previously latin1_swedish_ci. You have to convert the table, and not just set the default. When I converted, I ended up with duplicate keys in the wordlist table. I resolved this by temporarily closing the forum, dumping the data, dropping the table, and reinserting it using INSERT IGNORE with no collation specified (so that it would use the default).
I also changed languages/lang-english.php to define _CHARSET as UTF-8.
SQL Error : 1271 Illegal mix of collations for operation ' I - phonebooth42 - Feb 19, 2011
Cheers for sorting it out dude, hopefully won't happen again. If it doeas i know the site admin is a good n.