Topic: Illegal mix of collations utf8_unicode_ci with utf8_general_ci

[Neo_TE]

Hello People

I've been using smiple portal for some time and its great.

I would like to inform a old bug that still exists in the version 2.3.3.

http://http.xyz.com/smf/index.php?
Database Error: Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation 'ifnull'

SMF 2.x uses utf8_unicode_ci collation for their database where as simple portal 2.3.3 uses utf8_general_ci collation and because of this problem, I've been forced to manually change the collation using phpMyadmin.

And this bug might be a small bug but it will really scare off newbies when they find their website to be broken.

-> Also another bug regarding the shoutbox.

The warning message in the shoutbox will go up along with the shouts when the "Reverse Order" setting is enabled.

Thanks for such a great portal.   

[AngelinaBelle]

This sounds like a very annoying problem. But it is not a SimplePortal bug.  This problem was not caused by SimplePortal. SimplePortal does not change the collation (alphabetization) of your tables.
 
As you pointed out, you can use phpMyAdmin to fix this collation problem.
Other SMF users have reported similar problems on their database. There have been discussions at http://simplemachines.org about the problem, what causes it, and how to avoid or fix it.

[ccbtimewiz]

This sounds like a very annoying problem. But it is not a SimplePortal bug.  This problem was not caused by SimplePortal. SimplePortal does not change the collation (alphabetization) of your tables.
 
As you pointed out, you can use phpMyAdmin to fix this collation problem.
Other SMF users have reported similar problems on their database. There have been discussions at http://simplemachines.org about the problem, what causes it, and how to avoid or fix it.

Did you read the top post?

Previously SimplePortal, on installation, set the collation for tables when it shouldn't have, making very particular setups break. This bug was "fixed", I remember because I was the one who reported the bug in the first place (though I can't find the bug report anymore, seems to have disappeared from both the bugs board and the bugtracker).

This bug should have been fixed but might have reemerged due to SMF 2.0 RC5

[ccbtimewiz]

Speak of the devil I found the bug report:

http://simpleportal.net/index.php?issue=327.0

[AngelinaBelle]

Hmmm.... That one was marked fixed. SimplePortal is not SUPPOSED to allow whatever collation is currently on the SMF database.
 
I see that, in some cases, install2.php still enforces utf8_general_ci collation. I will check with the devs on this one.

[Neo_TE]

Did you read the top post?

Previously SimplePortal, on installation, set the collation for tables when it shouldn't have, making very particular setups break. This bug was "fixed", I remember because I was the one who reported the bug in the first place (though I can't find the bug report anymore, seems to have disappeared from both the bugs board and the bugtracker).

This bug should have been fixed but might have reemerged due to SMF 2.0 RC5

No. we faced this problem when we upgraded from RC3 to RC4. We thought it was our installation but it wasn't.  Again we faced this problem when we upgraded from RC4 to RC5.

BTW for your info, we were first using SMF 1.x and then upgraded to SMF 2.0 RC3 and we've been facing this problem.  We installed simple portal only after upgrading to SMF 2.0 RC3 and we didn't use it in SMF 1.x.

Hmmm.... That one was marked fixed. SimplePortal is not SUPPOSED to allow whatever collation is currently on the SMF database.
 
I see that, in some cases, install2.php still enforces utf8_general_ci collation. I will check with the devs on this one.

Yeah. This is what I was talking about. I thought of changing it to utf_unicode_ci before installing the mod but I didn't try this.

Please fix this bug.

Thanks for such a great free portal.

[Neo_TE]

I think you missed the other bug in the post.

-> Also another bug regarding the shoutbox.

The warning message in the shoutbox will go up along with the shouts when the "Reverse Order" setting is enabled.

[AngelinaBelle]

It is so confusing to have another bug in the same post!
You are correct -- I did miss it. the warning text will move along with the post no matter which order is selected. You can see this right here at simpleportal.

[Neo_TE]

It is so confusing to have another bug in the same post!
You are correct -- I did miss it. the warning text will move along with the post no matter which order is selected. You can see this right here at simpleportal.

Sorry.

I didn't explain it properly.

The warning message in the shoutbox will go up along with the other shouts and will DISAPPEAR when the "Reverse Order" setting is enabled where as in the default settings it stays at the top like a sticky topic.

I hope you could understand what I'm trying to tell. 

[AngelinaBelle]

Funny -- when I use the shoutbox block here at simpleportal.net, the warning message disappears when I use the scrollbar.

[Neo_TE]

Ok Thanks.

My bad. I thought this was a bug since the warning message should be visible even when scrolling down.

Sorry for the confusion.

[AngelinaBelle]

I think it was designed that way so that, when you are looking for more shouts, the warning is not taking up valuable real estate.