PDA

View Full Version : SQL Error : 1271 Illegal mix of collations for operation ' I



phonebooth42
Feb 19, 2011, 05:42 PM
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

Drunken F00l
Feb 19, 2011, 06:02 PM
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.

Drunken F00l
Feb 19, 2011, 06:04 PM
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

phonebooth42
Feb 19, 2011, 06:15 PM
cheers dude

Drunken F00l
Feb 19, 2011, 06:52 PM
h’i “test”
? ?_?

Drunken F00l
Feb 19, 2011, 06:52 PM
It looks like I fixed the error message, though the characters might not show correctly. Stupid old forum software.

Drunken F00l
Feb 19, 2011, 06:56 PM
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.

phonebooth42
Feb 19, 2011, 07:05 PM
Cheers for sorting it out dude, hopefully won't happen again. If it doeas i know the site admin is a good n.