Not signed in (Sign In)

Categories

Vanilla 1.1.5 is a product of Lussumo. More Information: Documentation, Community Support.

Help keep Vanilla free:
Welcome Guest!
Want to take part in these discussions? If you have an account, sign in now.
If you don't have an account, apply for one now.

General Support & Troubleshooting: Problem with collation in vanilla 1.0.1

Bottom of Page

1 to 9 of 9

  1.  
    •  
      CommentAuthorDinoboff
    • CommentTimeAug 21st 2006 edited
     # 1
    I go that message when try to login on a testing forum. I suppose I just need to change the collation of my vanilla tables.
    But is there not a way to do that while the installation?


    A fatal, non-recoverable error has occurred



    Technical information (for support personel):


    Error Message

    An error occurred while attempting to validate your credentials

    Affected Elements

    Authenticator.Authenticate();

    The error occurred on or near:
    Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='

    For additional support documentation, visit the Lussumo Documentation website at: lussumo.com/docs


    •  
      CommentAuthorMax_B
    • CommentTimeAug 21st 2006
     # 2
    When creating you database, before running the install script, you should declare the database as being of DEFAULT utf8 encoding. From hte message it looks yours is latin1.

    Also be sure to use latest SVN mods from Mark about "SET names utf8"
    •  
      CommentAuthorMark
    • CommentTimeAug 21st 2006
     # 3
    @Max_B: I had to remove those lines from the core because they were causing lots of problems for people. Look at the Vanilla 1.0.1 issues discussion.
    •  
      CommentAuthorDinoboff
    • CommentTimeAug 21st 2006 edited
     # 4
    @MaxB: It is what I did, I remember you were talking about that on the dev forum, and it is working fine.

    There is no way to set the table in utf8 were creating it, rather than asking user to make it by default?
    •  
      CommentAuthorMax_B
    • CommentTimeAug 21st 2006
     # 5
    @dinoboff: Sure there is, but then you must add to the SQL request.
    Do you want to edit it by hand or what?

    @Mark: this is too bad because the longer people are using Vanilla as it is now, the more difficult will be the cure.
    Current implementation of 1.0 sotre any non ascii chars in uft8, with an unwanted latin1 transcoding: Vanilla send utf8 chars, MySQL wants utf8 but incorrectly state, from PHP default setting, that it receive latin1, then it transcode them and store non-sense chars. It works because the reverse transcoding occurs when the base is read. But there are unsane contents and they will be painful to cleanup. ?
    •  
      CommentAuthorMark
    • CommentTimeAug 21st 2006
     # 6
    I'm thinking of putting the code back in, but also having it depend on a configuration setting - that way people who want to use it, can.
    •  
      CommentAuthorMax_B
    • CommentTimeAug 21st 2006
     # 7
    Yes, this is a good way to be clean and let current bases migrate when they want.
    •  
      CommentAuthorDinoboff
    • CommentTimeAug 22nd 2006 edited
     # 8
    In setup/installer.php, could we add:mysql_query('ALTER DATABASE `' . $DBName . '` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci', $Connection);
    •  
      CommentAuthorMax_B
    • CommentTimeAug 22nd 2006
     # 9
    I posted a test script on Vanilla Dev, to help sort this out.

1 to 9 of 9

  1.  
Add your comments
    Username Password
  • Format comments as
 
Back to Discussions Top of Page