#29 cannot view a domain page

closed-fixed
nobody
Database (41)
9
2013-12-01
2007-11-09
frn
No

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.

Discussion

  • frn

    frn - 2007-11-09

    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?)

     
  • Christian Boltz

    Christian Boltz - 2007-11-17

    Logged In: YES
    user_id=593261
    Originator: NO

    Using utf8 everywhere is a bad idea - it wastes some space (a char needs 3 bytes in utf8) and, biger problem, causes problems with the key length in vacation_notification (see bug 1828857).

    I'll change fields for email addresses to latin1 - mail adresses can't contain utf8 anyway.

    OTOH, the description fields should really be utf8 because people can enter anything they want there.

     
  • Christian Boltz

    Christian Boltz - 2008-03-04
    • priority: 5 --> 9
     
  • Christian Boltz

    Christian Boltz - 2008-04-06

    Logged In: YES
    user_id=593261
    Originator: NO

    This should be fixed in the latest SVN version (r319). Can you please test it by running upgrade.php?

    Note: I can't guarantee a clean update. If something goes wrong (you'll see an "Invalid query" message in this case), please drop the table vacation_notification (it contains a list of mail adresses who have received vacation notifications already, so the worst thing that might happen is that some of them receive another one when sending the next mail).

     
  • Christian Boltz

    Christian Boltz - 2008-04-25

    Logged In: YES
    user_id=593261
    Originator: NO

    Fix verified in latest SVN version (r343) by creating a new database.

     
  • Christian Boltz

    Christian Boltz - 2008-04-25
    • status: open --> closed-fixed
     

Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

JavaScript is required for this form.





No, thanks