Simple Machines Community Forum

SMF Support => SMF 2.0.x Support => Topic started by: Rain Forest on December 28, 2014, 07:50:51 AM

Title: [SMF 2.0.8] Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and .. ERROR
Post by: Rain Forest on December 28, 2014, 07:50:51 AM
People on my forums are complaining that their username + ascii code (e.g. this ascii sign: ♥) are giving them '?' instead of the ascii sign/code. After I tried it myself I got the following error.

Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'like'
File: /home/.../Sources/Subs-Members.php
Line: 1006


As I am a rookie in Database or advanced coding I have no idea what to do. My forum has always been with UTF-8 characters (if it's any helpfull).

hopefully someone could help me :)

Subs-members.php is added as attachment.
Title: Re: [SMF 2.0.8] Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and .. ERROR
Post by: Kindred on December 28, 2014, 09:40:18 AM
look in your database and confirm that all of the tables AND columns are indeed UTF8
Title: Re: [SMF 2.0.8] Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and .. ERROR
Post by: Rain Forest on December 28, 2014, 12:32:51 PM
Is there a simple query to convert all tables to utf8?

E.g
ALTER TABLE ALL CONVERT TO CHARACTER SET utf8;

Just checked it and saw that all it are UTF8..
Title: Re: [SMF 2.0.8] Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and .. ERROR
Post by: Kindred on December 28, 2014, 01:55:53 PM
Quote from: Kindred on December 28, 2014, 09:40:18 AM
... AND columns...
Title: Re: [SMF 2.0.8] Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and .. ERROR
Post by: Rain Forest on December 28, 2014, 02:00:07 PM
Quote from: Kindred on December 28, 2014, 01:55:53 PM
Quote from: Kindred on December 28, 2014, 09:40:18 AM
... AND columns...

Any link/tut how to do that?

Quote from: Dragon Fruit on December 28, 2014, 07:50:51 AM
As I am a rookie in Database or advanced coding I have no idea what to do.
Title: Re: [SMF 2.0.8] Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and .. ERROR
Post by: Kindred on December 28, 2014, 02:11:53 PM
http://stackoverflow.com/questions/6050014/how-do-you-change-the-collation-type-for-a-mysql-column



Title: Re: [SMF 2.0.8] Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and .. ERROR
Post by: Rain Forest on December 28, 2014, 02:19:03 PM
All colums are latin1_swedish indeed..

I have no clue, even on that link how to change/convert all colums to UTF8.. :(
Title: Re: [SMF 2.0.8] Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and .. ERROR
Post by: Kindred on December 28, 2014, 03:20:33 PM
I believe that the subcommand, after the alter statement is convert
Title: Re: [SMF 2.0.8] Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and .. ERROR
Post by: Rain Forest on December 28, 2014, 05:01:34 PM
Errr, ok. :P

In English?
Title: Re: [SMF 2.0.8] Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and .. ERROR
Post by: Horme Gaming on January 12, 2015, 07:34:59 PM
Dragon Fruit do you still need help with this?  If so can you tell us what else you have tried please :D