[ postfixadmin-Bugs-1990191 ] Illegal mix of collations

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

Bugs item #1990191, was opened at 2008-06-10 14: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: None
Status: Open
Resolution: None
Priority: 5
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-06-11 00: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 16: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