[ postfixadmin-Bugs-1990191 ] Illegal mix of collations

[SourceForge.net <no...@so...>]

Bugs item #1990191, was opened at 2008-06-10 21:12
Message generated for change (Comment added) made by nobody
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=937964&aid=1990191&group_id=191583

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: Database
Group: v 2.2
Status: Open
Resolution: None
Priority: 8
Private: No
Submitted By: Jon Kristian Nilsen (jonkristian)
Assigned to: Nobody/Anonymous (nobody)
Summary: Illegal mix of collations

Initial Comment:
DEBUG INFORMATION: Invalid query: Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '=' 

In virtual-list.php , it's a bug in upgrade.php see attached patch.

----------------------------------------------------------------------

Comment By: Nobody/Anonymous (nobody)
Date: 2008-08-06 19:26

Message:
Logged In: NO 

virtual-list.php 


DEBUG INFORMATION:
Invalid query: Illegal mix of collations (cp1251_general_ci,IMPLICIT) and
(latin1_swedish_ci,IMPLICIT) for operation '=' 

Please check the documentation and website for more information. 


----------------------------------------------------------------------

Comment By: Christian Boltz (christian_boltz)
Date: 2008-06-15 16:18

Message:
Logged In: YES 
user_id=593261
Originator: NO

I checked the 2.1 release again and found out that there was no collation
specified in the MySQL dump. This means that the collation 2.1 users have
in their database depends on the local MySQL settings. 
>From the postfixadmin point of view, we can just call it "random"...

I'll add a fix to upgrade.php in the next days.

----------------------------------------------------------------------

Comment By: Nobody/Anonymous (nobody)
Date: 2008-06-11 07:06

Message:
Logged In: NO 

Why is latin1_swedish_ci used instead of latin1_general_ci anyway?

----------------------------------------------------------------------

Comment By: Christian Boltz (christian_boltz)
Date: 2008-06-10 23:52

Message:
Logged In: YES 
user_id=593261
Originator: NO

It isn't that easy (because your patch would break upgrades) and changing
from latin1_swedish_ci to latin1_general_ci doesn't make a real difference,
so I tend to reject your patch.

However, let's wait what we find out in the forum thread where this bug
report came from:
https://sourceforge.net/forum/forum.php?thread_id=2039397&forum_id=676076
(The question is where the latin1_general_ci field is hidden / comes from
;-)

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=937964&aid=1990191&group_id=191583