[ postfixadmin-Bugs-1828870 ] cannot view a domain page

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

Bugs item #1828870, was opened at 2007-11-09 12:16
Message generated for change (Comment added) made by frn123
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=937964&aid=1828870&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: SVN (please specify revision!)
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: frn (frn123)
Assigned to: Nobody/Anonymous (nobody)
Summary: cannot view a domain page

Initial Comment:
using and url like 
http://foo/pa/list-virtual.php?domain=foo.com

i get a following error:
--
DEBUG INFORMATION:
Invalid query: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '='

Please check the documentation and website for more information.

Postfix Admin
Knowledge Base 
--


Using svn revision 204,
debian sarge,
mysql4-1.11a from sarge backports.
mysql driver. 

Lookind at the DATABASE_MYSQL.TXT i notice that
some of the tables are InnoDB and some MyISAM. MyISAM tables use latin_1 encodoing, InnoDB use utf8.

I think all the tables should be innodb/utf8.


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

>Comment By: frn (frn123)
Date: 2007-11-09 12:23

Message:
Logged In: YES 
user_id=1933384
Originator: YES

changing all the tables to type innodb made the bug go away with 
no apparent ill effects (yet?)

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

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