Posts: 84
Threads: 24
Joined: Jan 28, 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
Posts: 5,877
Threads: 182
Joined: Dec 11, 2004
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.
Posts: 5,877
Threads: 182
Joined: Dec 11, 2004
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...ht=#247454
Posts: 84
Threads: 24
Joined: Jan 28, 2011
Posts: 5,877
Threads: 182
Joined: Dec 11, 2004
Posts: 5,877
Threads: 182
Joined: Dec 11, 2004
It looks like I fixed the error message, though the characters might not show correctly. Stupid old forum software.
Posts: 5,877
Threads: 182
Joined: Dec 11, 2004
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.
Posts: 84
Threads: 24
Joined: Jan 28, 2011
Cheers for sorting it out dude, hopefully won't happen again. If it doeas i know the site admin is a good n.
